Sage 100

Customer emailed that since their upgrade in Feb 2014 (440 to 2013), temporary customers that have been removed from customer maintenance through standard process for temporary customers are now showing in the AR Trial Balance every month. Customers had been removed both before and after upgrade. If she adds the customer back to customer maintenance, they no longer appear in the Trial Balance. The TB shows the invoice balance as $0, and the detail shows the invoice and the payment and they are equal. She had found a KB article that indicated problems with the AR Aging and balances left of .01 due to rounding. She checked AR_OpenInvoice, AR_TransactionPaymentHistory, AR_InvoiceHistoryHeader and the balances all show $0.00. Had her rebuild key files and sorts but no success. Verifying that she's running with 'invoice type to print = open and not all' but the report she sent says 'all open invoices' so assuming she is. Any Ideas?

Are they current with the PU's?

I think she is a few behind, she didn't see anything in the release notes but should probably install to bring them current and see if it resolves it. Thanks

Release notes HAVE been known to be less than 100%. Shouldn't hurt to get current. For the record, I hate temp customers........

I just don't understand it. Sage has barely touched the source code in at least half a decade. I can't think of any 'features' they've added that would screw something up like this.

beginning in 4.10 the system is very sensitive to what I call an 'alternate data source'. Check the share point to make sure that there are no other MAS90 folders with data. The folder could be renamed but still has the folder name included (old.mas90, mas90old etc). The same applies to all MAS related files and folders within the share point. A renamed AR_TransactionPaymentHistory.m4t.old is still capable of being read. Check this and also run the embedded IO replacement script for all modules and company codes in use. There was an article published until about 3 years ago when for reasons not understood one of the managers there (initials are CP) had it pulled from the knowledge base.

Interesting. Thanks for the insight.