/
Upload Purchase Return

Upload Purchase Return

Owned by Gracia Surialim
Last updated: 2019-Mar-04

Menu Path: Procurement > Transactions > Upload Purchase Return

Step 1: Click file link: 'Download Template File'

Notes:

  1. select source fields and add to target fields (The compulsory fields are pre-selected and can not be removed)
  2. default format is “comma” delimiter

Step 2: Fill in the data

NoField NameData TypeRemarksWhere to findSample Data
1BRANCH_CODEString with Maximum (50) CharactersCompulsoryControl Panel > Developer > Branch Maintenance > Branch Listing > Refer to "Branch Code"A Co.-B1
2ITEM_CODEString with Maximum (100) CharactersCompulsoryInventory > Item > Item ListingITEM A
3ITEM_QTYFloating Point NumberCompulsory

4PURCHASE_RETURN_DATEString in the following format (yyyy-mm-dd)Compulsory

5REFERENCEString with Maximum (100) CharactersCompulsory

6SUPPLIER_IDIntegerCompulsorySupplier > Maintenance > Supplier Listing
7TAX_CODEString with Maximum (100) CharactersCompulsory, for GST (TX, IM, IS, BL, NR, ZP, EP,......)

8UNIT_PRICEFloating Point NumberCompulsory

9BATCH_NUMBERString with Maximum (100) CharactersCompulsory if item is Batch Expiry Item

10EXPIRY_DATEString in the following format (yyyy-mm-dd)Compulsory if item is Batch Expiry Item

11GRN_IDIntegerCompulsory if CONTRA_GRN is set to true

12ITEM_SERIALString with Maximum (0) CharactersCompulsory if item is serialized

13AUTO_SRBooleantrue or false without the quotes, case insensitive

14BATCH_SUPPLIER_IDInteger


15CONTRA_GRNBooleantrue or false without the quotes, case insensitive

16GL_DIMENSION_CODEString with Maximum (50) Characters


17GL_DIMENSION_IDInteger


18ITEM_NAMEString with Maximum (1000) Characters


19ITEM_REMARKSString with Maximum (3000) Characters


20REMARKSString with Maximum (300) Characters


21TAX_AMTFloating Point Number


22UNIT_DISCOUNTFloating Point Number


Excel sample: 

  • Normal Item

  • Serialized Item

  • Batch and Expiry Item

  • If Auto Contra GRN 

  • If Auto SR - INTERCOMPANY

Step 3: Save file, save as comma separated values (.csv) format

image2017-12-9_18-17-42.png

Step 4: Upload file

Sample of Error Message:

  • If the file is not sucessfully uploaded, please refer to the column with RED color Font
  • Please move the cursor to the RED color Font to see the Error Message

  • If this situation happen, please verify and correct the error eg: in the above case,generate GRN listing or Stock Purchase Report to check the GRN number
  • After editing the file, please repeat STEP 4


NOTES:


Related WIKI Pages

Found 5 search result(s) for purchase return.

Page: Purchase Return (Wavelet Management Suite)
2019-Jan-30
Page: Purchase Return by GRN (Wavelet Management Suite)
2019-Jan-11
Page: Edit Purchase Return (Wavelet Management Suite)
2017-Jan-18
Page: Purchase Return Listing (Wavelet Management Suite)
2019-Jan-05
Page: Upload Purchase Return (Wavelet Management Suite)
2019-Mar-04

Related content

Private & Confidential