Hi Jean,

I can assure you that the ATB includes adjustment batches!

If you print that ATB for August 31 does it tie to the GL? How about for October 31? How about today?

Hi Jean,

If in AR, you edit the customer to which the adjustment was posted, and open the Transactions tab, can you find the adjustment transaction? Is it in the Current list or the Historical list? Just to cover the possibility that it was purged completely from the data, and thus the report couldn't find it to print. Also, view the adjustment Applied details to see which transaction it was applied to and also the date of the application. Presumably the date is also Sept 30, but it would be good to confirm this.

If you have run a process that moves completed transactions from current to history (Period End or printing Statements) since Sept 30, then printing the Aged Trial Balance report Calculated as of Sept 30 has to go back into history to read the transactions there. Further, the report relies on the integrity of the Transaction Matching data file to determine which invoices were applied to by cash, credits, debits or adjustments so that it can determine what the current balance of outstanding invoices were as of that date. The Applied date of the matching transaction is what the report uses - if the Adjustment applied date is Sept 30 then it should be printing on the report.

Jean:

We do see this problem from time to time. Most of the time it's because of a user data entry error. Sometimes its because the database has become corrupted.

Unfortunately it can be very hard to track the problem down without actually seeing the data. If we can assist you to track this down please give us a call.

So I'm thinking that maybe it has to do with my having run a Period End at September 30th, as the Adjustment transaction shows in History and not in Current. The Cash transaction the adjustment was applied to is an October cash transaction - I actually made 2 adjustments to this October cash transaction, one dated October to debit the AR and the one in question dated September to credit the AR (I had mistakenly applied a payment on the date that I was entering it instead of the correct September date). When I run the ATB at October 31st it is fine, although it doesn't show the Adjustments but they cancel each other out. The Customer balance is fine, the AR gl account is fine, it was just that the ATB wasn't tying in.

Thanks for all of your help - I think I'll just leave it alone as there's not a data integrity error and everything reconciles and balances now.

Cheers!!

Jean:

Adjustments that predate the transaction often cause problems. Glad you were able to come to a happy conclusion.