Clear Obsolete Data from Accounts Payable

Sage 300 ERP

Clear Obsolete Data from Accounts Payable

Before you start

  • Post all outstanding batches that could affect records you want to clear.
  • Determine the dates through which to clear transactions and comments and the highest posting sequence number to clear.
  • Print reports of the data you want to clear.
    • Before clearing fully paid documents, print the Vendor Transactions report for the documents you plan to clear.

      For Transaction Types, select all types. As the first Select By option, select Vendor Number, then specify the range of vendor records you plan to clear. Select the other sorting options you want to use. Select Show Applied Details and Include Vendors With A Zero Balance.

    • Before clearing vendor comments, print the Vendors report, selecting the Comments option. Check your vendor records to ensure that the expiration dates for comments you want to retain are later than the date through which you will be clearing comments.
    • Before clearing posting journals:
      • Print a copy of each posting journal you want to clear.
      • Create any outstanding general ledger transactions.
    • Before clearing posted batches:
      • Print the batch status report for the batches.
      • Review the batch dates, and then decide on the batch numbers to clear (for example, batches more than nine months old).

      Note: If you delete batches, you lose the ability to drill down to the transactions from General Ledger.

To clear obsolete data:

  1. Choose A/P Periodic Processing > Clear History.

    Click here for help on the fields on the Clear History form.

  2. Select the types of records you wish to clear.
  3. Specify the ranges for each type of record.
  4. Type the dates or fiscal year and period for which to clear.
  5. Click Process.

Additional information

  • Once you clear posted batches, you can no longer drill down from the General Ledger to the Accounts Payable transactions that they contained. Also, you can no longer reprint invoices.

Related topics