Sage MAS 90 and 200 Sage MAS 500 blogs Product Feedback Support Training
Reply
Regular Contributor
jnelsonut
Posts: 291
Registered: 11-11-2008
0

Daily Transaction Register does not match Daily Sales Order Sales Journal

I just noticed that since upgrading from 4.05 to 4.5, random Sales Order Invoice Batches do not match the Daily Transaction Register.

 

The amount that is Debited to the Account Receivable GL Account or the GL Cash Account for Cash Sale Invoices is higher than the Invoice Total on the Sales Journal.  It seems to be doubling one or more invoices in the batch, so the sales, sales discounts (if it had a discount), freight (if it had freight) are also doubled.

 

I've never had this happen on any 3.x versions or on 4.05.

 

There is one reference in the KB about the AR Invoice Register not matching the Daily Transaction Register, but this is in Sales Order Invoicing not AR.

 

Has anyone seen this, or having this problem?   I need a solution because my AR is off and My Cash Account doesn't match the Bank Rec Balance.

 

Joe

Regular Contributor
jnelsonut
Posts: 291
Registered: 11-11-2008
0

Re: Daily Transaction Register does not match Daily Sales Order Sales Journal

I opened a case with Sage, they said this has been noticed by a few customers and will be fixed in a future update.

 

My advice to anyone on 4.5, is to check the Sales Totals on the Daily Sales Order Sales Journal with the total on the Daily Sales Recap By Product Line before updating.

 

If they don't match, don't update - reprint the Sales Journals and they will match - now you can update.

 

Joe