/
Upload Stock Transfer
Upload Stock Transfer
Menu Path: Trading > Internal Stock Transfer > Upload Stock Transfer
Stock transfer is the act of moving goods from one part of the distribution chain to another.
Step 1: Click file link: 'Download Template File' and 'User Guide'
Step 2: Fill in the data
No | Field Name | Data Type | Remarks | Where to find | Sample Data |
---|---|---|---|---|---|
1 | BRANCH_CODE_FROM | String with Maximum (50) Characters | Compulsory | Control Panel > Developer > Branch Maintenance > Branch Listing > Refer to "Branch Code" | A Co.B1 |
2 | BRANCH_CODE_TO | String with Maximum (50) Characters | Compulsory | Control Panel > Developer > Branch Maintenance > Branch Listing > Refer to "Branch Code" | A Co.B2 |
3 | ITEM_CODE | String with Maximum (100) Characters | Compulsory | ||
4 | ITEM_QTY | Floating Point Number | Compulsory | 10 | |
5 | REFERENCE | String with Maximum (100) Characters | Compulsory | autorec | |
6 | STOCK_TRANSFER_DATE | String in the following format (yyyy-mm-dd) | Compulsory | 2019-15-04 | |
7 | TRANSPORTER | String with Maximum (100) Characters | Compulsory | nobody | |
8 | AUTO_RECEIVE | Boolean | true or false | This if customer want to auto receive the stock transfer | TRUE |
9 | BATCH_NUMBER | String with Maximum (100) Characters | Compulsory if item is Batch Expiry Item | ||
10 | EXPIRY_DATE | String in the following format (yyyy-mm-dd) | Compulsory if item is Batch Expiry Item | ||
11 | ITEM_SERIAL | String with Maximum (100) Characters | Compulsory if item is serialized | ||
12 | BATCH_SUPPLIER_ID | Integer | |||
13 | SENDER_REMARKS | String with Maximum (300) Characters |
Excel sample:
- Normal Item
- Serialized Item
- Batch and Expiry
Step 3: Save file, save as comma separated values (.csv) format
Step 4: Upload file
Sample of Error Message 1:
- 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 the branch code and correct the error
- After edit the file, please repeat STEP 4
NOTES:
- Need to make sure the permission to upload is ENABLED under Trading (Permission)
- Refer to Internal Stock Transfer Details Listing for the date received → If AUTO_RECEIVE is TRUE
Related WIKI Pages:
Found 5 search result(s) for stock transfer.
Private & Confidential