/
Upload Invoice

Upload Invoice

Owned by Jia Pei Chan
Last updated: 2017-Dec-13 by Gracia Surialim

Menu Path: Trading > Sales > Upload Invoice

Step 1:  Click File Link 'Download Template File'

Notes:

  1. 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
  2. default format is “comma” delimiter


Step 2:  Fill in the Data

NoField NameData TypeRemarksWhere to FindSample Data
1BRANCH_CODEString with Maximum (50) CharactersCompulsory

Control Panel > Developer > Branch Maintenance > Branch Listing > Refer to "Branch Code"

A Co.-B1
2CUSTOMER_IDIntegerCompulsory

Refer to system customer account PKID (auto-generated)

4748
3INVOICE_DATEString in the following format (yyyy-mm-dd)Compulsory
2017-08-25
4ITEM_CODEString with Maximum (100) CharactersCompulsory
GST-ITEM-1
5ITEM_QTYFloating Point NumberCompulsory
1
6REFERENCEString with Maximum (100) CharactersCompulsoryNote: same reference no. for same customer pkid, for difference item code, will be created in same invoice; if difference reference, created in separete invoiceref
7SALESMANString with Maximum (100) CharactersCompulsory
developer
8TAX_CODEString with Maximum (100) CharactersCompulsory, for GST (SR, ZRL, ZRE, DS, OS, ES, AJS,......)
SR
9UNIT_PRICEFloating Point NumberCompulsoryAmount Inclusive GST1272.00
10AUTO_CREATE_GRNString with Maximum (0) CharactersAuto Generate GRN for this Invoice(Default is false)

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

12CONTACT_PERSON_ICString with Maximum (30) CharactersFor Intercompany Stock Transfer Purpose

13CURRENCYString with Maximum (50) CharactersUSD,CNY,HKD,THB,SGD,JPY
SGD
14CURRENCY_RATEFloating Point Number4.27,0.65,0.54,0.13,3.15,0.0389
3.02
15EXPIRY_DATEString in the following format (yyyy-mm-dd)Compulsory if item is Batch Expiry Item

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

17GL_DIMENSION_CODEString with Maximum (50) Characters


18GL_DIMENSION_IDInteger


19GUID_CODEString with Maximum (50) Characters


20ITEM_NAMEString with Maximum (1000) Characters


21ITEM_REMARKSString with Maximum (3000) Characters
Item's remarks
22MAJOR_INDUSTRY_CODEString with Maximum (50) Characters

 Search Item Widget > Optional Details

47591
23REMARKSString with Maximum (300) Characters

Invoice's remarks

Note: same reference no. & same remarks for same customer pkid, for difference item code, will be created in same invoice; if same reference, difference remark, created in separete invoice


24SUPPLIER_IDInteger


25TAX_AMTFloating Point Number


26TERMSInteger


27UNIT_DISCOUNTFloating Point Number


Excel sample:

Normal Invoice

Invoice with Foreign Currency

Notes:

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

Step 4: Upload file

IMPORTANT:

  1. Kindly ensure that ((UNIT_PRICE - UNIT_DISCOUNT) * ITEM_QTY) is inclusive of GST/VAT
  2. If TAX_AMT is not specified, system will automatically calculate the GST/VAT amount based on settings in the system


Related WIKI Pages

Found 5 search result(s) for xxx.

Page: Merge Supplier Account (Wavelet Management Suite)
2018-Jan-30
Page: Opening Account Receivable (Wavelet Management Suite)
2019-Jan-25
Page: Deposit from Customer (Wavelet Management Suite)
2017-Jan-26
Page: What happens to GST Output Tax when RCT is Reversed after filing? (Wavelet Management Suite)
2017-Feb-18
Page: Extra Knowledge Q & A (Wavelet Management Suite)
2015-Aug-05

Related content

Private & Confidential