How to import Stock Transaction from Excel File?

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

Where

Column A - Item No.

Column B - Qty

Column C - Unit Cost

Column D - Line Ref

Column E - Particulars

2. Save the File as an normal Excel File.

3. In ERPro, go to Inventory -> Input -> Stock Transaction Processing, Click New button. Click the "Import" button and locate the Excel file saved in step 2.

4. The transaction are imported. You may need to change the Location, Stock In, Out or Transfer, etc.