Write-off (WO) transactions can be created automatically based upon the information given in the Pending Write Off table, which is loaded by an automatic process. Selection criteria stipulating the following information will be used.
Read accepted Receivable and Collection records and select if the following conditions are true:
The Write-off Status is NA-Blank
the difference between the Due Date and the current system date is greater than or equal to the value in Number of Days Past Due for Write-off on the System Options or Billing Profile tables
The Transaction Outstanding Amount is greater than zero
The batch process uses this information to select the appropriate records and insert them onto the Pending Write Off table. It then updates the Write-off Status on the Receivable (RE) /Referral to Collection Agency (CL) transaction to Requested.
After the Pending Write Off table has been loaded, a second batch process can be run that will automatically generate Write-off transactions. This process reads the Pending Write Off table and select records if the Processing Status is Approved for Write-off.
For each record selected, group by Billing Profile and create one Write-off transaction for each group sorted then by Customer and Transaction ID (multiple vendor/customer lines). The number of vendor/customer lines created may not exceed the value given in the Line Limit for Write-off field on the System Options and Billing Profile tables.
The process generates the Write-off transaction, and inserts the Transaction ID, and Percentage Value from the table into the appropriate fields in the vendor/customer Line. The Auto Apply action on the WO transaction is then used to generate the corresponding accounting lines.