Menu Path: Inventory > Others > Upload Purchase Order
...
Step 1: Click file link: 'Download Template File
...
'
Upon selecting Download Template File, a pop-up windows will be displayed as per shown in the image below and perform the following steps:
- The right section labelled as "Target Fields" are the compulsory field and will not be able to be removed or added.
- The left section labelled as "Source Field" are those fields that can be added or removed into and from the Target field by the user.
...
Notes:
- select source fields and add to target fields (The compulsory fields are pre-selected and can not be removed)
- default format is “comma” delimiter
Step 2: Fill in the data
| No | Field Name | Data Types | Remarks | Where to Find | Sample Data |
|---|---|---|---|---|---|
| 1 | BRANCH_CODE | String with Maximum (50) Characters | Compulsory | Control Panel > Developer > Branch Maintenance > Branch Listing > Refer to "Branch Code" | |
| 2 | ITEM_CODE | String with Maximum (50) Characters | Compulsory | Inventory > Item > Item Listing | |
| 3 | ITEM_QUANTITY | String with Maximum (50) Characters | Compulsory | ||
| 4 | PO_DATE | String in the following format (yyyy-mm-dd) | Compulsory | ||
| 5 | SUPPLIER_ID | Integer | Compulsory | Supplier > Maintenance > Supplier Listing | |
| 6 | SUPPLIER_NAME | String with Maximum (100) Characters | Compulsory | Supplier > Maintenance > Supplier Listing | |
| 7 | UNIT_PRICE | Floating Point Number | Compulsory | ||
| 8 | ITEM_SERIAL | Text | Compulsory for Serialized Item, use comma separated value, ex : 44421,44422,44423,44424,44425 | ||
| 9 | PKID | Integer | Used to Edit PO | ||
| 10 | TAX_CODE | String with Maximum (36) Characters | Must follow configured Tax Code | ||
| 11 | TAX_RATE | Floating Point Number | Must follow configured Tax Code | ||
| 12 | TAX_TYPE | String with Maximum (36) Characters | Must follow configured Tax Code | ||
| 13 | ACTUAL_ARRIVAL_DATE | String in the following format (yyyy-mm-dd) | |||
| 14 | AUTO_RESET_MA | Boolean | true or false without the quotes, case insensitive | ||
| 15 | ESTIMATED_ARRIVAL_DATE | String in the following format (yyyy-mm-dd) | |||
| 16 | GL_DIMENSION_CODE_(ITEM) | String with Maximum (50) Characters | |||
| 17 | GL_DIMENSION_ID_(ITEM) | Integer | |||
| 18 | ITEM_REMARKS | String with Maximum (1000) Characters | |||
| 19 | PO_REMARKS | String with Maximum (100) Characters | |||
| 20 | REBATED_PRICE | Floating Point Number | |||
| 21 | REFERENCE# | String with Maximum (100) Characters | |||
| 22 | REQUEST_DELIVERY_DATE | String in the following format (yyyy-mm-dd) | |||
| 23 | SHIPMENT_REFERENCE | String with Maximum (100) Characters | |||
| 24 | SHIPPING_ADDRESS | String with Maximum (1000) Characters |
Excel sample:
- Inventory Type - Normal Item
- Decimal Type
- Batch and Expiry Type
- Coupon Type
Step 3: Save file, save as comma separated values (.csv) format
Step 4: Upload file
Sample of Error Message:
- If the file is not sucessfully uploaded, please refer to the column with RED color background
- Please move the cursor to the RED color background to see the Error Message
- If this situation happen, please verify and correct the error eg: in the above case, check the item quantity and please take note that only decimal quantity only applicable for decimal item type
- After editing the file, please repeat STEP 4
Related Wiki Pages:
| Panel | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
|
...