User Guide‎ > ‎

How to import Stock Transaction from Excel File?

1. Prepare an Excel Spreadsheet with the following format. (Download sample from attachment)
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.
Jansen Lam,
Oct 9, 2008, 11:05 PM