Pull PartsLedger's Quantity On Hand

  • Navigate to Tools ➔ Imports and Exports
  • Select the Bulk Inventory Adjustment menu item
  • Click Download Populated Template File With All Products
  • A CSV file will be emailed to the email address in your user profile. Check your spam folder if you do not receive the email.

Note:

  • The CSV file contains a row for each part, facility, and unit combination where some quantity is on hand.
  • You will have to add rows to the file if adding physical quantity that PartsLedger doesn't yet know about.
  • You can open this file in your preferred spreadsheet application so long as you export or save as a CSV file.

Enter Your Physical Inventory Quantity

  1. Add the actual counted quantity to the physical_qty column for each part and location. Note: It may be easier to enter quantities by sorting the data by facility_code and entering one location at a time, rather than each part.
  2. Leave the column for per_unit_value blank if you are subtracting quantity from an existing amount, since PartsLedger remembers the dollar value of the quantity on hand.
  3. 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.
  4. Enter the inventory date, typically today, in yyyy-mm-dd format
  5. Enter the exact name of the balancing account GL. Ask your accountant if you're unsure which this is
  6. Save the file as a .csv
  7. Back on the Bulk Inventory Adjustments page, choose the file that you saved, confirm the date format, and click Import Inventory Adjustment

Note: You may want to split the file into pieces and import small sections one at a time, especially if this is your first time creating one of these files. This can help minimize data entry mistakes to a small number of rows.

Did this answer your question?