Menu Path: Inventory > Others > Upload GRN (Good Receive Note)
Step 1: Click file link: 'Download Template File'
Notes:
- select source fields and add to target fields (You can choose the fields for the information you wish to upload) **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 Type | 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" | A Co.-B1 |
| 2 | GRN_DATE | String in the following format (yyyy-mm-dd) | Compulsory | 2017-11-01 | |
| 3 | ITEM_CODE | String with Maximum (100) Characters | Compulsory | Inventory > Item > Item Listing or Procurement > Transactions > Direct Receiving Stock > Select Item | GST-ITEM-1 |
| 4 | ITEM_QTY | Floating Point Number | Compulsory | 1 | |
| 5 | REFERENCE | String with Maximum (100) Characters | Compulsory | PO12345 | |
| 6 | SUPPLIER_ID | Integer | Compulsory | Supplier > Maintenance > Supplier Listing or Procurement > Transactions > Direct Receiving Stock > Select Supplier | 1080 |
| 7 | UNIT_PRICE | Floating Point Number | Compulsory | 100 | |
| 8 | BATCH_NUMBER | String with Maximum (100) Characters | Compulsory if item is Batch Expiry Item | ||
| 9 | EXPIRY_DATE | String in the following format (yyyy-mm-dd) | Compulsory if item is Batch Expiry Item | ||
| 10 | ITEM_SERIAL | String with Maximum (0) Characters | Compulsory if item is serialized | ||
| 11 | CATEGORY1 | String with Maximum (100) Characters | |||
| 12 | CATEGORY10 | String with Maximum (100) Characters | |||
| 13 | CATEGORY2 | String with Maximum (100) Characters | |||
| 14 | CATEGORY3 | String with Maximum (100) Characters | |||
| 15 | CATEGORY4 | String with Maximum (100) Characters | |||
| 16 | CATEGORY5 | String with Maximum (100) Characters | |||
| 17 | CATEGORY6 | String with Maximum (100) Characters | |||
| 18 | CATEGORY7 | String with Maximum (100) Characters | |||
| 19 | CATEGORY8 | String with Maximum (100) Characters | |||
| 20 | CATEGORY9 | String with Maximum (100) Characters | |||
| 21 | DATE_SRC_DOC | String in the following format (yyyy-mm-dd) | Refer to Source Document Date → optional date as per usage. E.g: can be use as additional date column for document received date | ||
| 22 | EAN_CODE | String with Maximum (100) Characters | |||
| 23 | EXCHANGE_RATE | Floating Point Number | |||
| 24 | FOREIGN_CCY | Floating Point Number | |||
| 25 | GL_DIMENSION_CODE | String with Maximum (50) Characters | |||
| 26 | GL_DIMENSION_CODE_ITEM | String with Maximum (50) Characters | |||
| 27 | GL_DIMENSION_ID | Integer | |||
| 28 | GL_DIMENSION_ID_ITEM | Integer | |||
| 29 | GUID_CODE | String with Maximum (50) Characters | |||
| 30 | ITEM_NAME | String with Maximum (1000) Characters | |||
| 31 | ITEM_REMARKS | String with Maximum (3000) Characters | |||
| 32 | ITEM_SERVICE_COST | Floating Point Number | |||
| 33 | ITEM_SPECIAL_UNIT | String with Maximum (100) Characters | |||
| 34 | ITEM_TYPE | String with Maximum (1000) Characters | |||
| 35 | ITEM_WEIGHT | Floating Point Number | |||
| 36 | LIST_PRICE | Floating Point Number | |||
| 37 | MAJOR_INDUSTRY_CODE | String with Maximum (100) Characters | |||
| 38 | PO_ITEM_PKID | Integer | |||
| 39 | REFERENCE_DO | String with Maximum (100) Characters | |||
| 40 | REFERENCE_QUOTATION | String with Maximum (100) Characters | |||
| 41 | REMARKS | String with Maximum (300) Characters | |||
| 42 | SERIALIZED | String with Maximum (100) Characters | |||
| 43 | TAX_CODE | String with Maximum (100) Characters | |||
| 44 | TAX_OPTION | String with Maximum (100) Characters | |||
| 45 | TAX_RATE | Floating Point Number | 6 | ||
| 46 | TAX_TYPE | String with Maximum (100) Characters | |||
| 47 | UNIT_COST | Floating Point Number | |||
| 48 | UOM | String with Maximum (20) Characters |
Excel sample:
- Inventory Type - Normal Item
- Batch and Expiry Type
- Serialzed Type
- Coupon Type
- Decimal 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, refer back to the notes below and edit the serial number on the file
- After editing the file, please repeat STEP 4
Notes:
- If its allowed to negative stock on Extended Warranty → there is no GRN needed
- If its not allowed to have negative stock on Extended Warranty → GRN needed
- System will shows error as it DISALLOW to STOCK IN the SAME ITEM with SAME SERIAL NUMBERin the SAME COMPANY → refer to sample of error essage
- System ALLOW to STOCK IN the DIFFERENT ITEM CODE with SAME SERIAL NUMBER in the SAMECOMPANY
- System ALLOW to STOCK IN the SAME ITEM CODE with SAME SERIAL NUMBER in the DIFFERENTCOMPANY