User Guide‎ > ‎

How to import Stock Adjustment from Excel File?

1. Prepare an Excel Spreadsheet with the following format. (Download sample from attachment)

Column A - Item No.
Column B - Qty on Count (i.e. Physical Count)
Column C - Particulars
2. Use "Save As" CSV (Comma delimited) format to save the file as a CSV file.
3. In ERPro, go to Inventory -> Input -> Stock Adjustment Processing, Click New button. Click the "Import" button and locate the CSV file saved in step 2.
4. The adjustments are imported.
Jansen Lam,
Sep 22, 2008, 2:58 AM