Sage 100

What am I missing? A customer's GL AR balance is overstated and the IM balance is understated per AR TB and IM Valuation reports. They upgraded from 4.5 to 5.20.1 on 9/28. On 9/30, AR was out of balance and in reviewing the SO journals, the amount posting to GL is more than the invoice total column. In two journals, it is over by the amount of a single invoice, as if they double-posted to AR and IM in the GL only. How can that be?? By 10/26, the difference is even greater so it is repeatedly happening. Again, what am I missing??? @Sage100UrgentSupportNeeded

Wasn't that a known issue fixed by a product update in 2014 or 2015

It sounds like the old problem where it was a bug and the recommended workaround was to preview the sales journal first and then print it.

These are notes from one of our other consultants but I don't know what version it was. * * * POSSIBLE WORKAROUND * * * Preview the Daily Sales Journal. Answer No to print the other reports (Gross Profit, Sales Recap, etc) Print the Daily Sales Journal as normal as well as all other subsequent reports Answer Yes to update Print the Daily Transaction Register it should reflect the correct detail and total information.

OMG. Is it fixed in an update?

Found it - SO5006-T: Daily Transaction Register doubles the amount of one or more invoices from Sales Order Journal

How did those of you who encountered this go about correcting the journal postings?

According to this, this has been happening since 2011, v4.51??? http://community.90minds.com/2012/01/21/sage-indicates-fix-for-sage-100-erp-v4-50-formerly-mas-90-and-200-sales-order-double-posting-is-imminent/

Just made adjusting journal entries. Be sure to look at cogs too

Yes, and I'm seeing sales taxes are doubling as well. What a PITA.....

@ThereseLogeais Just discovered this has been happening at one of my 5.2 PU1 clients for 3 months. How did you find all of the double postings? I just installed SO5006 to stop the bleeding.

I did several Crystal reports - one for header info (e.g. sales taxes, discounts and freight), one for line postings (revenues, etc.), and one for actual postings from all SO journals for the time frame of when they upgraded to when it was noticed and PU installed to ""stop the bleeding"" as you said @DougHiggs. I exported them to Excel and had to do a lot of manipulating but in the end, I was only off a penny. I'd say I have a nice package but it was a lot of playing around with things before I got it straightened out. Good luck!!!

How much do you want for the Crystal reports? Let's negotiate.

@DougHiggs - Was just talking about hot fixes. REmind me again how to find them in the dense jungle known as the KB. TIA

I wonder if Pivot tables would work..

@JeffSchwenk I did a search on the KB and found the artlicle SO5006. There was a link to the hot fix.

It would take me longer to figure out how to do a pivot table then it would to scan the 50 DTRs over the last 3 months.

I'm working on the reports @DougHiggs and will email you shortly.

@DougHiggs - A pivot table a day keeps the doctor away...

I tried a pivot table and it was just not up my alley and didn't give me what I needed. You have to pull the info in several ways - the inventory asset account(s) come from Product Line Maintenance, freight charges and sales taxes by AR Division Maintenance and then you have to do revenues and COGS separately if you're linking to the GL_Account table. I tried adding that table twice, one linked to SalesAcctKey and one to CostofSalesAcctKey but that was way too awkward. In the end, I had four separate reports for what the postings SHOULD have been and then one for actual GL postings. As I said, it was a PITA.

@ThereseLogeais Practice makes perfect.....

So now we installed the latest product update and she says she is now out of balance by $20k+. Do we need to reinstall the hot fix again??? OMG!!!!

@ThereseLogeais Practice makes perfect.....

Do they have DSD MultiCurrency?

Whew! It is another case of keeping track of the date thing. The AR trial balance is correct but the aging is off because a sales journal posted 1/6/2016 had two invoices totaling almost $20k dated 12/31/2015. That is what the difference is. But that's not all! The first thing I looked at was to see if a journal was posted 12/31/2016 and sure enough, there was - also totaling close to $20k but not the exact difference. This one didn't affect the aging because, wait for it.... all the invoices are dated 12/31/2016! She is going to have a mess to clean up....

@ThereseLogeais - Any idea what the module date for this? Was it changed to a 2015 date or was it a 2016 date and user just typed in 1231?

The module date for the 12/31/2016 posting WAS 12/31/2016. I'm assuming she thought it was 12/31/2015 and didn't bother to verify the invoice dates as they were ALL 12/31/2016.