Apply On-Account Credit Memos to Invoices

The ‘Apply’ section enables applying a new or existing On-Account Credit Memo to an invoice and installments.

On-Account Credit Memo data is retrieved from the Header and used to apply to selected invoices and installments.

Table 1. Apply Section columns available
Section	Column Name	Description
Apply	Apply Status	Feeds back if the upload was successful.
	Apply Messages	Returns messaging from the Integrator or web service validation.
	Apply Upload Action	Set to ‘Create’ or ‘Create records’ to create applications.
	Apply Transaction Number	The invoice number the On-Account Credit Memo is being applied to. Required
	Apply Transaction Id	The customer transaction Id of the Apply Transaction Number. Required if Apply Transaction Number is a duplicate.
	Apply Installment	The installment number of the transaction. Required if there is more than one payment schedule against the invoice.
	Apply Customer Name	Invoice Customer Name. Read Only
	Apply Customer Number	Invoice Customer Number. Read Only
	Apply Activity Class	Invoice Activity Class. Read Only
	Apply Currency	Invoice Currency. Read Only
	Apply Amount	Amount to apply. Note: If left blank the balance will be used.
	Apply Date	Date of application. If left blank, the current date is used.
	Apply GL Date	GL Date of application. If left blank, the current date is used.
	Apply Comments	Comments regarding the application.
	Apply Amount Due Original	Invoice Amount Due Original.
Apply DFF	Apply Context	Application DFF.
	Apply Attribute1	Application DFF attribute.
	Apply Attribute2	Application DFF attribute.
	Apply Attribute3	Application DFF attribute.
	Apply Attribute4	Application DFF attribute.

At a minimum, Apply Status, Apply Messages, Apply Upload Action, and Apply Transaction Number must be in the Apply section when applying.

An On-Account Credit Memo can be created at the time of application to an invoice, or an existing On-Account Credit Memo can be used once it is entered into the sheet via the following methods:

Entry into the sheet via an import or manually
The On-Account Credit Memos Download Source
The Open Invoices Download Source

The On-Account Credit Memos download source can be useful if applying an existing On-Account Credit Memo or as a basis for creating a new on- On-Account Credit Memo.

The Open Invoices download source can be useful if downloading specific invoices with the intention of using the data to create a related On-Account Credit Memo. The Transaction Number can then be cut and pasted into the Apply Transaction Number field for the corresponding On-Account Credit Memo to be created and applied to that invoice.

A brief recording which illustrates the below examples, can be viewed here