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.

image35

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

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:

    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

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