Sage 100

I have a client with an odd issue. Ever since they upgraded to version 4.40 (from 4.30), when they run period end, invoices/payments go missing from the AR_OpenInvoice and AR_TransactionPaymentHistory tables. This is what you'd expect based on the ""number of days to retain paid invoices"" setting, however these are getting purged as though that setting was 0 days. However I double-checked and it's set to 999 days and that's what it's always been.

We made a backup company before performing month end, so what I think we're going to try is make one more copy of that, then test changing the setting from 999 to 0, save, then change it back, and run period end.

Is there maybe something funky going on with the workstation's system/module date? Did you happen to check the AR_Options file via DFDM to see if in fact it says 999?

Yes, it's definitely 999 days in AR_Options.

An update - client closed February 2012 and the issue happened again. Before closing, we changed the option to 0, saved, then went back in and set it back to 999. Unfortunately, it happened again so that's not it. I've never seen this before and I cannot for the life of me figure out what MAS 90 is doing.

On a test company, yry changing the option setting from Open Item to Mixed, save and change it back.