Path: Inventory > Rest MA > Upload Reset MA
In order to upload the file successfully, please follow the format shown below constructing the new cost in CSV file.
Step 1: Click file link: 'Upload ResetMA Template'
Notes:
- select source fields and add to target fields
- default format is “comma” delimiter
Step 2: Fill in the data
| No | FIeld Name | Data Type | Remarks | Where to Find | Sample Data |
|---|---|---|---|---|---|
| 1 | COMPANY_CODE | String with Maximum (50) Characters | Compulsory | Control Panel > Developer > Organization Structure > Company > Edit > Company Code | A Co. |
| 2 | ITEM_CODE | String with Maximum (100) Characters | Compulsory | Inventory > Item > Item Listing or Inventory > Reset MA > Select Item Code | ITEM A |
| 3 | NEW_MA_COST | Floating Point Number | Compulsory | 50 | |
| 4 | GLCODE | String with Maximum (50) Characters | inventoryVariance | ||
| 5 | ITEM_REMARKS | String with Maximum (1000) Characters | New Cost for November 2017 |
Excel sample:
Step 3: Save file, save as comma separated values (.csv) format
Step 4: Upload file
