Completing the Accounts Receivable Purge Checklist

These purge programs apply to the JD Edwards EnterpriseOne Accounts Receivable system:

Purge Program

Description

Purge Electronic Receipts Input (R03B0041A)

This program removes processed electronic receipts from the Electronic Receipts Input table (F03B13Z1).

Note: Purge only receipts with an auto-cash upload status of Y. Otherwise, the purge program removes receipts that are stored in the F03B13Z1 table for invoice and statement matching purposes.

Purge Batch Invoices (R03B11Z1P)

This program removes processed invoices from these tables, regardless of the batch in which they exist:

  • Batch Invoices (F03B11Z1).

  • Journal Entry Transactions - Batch File (F0911Z1).

This purge program removes only batch invoices; it does not affect invoices in the F03B11 table.

Purge/Repost A/R Statistical History (R03B163)

This program removes records from the A/R Statistical History table (F03B16) and resets the ISTC field from 1 to 0 for the corresponding invoices in the F03B11 table.

Use the data selection to designate which records to remove, and verify that you do not remove records by company.

Purge Statement/Notification (R03B5010)

This program removes delinquency notice and statement records from these tables:

  • A/R Notification History (F03B20).

  • A/R Notification History Detail (F03B21).

To purge only delinquency notices, use the data selection to specify notification type DL. To purge only statement information, specify notification type ST.

Purge Invoice Transactions (R03B800)

This program removes paid and posted invoices without an open amount from the F03B11 table.

Purge Receipt Transactions (R03B801)

This program removes posted receipts from the F03B13 and F03B14 tables.