Prerequisites

Active PartsLedger subscription

Procedure

Post an adjustment for a single part number

  1. Navigate to Products → Inventory Tools → New Adjustment
  2. 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
  3. Enter the Part Number and UOM (unit of measurement) to see the existing inventory (and FIFO buckets, if applicable)
  4. Select a line item to adjust. If adding new quantity to a warehouse that has none, click New Inventory
  5. 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)
  6. Click Post Adjustment

Post a bulk adjustment

  1. Navigate to Tools → Imports and Exports
  2. Click Bulk Inventory Adjustment from the menu
  3. Download the Import Template File and open it in Excel or another spreadsheet application
  4. Clear out rows two and three and insert your data into the sheet
  5. Enter the part number and warehouse (facility) code pairings to update inventory across multiple warehouses at once
  6. 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
  7. Enter the uom (unit of measure), which is nearly always EA
  8. Enter the per_unit_value if different from what PartsLedger has stored, or if adding inventory to a warehouse that currently has none
  9. Enter the inventory date, typically today, in yyyy-mm-dd format
  10. Enter the exact name of the balancing account GL. Ask your accountant if you're unsure which this is
  11. Save the file as a .csv
  12. 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
Did this answer your question?