Upload Customer Credit Memo

Menu Path: Customer > Credit Memo > Upload Customer Credit Memo

Step 1: Click file link: 'Upload Customer Credit Memo Template'

Notes:

Step 2: Fill in the data

Sample of Upload Customer Credit Note file

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	Customer > Maintenance > Customer > Account PKID or Customer > Credit Memo > Create > Customer	4703
3	SALESMAN	String with Maximum (50) Characters	Compulsory	Customer > Credit Memo > Create > Salesman drop down list	admin
4	REFERENCE	String with Maximum (100) Characters	Compulsory		ref:INV1234
5	DATE	String in the following format (yyyy-mm-dd)	Compulsory		2017-11-05
6	REMARKS	String with Maximum (100) Characters	Compulsory if Not Trade In Item		Being sales discount for INV1234
7	ITEM_BRANCH	String with Maximum (50) Characters	Compulsory if Not Trade In Item		A Co.-B1
8	GLCODE	String with Maximum (50) Characters		Accounting > Maintenance > Configuration > View GL Codes > GL Short Hand or Customer > Credit Memo > Create > Add GL Code Details drop down list	generalSalesDiscount
9	AMOUNT_DEBIT	Floating Point Number	Compulsory if Not Trade In Item and AMOUNT_DEBIT empty		106
10	GLCODE_TAX_CODE	String with Maximum (100) Characters		output tax tax code	SR
11	GLCODE_REMARKS	String with Maximum (100) Characters			Being sales discount for INV1234

Notes:

The amount recorded will follow Output tax GST configuration, if the configuration is set as inclusive, the Amount recorded will be inclusive of GST

Excel sample:

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

Step 4: Upload file

Reports:

Menu Path: Customer > Credit Memo > Credit Memo Listing