Menu Path: Customer > Credit Memo > Upload Customer Credit Memo
Step 1: Click file link: 'Upload Customer Credit Memo Template'
Notes:
- select source fields and add to target fields
- default format is “comma” delimiter
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
| Google drive sheets | ||
|---|---|---|
|