- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic to the Top
- Bookmark
- Subscribe
- Printer Friendly Page
Daily Transactio n Register does not match Daily Sales Order Sales Journal
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
12-14-2011 07:03 AM
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
Re: Daily Transactio n Register does not match Daily Sales Order Sales Journal
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
12-21-2011 08:52 AM
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


