Prerequisites
Active PartsLedger subscription
Procedure
Post an adjustment for a single part number
- Navigate to Products → Inventory Tools → New Adjustment
- Change the warehouse code in the dropdown at the top of the page (next to your company and user name) to match the warehouse for which you're making the adjustment
- Enter the Part Number and UOM (unit of measurement) to see the existing inventory (and FIFO buckets, if applicable)
- Select a line item to adjust. If adding new quantity to a warehouse that has none, click New Inventory
- Adjust the Actual Quantity to match your physical quantity, select a Variance Reason, and select the appropriate Balancing Account (usually COGS or Inventory Adjustments, ask your accountant if unsure what to choose)
- Click Post Adjustment
Post a bulk adjustment
- Navigate to Tools → Imports and Exports
- Click Bulk Inventory Adjustment from the menu
- Download the Import Template File and open it in Excel or another spreadsheet application
- Clear out rows two and three and insert your data into the sheet
- Enter the part number and warehouse (facility) code pairings to update inventory across multiple warehouses at once
- Enter only the adjustment_quantity: 5 to increase PartsLedger's inventory by 5, or -7 to decrease PartsLedger's inventory by 7. qoh and physical_qty are not required
- Enter the uom (unit of measure), which is nearly always EA
- Enter the per_unit_value if different from what PartsLedger has stored, or if adding inventory to a warehouse that currently has none
- Enter the inventory date, typically today, in yyyy-mm-dd format
- Enter the exact name of the balancing account GL. Ask your accountant if you're unsure which this is
- Save the file as a .csv
- Back on the Bulk Inventory Adjustments page, choose the file that you saved, confirm the date format, and click Import Inventory Adjustment
Notes
- If the bulk import page times out (504 Gateway Timeout), which can happen on large datasets, open a new tab and navigate to Enterprise Setup ➔ Events and watch for a confirmation that the adjustment has completed. Do not resubmit your data or you will get duplicates. The 504 error means that the operation is taking longer to complete than your web browser has the patience for -- the adjustments are still happening on the server, and the Events page will eventually let you know when it is complete