Sage 100

Early last year we upgraded a client from 4.05 to 2015. They had/have ACS Property Management. Just recently they reported to us that in the old version, they could print an AR Aged Invoice report for customers with a zero balance, but not in the new version. I cannot duplicate her claim. Note: the person doing the reporting to us is the owner, but she has not been a user of the system. The user who actually worked in Sage left the company months ago. Brandi from ACS claims that even in the old version, no PM reports would give her what she is asking for. Can anyone disprove my claim that the Aged Invoice Report has never reported on zero balance customers? Additionally, has anyone ever gotten an Aged Invoice report to print for zero balance customers short of building a totally custom report?

Perhaps she is confusing the customer statement with the aging report???

If the balance is 0 then the customer is current. It isn't necessary to print an aged invoice report.

Is ""Include paid invoices"" checked?

@JeffSchwenk I thought she might be confusing agings with statements, too, but she forwarded me an email from former employee who emailed her agings and commented that agings only printed for customers that had balances. @DougHiggs , she has a purpose (reporting to shareholders) for sending 0 balance agings. Not that we couldn't design something custom for her. She is adamant that Sage used to do this and she shouldn't have to pay for something custom. Sigh.

No, because that gives her all invoices from the beginning of time.

Is v4.05 still on the server? Take a look see?? I love it when upgrades produce phantom memories of the good old days!!!

Been there, done that. Can't make it happen.

Have the client show you on 4.05.

in old 4.05 is there a report setting for customized AR Aging or even customized TB?

No, AR was still old business framework.

Right....05 not .5 duh...

My bet is that the work file excludes zero invoices so you'll have to link in AR Open. Change the join so all from AR Open are selected. Haven't tested this though. Make a note to bill for this on your next project, then send her a zero invoice.