Here's the 2nd go-round today. We just spent most of the afternoon manually re-adding all the shipping addresses for our current customers that were deleted for no good reason. We also continued deleting old customers that have no transactions and are out of business to take them off our system and then AR and OE became corrupt again. We were very careful before we deleted the customers to ensure there was no activity and no shipping address attached. The customers that are becoming corrupt in the DataCare report are current customers with no relation to the customers that we are deleting.

Is there any good time to delete customers that it won't corrupt our data? We want these customers off our system. We prefer not to spend our days re-adding shipping addresses and repairing data as a result. Also, the Orders, Invoices and Credits that the DataCare report is telling us to manually correct, have no issue since those customers were not deleted.

Below is the DataCare Report:

Adagio OrderEntry: Application Integrity

Invalid customer code TR5143 on document C 24419
Invalid customer code TR5143 on document C 24420
Invalid customer code TR5143 on document I 179173
Invalid customer code TR5143 on document I 179185
Invalid customer code VA3882 on document I 179194
Invalid customer code TR3321 on document I 179195
Invalid customer code TR5143 on document I 179209
Invalid customer code TR5143 on document I 179210
Invalid customer code TR3028 on document O 174822
Invalid customer code TR5590 on document O 177643
Orders/Invoice headers ... 10 error(s) found
Items ... Checked OK
Invalid customer code on shipping address for TO1119
Invalid customer code on shipping address for TO3420
Invalid customer code on shipping address for VA3295
Invalid customer code on shipping address for VA3882
Invalid customer code on shipping address VALLEY for VA3882
Shipto address ... 5 error(s) found

Adagio Receivables: File Integrity

Customers ... 23 error(s) found ................................................ FAILED
Customers Extension ... 9 error(s) found ....................................... FAILED

Summary

File Integrity ... 32 error(s) found ........................................... FAILED
Application Integrity ... 15 error(s) found .................................... FAILED

Finshed at: 2008.06.12 16:26

Data Repair Phase


Correcting Phase 2 Errors
*** Customer must be manually corrected for document C 24419
*** Customer must be manually corrected for document C 24420
*** Customer must be manually corrected for document I 179173
*** Customer must be manually corrected for document I 179185
*** Customer must be manually corrected for document I 179194
*** Customer must be manually corrected for document I 179195
*** Customer must be manually corrected for document I 179209
*** Customer must be manually corrected for document I 179210
*** Customer must be manually corrected for document O 174822
*** Customer must be manually corrected for document O 177643
*** Shipping address TO1119 for customer has been removed.
*** Shipping address TO3420 for customer has been removed.
*** Shipping address VA3295 for customer has been removed.
*** Shipping address VA3882 for customer has been removed.
*** Shipping address VA3882 for customer VALLEY has been removed.

Rebuilding Customers ... Done
Rebuilding Customers Extension ... Done

Finished rebuilding integrity errors.
Please repeat Data Integrity Check.