Summary

If you count your inventory using hand-held devices or input the counts into an electronic spreadsheet, you can import your count information from a comma-separated value (.csv) file. In order to process physical inventory you will need to have a Shrinkage and Overage Category type set up.

Step by Step

1     Create a new Physical Inventory batch.

2     Import the Inventory Counts.

• Open the Import Physical Inventory window (IC> Physical Inventory> Import).
• Click the BROWSE button to search for the import file or drag-and-drop the file to the right of the button.
• Enter a Transaction Date and Transaction Time.
  • The specified date and time are used to determine the on hand counts when counts are entered and will determine inventory item adjustment amounts. The date and time fields are also used as the transaction date and time for any physical inventory adjustments that are generated from the inventory counts.
• Click the View/Layout Format button to open the File Layout window and display the expected format of the imported .csv file.
• Click the Submit button to import the inventory auto counts into the batch. This will overwrite any inventory counts already in the batch.

3     Record the transactions and commit the physical inventory.