Sage 100

Upgraded a client to SAGE 100 ERP standard version 4.50 PU#5 right before Christmas 2012. AR History (Customer and Salesperson) is set to retain 99 years. Client is noticing several active customer records are ""Not on File"". Lookup the same customer records in a backup company code made during the upgrade and those customers records are found. Requested a PDF of the System Activity Log from 12/15/2012 to current date. Wonder if this is happing during Period End processing in Accounts Receivable. No temporary customers. Anyone experience this issue?

Where are you seeing the ""not on file"" message? Next to the Cust # field where the Cust Name should be, upon pulling the Cust record on screen? Maybe the Cust file has a bad record?

Downloaded a current copy of the MAS_xxx data folder and placed into a copy of the clients system in my computer lab. Discovered that 510 customer records show up using the F2 lookup in the backup company code made on 1/9/2013. Using the same F2 lookup in the ""live"" company, record count shows 343. Somehow 167 customer records (many with history) have been deleted. Searched the System Activity Log from 12/15/2012 to current and did not find entries where the Delete/Renumber/Merge Utility has been used. Only 5 customer records that existed in the 510 were flagged as Temporary. Any ideas of how this could happen? Sage technical support has no ideas.

Do they have any other backups from in between?

UPDATE - Discovered that the Customer Audit Report is set to record ALL changes. Sure enough a staff person changed the field Temporary from ""N"" to ""Y"" for 167 customer records on 3/13 & 3/14. The System Activity Log shows that Period End Processing was performed on 3/29. Low and behold the Customer Audit Report shows 167 customer records were deleted on 3/29. @PhilMcIntosh come Monday morning I'll be talking with them about the frequency of their backups.