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.
The Apply section has the following 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.
Note: 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