Menu Path: Trading > Internal Stock Transfer > Upload Stock Transfer
| Panel |
|---|
Stock transfer is the act of moving goods from one part of the distribution chain to another. |
- The image above shows the main interface of Upload Stock Transfer for Internal Stock Transfer.
- A document file will be downloaded automatically upon clicking on the link labelled Upload Stock Transfer User Guide.
- The user guide shows the simple steps on how to Upload Stock Transfer using this function on EMP.
- The following image shows the downloaded document file.
- The similar steps are applicable when clicking Download Template File, whereby the UploadStockTransfer.csv file will be downloaded automatically.
...
- Upon opening the .csv file, take note on the pop up window box that appears.
- Choose the relevant Separator Options and Text Delimiter, and click OK.
...
- The .csv file requires the appropriate Stock Transfer details to be key in.
- Not all the fields on the template are required, some may be optional.
Non-compulsory fields can be deleted at user's discretion.
- Choose the downloaded and filled template file into the Input File of Upload Stock Transfer function.
- Select the appropriate Delimiter and Text Qualifier before proceeding to click Submit.
...
- The image above will be shown upon uploading the correct file.
...
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:
| Panel | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
|