Understanding Deletion of Customer Master Records
When you delete a customer master record, the system verifies that no transactions exist for that customer in these tables. If a transaction exists, you cannot delete the customer master record; you must first delete the records from these tables, and then delete the customer master record:
Table |
Description |
---|---|
F0150 |
Address Organization Structure Master |
F03B11 |
Customer Ledger |
F03B13 |
Receipts Header |
F03B29 |
Credit Insurance |
F0411 |
Accounts Payable Ledger |
F060116 |
Employee Master Information |
F08901 |
Participant file |
F0911 |
Account Ledger |
F0902 |
Account Balances (if the address book number is used as a subledger) |
F1501B |
Lease Master Header File |
F1797 |
S/WM Address Book Information |
F4013 |
Order Processing Cross Reference File |
F4102 |
Item Branch File |
F4211 |
Sales Order Detail File |
F4311 |
Purchase Order Detail File |
F4801 |
Work Order Master File |
F5201 |
Contract Master File |
If posted invoices or sales orders exist that prevent you from deleting the customer master record, you can prevent the entry of new transactions in the system by using these methods:
Invoices: Activate the Hold Invoices field (HDAR) on the Customer Master Revision form to prevent new A/R invoices from being entered for the customer.
Sales Orders: Update the Hold Orders Code field on the Billing Information form to prevent sales orders from being entered.
When you delete a customer record, the system deletes the record from the F03012 table and from the following tables:
Table |
Description |
---|---|
F0030 |
Bank Transit Master |
F0101 |
Address Book Master |
F01092 |
Supplemental Data Base - Code |
F01093 |
Supplemental Data Base - Narrative |
F0111 |
Address Book - Who's Who |
F0115 |
Address Book - Contact Phone Numbers |
F0116 |
Address by Date |
F01815 |
AB Word Search Master Table |
F0401 |
Supplier Master |