Accounts Receivable Write-Off Fields

Write-Off Filtering Criteria

Field

Description

Account Name The account whose transactions you want to write-off. Leave this field blank to write-off transactions for all accounts.
Currency Mode Defines whether the write-off takes place in the account currency or the document currency. This field defaults to the account currency.
Currency

Defines the currencies used to retrieve and process the write-off for documents. You can select one of the following:

  • All Currencies. All eligible documents are retrieved by currency and written-off according to the selected currency.
  • Currency Mode. A specific currency. Only documents where the currency is the same as the selected currency are retrieved and written-off according to the selected currency mode.
Days Overdue The number of days payment is overdue from the invoice due date. This is calculated by deducting the specified days overdue value from the current date. If this field is left blank, the due date filter will not be applied to the retrieved records.
Payment Status Select whether part-paid or unpaid invoices are included.
Write-Off Limit Uncheck the “Use Default Write-Off Limit” checkbox to enter a Write-Off limit, to override the default value set for the accounting currency per company. You cannot override the Write-Off Limit if All Currencies is selected, or if the Edit Write-Off Values custom setting is deselected in Cash Matching Settings .
Write-Off Up To The date to write-off documents up to. Invoices with a document date later than this date will not be included in the write-off.

Journal Details

Field

Description

Posting Date The date used to derive the journal fiscal period.
Write-Off Comments Comments about the write-off which will populate the Journal Description field on the cash matching journals created by the process.
Write-Off Date The date to populate the Journal Date field on the journals created by the write-off process.
Write-Off Reason Code The reason for the write-off. This will populate the Reference field on the journals created by the process.

Journal Write-Off Details

Field

Description

Write-Off GLA The GLA to be updated with this Write-Off. Note: If Use default from Company is not toggled on, the GLA selected will apply to all journals created by the process.
Write-Off Local GLA This field will only be shown when local GLA options have been enabled for the company, and the user, and when the process is being run in single company mode. The local GLA to be updated with this write-off. Notes: If Use default from Company is not toggled on, the GLA selected will apply to all journals created by the process. If the selected companies are changed after manually entering the local GLA, the Write-Off GLA will revert to “Use default from Company.”
Dimension (1-4) Name of the dimension record by which you want to analyze write-offs. Default company dimensions can be used or specific ones entered, which will apply to all journals posted.

Journal Currency Write-Off Details

Field

Description

Currency Write-Off GLA The GLA to be updated with any currency write-offs resulting from the write-off. The GLA selected, if not using the default from the Accounting company, will apply to all journals posted.
Currency Write-Off Local GLA This field will only be shown when local GLA options have been enabled for the company and user, and when the process is being run in single company mode. The General Ledger Account to be updated with any currency write-offs resulting from the Write-Off. The local GLA selected, if not using the default from the Accounting company, will apply to all journals posted. If the selected companies are changed after manually entering the local GLA, the Currency Write-Off GLA will revert to “Use default from Company.”
Currency Write-Off Loss GLA The currency exchange loss GLA. Required for some countries where currency gains and losses must be differentiated.
Dimension (1-4)

Name of the dimension record by which you want to analyze currency write-offs. Default company dimensions can be used or specific ones entered.