Upload GRN

Menu Path: Inventory > Others > Upload GRN (Good Receive Note)

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	GRN_DATE	String in the following format (yyyy-mm-dd)	Compulsory		2017-11-01
3	ITEM_CODE	String with Maximum (100) Characters	Compulsory	Inventory > Item > Item Listing or Procurement > Transactions > Direct Receiving Stock > Select Item	GST-ITEM-1
4	ITEM_QTY	Floating Point Number	Compulsory		1
5	REFERENCE	String with Maximum (100) Characters	Compulsory		PO12345
6	SUPPLIER_ID	Integer	Compulsory	Supplier > Maintenance > Supplier Listing or Procurement > Transactions > Direct Receiving Stock > Select Supplier	1080
7	UNIT_PRICE	Floating Point Number	Compulsory		100
8	BATCH_NUMBER	String with Maximum (100) Characters	Compulsory if item is Batch Expiry Item
9	EXPIRY_DATE	String in the following format (yyyy-mm-dd)	Compulsory if item is Batch Expiry Item
10	ITEM_SERIAL	String with Maximum (0) Characters	Compulsory if item is serialized
11	CATEGORY1	String with Maximum (100) Characters
12	CATEGORY10	String with Maximum (100) Characters
13	CATEGORY2	String with Maximum (100) Characters
14	CATEGORY3	String with Maximum (100) Characters
15	CATEGORY4	String with Maximum (100) Characters
16	CATEGORY5	String with Maximum (100) Characters
17	CATEGORY6	String with Maximum (100) Characters
18	CATEGORY7	String with Maximum (100) Characters
19	CATEGORY8	String with Maximum (100) Characters
20	CATEGORY9	String with Maximum (100) Characters
21	DATE_SRC_DOC	String in the following format (yyyy-mm-dd)
22	EAN_CODE	String with Maximum (100) Characters
23	EXCHANGE_RATE	Floating Point Number
24	FOREIGN_CCY	Floating Point Number
25	GL_DIMENSION_CODE	String with Maximum (50) Characters
26	GL_DIMENSION_CODE_ITEM	String with Maximum (50) Characters
27	GL_DIMENSION_ID	Integer
28	GL_DIMENSION_ID_ITEM	Integer
29	GUID_CODE	String with Maximum (50) Characters
30	ITEM_NAME	String with Maximum (1000) Characters
31	ITEM_REMARKS	String with Maximum (3000) Characters
32	ITEM_SERVICE_COST	Floating Point Number
33	ITEM_SPECIAL_UNIT	String with Maximum (100) Characters
34	ITEM_TYPE	String with Maximum (1000) Characters
35	ITEM_WEIGHT	Floating Point Number
36	LIST_PRICE	Floating Point Number
37	MAJOR_INDUSTRY_CODE	String with Maximum (100) Characters
38	PO_ITEM_PKID	Integer
39	REFERENCE_DO	String with Maximum (100) Characters
40	REFERENCE_QUOTATION	String with Maximum (100) Characters
41	REMARKS	String with Maximum (300) Characters
42	SERIALIZED	String with Maximum (100) Characters
43	TAX_CODE	String with Maximum (100) Characters
44	TAX_OPTION	String with Maximum (100) Characters
45	TAX_RATE	Floating Point Number			6
46	TAX_TYPE	String with Maximum (100) Characters
47	UNIT_COST	Floating Point Number
48	UOM	String with Maximum (20) Characters