- Active PartsLedger subscription
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, enter a Per Unit Value (only if adding new inventory), 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. Note: For best results, remove any currency symbols ($) from the per_unit_value field and make sure data is in 0.00 format.
- 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
Say you received a package of 12EA for $12 but find that the package you ordered actually contained 10EA for the same $12. You need to adjust the Actual Quantity down to 10 and leave the Per Unit Value and Balancing Account blank. This allows you to keep the FIFO bucket value constant and adjust the per unit value, from $1/EA to $1.20 EA, rather than keep the per unit value the same and adjust the total dollar value of your inventory.
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 could 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.