Menu Path: Customer > Credit Memo > Upload Customer Credit Memo
Step 1: Click file link: 'Upload Customer Credit Memo Template'
...
Use Open Office Calc to open the template file.
...
On the next screen, select by Separated By "Comma", Text Qualifier "Double Quotes".
...
Fill in the template content.
Not all the fields on the template are required, some may be optional. Please refer to below screenshot on the required fields with data format description.
You may delete the non required fields at your discretion.
Key in in the template that you wish to bring into the system into the template.
...
Step by step upload guidance kindly follow Upload Item Code.
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 record follow Output tax GST configuration, if the configuration is inclusive method, Amount record inclusive 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
