How to import Stock Adjustment from Excel File?

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

Where

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.

Report abuse