Sage 100

somehow an AR Open Item customer had all of their invoices merged into one balance forward - and now, months later - we're trying ot figure out which invoices were merged into the balance forward Invoice, so that they can try to call and collect on the specific invoices. Is there any way in Sage (2013) to find this?

The invoices should still exist in AR_InvoiceHistory files. Trying to figure out the balance might be tricky. Can you print an aging with a date prior to the change - do you know the date of the change? Is it in the customer audit file?

Or a trial balance?

yes Therese, they are in AR_InvoiceHistory - just not sure which ones are tied to the balance forward invoice - but good idea, we'll try backdating some AR reports and see what we can find

If in doubt, call everyone and you will soon find out (hopefully) which ones were still outstanding. Or you can work backwards from current day using the cash receipts history..... BTW, are you saying you are STILL trying to figure it out or that they just NOW alerted you to their mess? How about an old backup??

It was originally reported to us and fixed a few months ago but they didn't seem concerned at that time about the detail behind the balance forward. Now, months later, they are:) - I think we can figure it out, just need to dive into the details - i just wanted to make sure there wasn't a simpler method.

Well, if you were using Chinski's MIRACLE CLOUD backup solution, you would already be working on bigger and more pressing issues like ""How much Polygamy Porter should I bring for Jeff""?????? http://www.youtube.com/watch?v=bW7HYpKWwgs It is THE BEST!!!!!

They always say they're not worried about it and yet at some point later, they almost always come back and it's suddenly mission critical and they need it corrected 15 minutes ago.

exactly - and the information is there if they would just spend a few minutes and research it themselves, but they want me to waive my magic wand. Nice video @JeffSchwenk - I'm pretty sure they sell them in Vegas

@EricAnderson - Can you verify. I would hate for you to haul a couple cases down there if YOU can buy it in the city for me......

@EricAnderson Why not use the AR_InvoiceHistoryHeader and compare to the AR_TransactionPaymentHistory table?

Doesn't the transactionPaymentHistory table purge each month based on the retention settings? Worth a shot though. Maybe cash receipts history table also.

the funny thing is, they had about 20-30 invoices for the customer this year. it took me about ten minutes to figure it out with a cash receipts report and a custom invoice history lookup/ dump to excel

@EricAnderson thanks for the feed back. Now to solve that Polygamy problem.....