Purge Invoices and Freight Bills

Purge Invoices and Freight Bills is initiated from the Supplementary Purge using Request Type "PINV".

The Purge Invoices and Freight Bills utility will perform separate steps to purge Invoices and Freight Bills.

Note: The Transaction Purge process will remove the Invoice or Freight Bill when removing the last Invoice Detail or Freight Bill Detail. However, this process will not remove an Invoice or Freight Bill if it includes one or more Details in Canceled status.

Invoices

The Purge Invoices step will purge qualifying entries in the following tables:

• Invoice (INVC_T)
• Invoice Detail (INVC_DETL_T)
• A/R Transaction (AR_TRNS_T)
• Reference Number (RFRC_NUM_T)
• Memo (MMO_T)

This Purge Invoices step will purge completed and cancelled Invoices and all corresponding data. Invoices will be purged when the following is True:

• Invoice and corresponding interface transaction are complete (all of the following statements are True):
  • Invoice Date is older than the cut-off date.
  • Status for Invoice is Accounts Receivable or Canceled.
  • Any corresponding Invoice Details that remain are in Canceled status.
  • If there is a corresponding A/R Transaction, status for this entity must be Accounts Receivable or Closed.

Freight Bills

The Purge Freight Bills step will purge qualifying entries in the following tables:

• Freight Bill (FRHT_BILL_T)
• Freight Bill Detail (FRHT_BILL_DETL_T)
• A/P Transaction (AP_TRNS_T)
• Reference Number (RFRC_NUM_T)
• Memo (MMO_T)

This Purge Freight Bills step will purge completed and cancelled Freight Bills and all corresponding data. Freight Bills will be purged when the following is True:

• Freight Bill and corresponding interface transaction are complete (all of the following statements are True):
  • Invoice Date is older than the cut-off date.
  • Status for Invoice is Accounts Payable or Canceled.
  • Any corresponding Freight Bill Details that remain are in Canceled status.
  • If there is a corresponding A/P Transaction, status for this entity must be Accounts Receivable or Closed.

Note: For each Invoice or Freight Bill that is purged by this utility, the Partially Purged flag for the corresponding Invoice Run or Freight Bill Run will be set to True if not already True. Likewise, for each A/R or A/P Transaction that is purged, the Partially Purged flag for the corresponding A/R Transaction Run or A/P Transaction Run will be set to True if not already True.

See Also