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.
- 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
- 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.
- 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.
- 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
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.