User Guide‎ > ‎

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.
 
 
 
Ĉ
Jansen Lam,
Sep 22, 2008, 2:58 AM
Comments