Deleting A/R Posted Transactions

For open customers, the Delete A/R Posted Transactions utility deletes all fully paid invoices.

For balance forward customers, this utility deletes all invoices up to the amount of payments available. Then, it generates a balance-forward entry for the first partially-paid amount.

Note: If an invoice has multiple due dates associated with it, those records are also deleted.

The Preview option displays the records to delete without actually deleting them, while the Commit option deletes the records without displaying them.

Before running this utility, you should print statements. As the system deletes records, it records the number of days between the invoice date and the payment date, and then uses this amount to calculate the number of days outstanding for customers with a Posted Transaction Balance Method.

Follow these steps to delete accounts receivable (A/R) transactions that have been posted:

Open the Delete A/R Posted Transactions utility form.
Specify this information:
- Through Date: Enter the date through which to delete A/R transactions, or accept the default, which is the current system date.
- Statement Cycles: Enter the statement cycles for which you want to delete A/P transactions. Options include Weekly, Monthly, Quarterly, or All.
  Note: With the exception of All, these options cause the utility to process only those records for which the statement cycles match. For example, if you select Weekly, then only the records with a statement cycle setting of Weekly are processed. Records tagged for Monthly or Quarterly cycles do not get processed.
- Starting Customer and Ending Customer: Enter the range of customers for which you want to delete A/R transactions. To delete A/R transactions for all customers, leave these fields blank.
- Preview/Commit:
  - To view the results of running the utility without saving the results in the database, select Preview.
  - To save the results in the database, select Commit.
Click Process.