Sage 100

v5.2 PU1 GL didn't tie out to the AR aging. Discovered the sales journal update was creating double postings in the DTR. I have installed SO5006 to stop the bleeding. Does anyone have a way to determine what entries need to be corrected? Looking at three months of DTRs and trying to figure out which one double posted could take a week or two. Has anyone developed a Crystal report or other method they would be willing to share or sell?

OH, damn, I had to do this when it happened on 2013. I think I just sorted the entries in dollar order and suppressed if the next dollar and previous dollar amount were different, but I don't have my report any more.

@BethBowers Can you re-create the Crystal report for me (for free)? I need it by noon tomorrow please! 9am would be better. TIA.

You're so cute when you do that.

LOL. Seriously, you have a great idea. The Crystal report should be easy for me to create. I am working this weekend to try and get this resolved. Thanks for the suggestion!

You do still have to eyeball it, though - my client had same type of items more than once on an invoice and so did honestly have some duplicates. But it gets you close.