Delete Inactive Customers (SU16)

The Delete Inactive Customers (SU16) program purges the Customer Master files of any customers that are flagged for deletion.

• If the Customer has Sales History (including Invoice History), an outstanding account balance, outstanding Orders or is assigned in a variety of other master files, then the Customer will not be deleted.

• If a Prospect is being deleted and the Prospect has open quotes, then all open quotes are also deleted.

The Deletion process will not begin if either of the following conditions exist:

• An unprinted Invoice Register exists in Print Invoice Register (IN44).
• Unprinted Cash Receipt Batches exist in Print Cash Receipts/Adjustments (AR31).

If either condition exists, you must first print IN44 or AR31 and then run SU16 in order to delete the Inactive Customers.

When a Customer/Prospect is flagged for deletion in the Customer Master (SU13), the Account Status Code for the Customer/Prospect is set to D. SU16 looks at all Customers/Prospects with a Status of 'D' and verifies that each Customer is eligible for deletion.

• All processes that affect Customer balances must be completed prior to running SU16. All files that are updated or are affected by Customer processing are read to ensure that there are no unfinished processes. In other words, the Customer cannot have any outstanding Orders or unpaid Invoices.

• Customer Sales History is retained on a rolling basis for a period of twenty-four (24) months. Customers will not be deleted if they have Sales History or if they have records in the Invoice History file.

• When a Customer/Prospect flagged for deletion has qualified for deletion, the Customer/Prospect is purged from the Customer Master file and all corresponding cross-reference files.

• An audit trail is automatically printed when the purge is completed. The audit trail reports Customers/Prospects that were successfully deleted as well as Customers/Prospects that were skipped and the associated disqualification message. For more information on Disqualification messages, click here.

  Note: The Execute Customer Recode/Merge (RM85) can be used as alternate way to clear out obsolete Customer/Prospect codes.

When the Acceptance Codes are entered, a transaction for each record that can be deleted is sent to the Service Monitor in PointForce iTopia and a message is placed in the iBIS Queue Message view for each Customer/Prospect record eligible for deletion. For more information on the iBIS Queue Message view, click here.

• Warning: When you review SU16, please be advised that there may be transactions trapped in the iBIS Message Queue in PointForce iTopia that need to be resolved.

To view a history of all Customer deletions, see the Customer Deletion History view in PointForce iTopia.