User Guide‎ > ‎

Inventory Sales Price Update Demonstration

You can update the Inventory Sales Price by batch using a Pre-formatted Excel File.
 
1. Prepare an Excel worksheet with the following format. or download the Salesprice.xls from atttachment.
 
    Column 1: Item Number
    Column 2: Currency
    Column 3: Unit
    Column 4: Start Qty for qty break
    Column 5: Unit Price
 
 
2. Goto ERPro -> Sales -> Processes -> Inventory Sales Price Update. Click the "..." button to select the Excel File, click the "Import" button to import the Excel File to grid.
 
 
3. Click the "Upload" button to upload to ERPro