Create On-Account Credit Memo and Apply
Creation of a new On-Account Credit Memo and Application can be achieved using the following methods:
· Entry into the sheet manually
· The On-Account Credit Memos Download Source
· The Open Invoices Download Source
Populate data manually:
1. Start with a blank template.
2. Populate relevant columns as required.
3. Ensure Create or Create records are entered the ‘Apply Upload Action’ in Header, Lines and other relevant sections.
4. Select Create or Create records as the ‘Apply Upload Action’.
5. Complete applicable ‘Apply’ section columns.
6. Validate and/or Upload.
Sheet Structure Examples
Examples do not include all critical columns. Note the ‘Create’ action at the header for each section.
Download
Choose whether to download via sheet or via form as detailed here
On-Account Credit Memo Download Source
Select the On-Account Credit Memos download source as detailed here
For creating a new On-Account Credit Memo based on an existing On-Account Credit Memo follow these steps:
1. Download the desired On-Account Credit Memo(s)
2. Clear the downloaded Transaction Number
3. Update relevant columns as required
4. Ensure Create or Create records are entered the ‘Apply Upload Action’ in Header, Lines and other relevant sections
5. Select Create or Create records as the ‘Apply Upload Action’
6. Complete applicable ‘Apply’ section columns
7. Validate and/or Upload
Note: When creating a new credit memo, the Transaction Number column should be blank, unless you use a manual numbering batch source to generate a new Transaction Number.
Open Invoices Download Source
Select the Open Invoices download source as detailed here
If creating a new On-Account Credit Memo based on an existing Open Invoice follow these steps:
1. Download the desired Open Invoice(s)
2. Clear the downloaded Transaction Number
3. Update relevant columns as required
i.e. The Transaction Type will need to be changed to a Credit Memo type, and likely the line ‘Quantity’ and/or ‘Unit Price’
4. Ensure Create or Create records are entered the ‘Apply Upload Action’ in Header, Lines and other relevant sections
5. Select Create or Create records as the ‘Apply Upload Action’
6. Complete applicable ‘Apply’ section columns
7. Validate and/or Upload
Note: When creating a new credit memo, the Transaction Number column should be blank, unless you use a manual numbering batch source to generate a new Transaction Number.
If an application record is rejected by the integrator validation, neither the new On-Account Credit Memo nor Application will be uploaded.
If an application record is instead rejected by the web service validation, only the application will be excluded from the upload. The new On-Account Credit Memo will be created if it passes validation.
To reprocess the application for the created On-Account Credit Memo, refer Create On-Account Credit Memo and Apply > populate data manually.
More information on how to reprocess records can be found here
