Help! The auditor's are here and they are asking for a accounts receivable listing as of the year end. When I go into receivables and post an aged trial balance it only includes about half the outstanding customer accounts. It appears to be missing any accounts that were paid after that date as well as the odd misc customer. Any suggestions?

Kim

Select Reports | Transaction & Analysis Reports | Aged Trial Balance, then in the Print options select Calculate as of.

Hi Andrew

I would be surprised if nobody has reported this before, but you will get the results Kim describes if you have run period end as of a date later than year-end.

What should happen (and does happen in Payables) is that you are prevented from running a "calculate as of" report earlier than the date of the last period end. However, for some reason Receivables doesn't prevent this, and instead prints incorrect figures.

Steve

Hi
This is what I did and the result were the incorrect amounts I described.

Kim

Hi Kim:

Do you have a copy of the AR data as of the Year-End? If it's in a different folder on your computer, point AR at it. If it's on a backup such as a tape, restore it to a different folder - Do NOT restore it to your current live folder. Point AR at that new folder and print the report.

Have you run a Period End since your Year-End? Did you use a "Transaction Clearing Date" later than the last day of the previous fiscal year? If you're like most people, the answer is "Yes" to both questions.

The Period End process transfers paid Invoices from Current to Historical. You can see this if you look at the "Transactions" tab for one of your Customers. Some transactions are in Current while older ones appear in Historical.

Unfortunately the AR Trial Balance report can only report on the Current table. This is why you are missing invoices.

Softrak is designing AR 9.0 right now and I believe that this is one area that will be improved.