Page Comparison

Menu Path: Trading > Sales > Upload Invoice

...

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	CUSTOMER_ID	Integer	Compulsory	Refer to system customer account PKID (auto-generated)	4748
3	INVOICE_DATE	String in the following format (yyyy-mm-dd)	Compulsory		2017-08-25
4	ITEM_CODE	String with Maximum (100) Characters	Compulsory		GST-ITEM-1
5	ITEM_QTY	Floating Point Number	Compulsory		1
6	REFERENCE	String with Maximum (100) Characters	Compulsory	Note: same reference no. for same customer pkid, for difference item code, will be created in same invoice; if difference reference, created in separete invoice	ref
7	SALESMAN	String with Maximum (100) Characters	Compulsory		developer
8	TAX_CODE	String with Maximum (100) Characters	Compulsory, for GST (SR, ZRL, ZRE, DS, OS, ES, AJS,......)		SR
9	UNIT_PRICE	Floating Point Number	Compulsory	Amount Inclusive GST	1272.00
10	AUTO_CREATE_GRN	String with Maximum (0) Characters	Auto Generate GRN for this Invoice(Default is false)
11	BATCH_NUMBER	String with Maximum (100) Characters	Compulsory if item is Batch Expiry Item
12	CONTACT_PERSON_IC	String with Maximum (30) Characters	For Intercompany Stock Transfer Purpose
13	EXPIRY_DATE	String in the following format (yyyy-mm-dd)	Compulsory if item is Batch Expiry Item
14	ITEM_SERIAL	String with Maximum (0) Characters	Compulsory if item is serialized
15	GL_DIMENSION_CODE	String with Maximum (50) Characters
16	GL_DIMENSION_ID	Integer
17	GUID_CODE	String with Maximum (50) Characters
18	ITEM_NAME	String with Maximum (1000) Characters
19	ITEM_REMARKS	String with Maximum (3000) Characters		Item's remarks
20	MAJOR_INDUSTRY_CODE	String with Maximum (50) Characters			47591
21	REMARKS	String 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
22	SUPPLIER_ID	Integer
23	TAX_AMT	Floating Point Number
24	TERMS	Integer
25	UNIT_DISCOUNT	Floating Point Number