Announcements
Hi:
For just one customer, the A/R Historical Aged Trial Balance (HATB) is not matching the total of the "Current Trx Amount" in SmartList.
The HATB is saying that the customer has a credit balance. But, that is not what SmartList is showing.
I have, already, run Reconcile in Utilities for the customer.
I feel like we have looked into all possibilities. But, if anyone has even a general idea on this, I'm all ears.
Thank you!
John
Thanks, Brandon! Running the aging again helped!
Hello John,
Thank you for your question on the forums.
On the HATB, when you refer to Current Transaction Amount, are you referring the Current Aging bucket? Or is your report modified to have the Current Amount Field?
With your Smartlist, what Smartlist are you using? Is this a custom Smartlist?
When you ran Reconcile, what options did you run the Reconcile process on? If it is an issue with Current Amounts, the option we would have wanted to run this on is 'Outstanding Document Amounts'. If this is not the option you used, test this option to see if it makes a difference.
The first thing that needs to be done is determine which one is currently showing the correct values. Once this is determined, you can dig into those transactions.
I recommend all testing be done in a test company with a copy of live. The information above is provided to you As-is.
I hope this helps!
Microsoft Support Engineer | Brandon Jarrett
André Arnaud de Cal... 291,359 Super User 2024 Season 2
Martin Dráb 230,370 Most Valuable Professional
nmaenpaa 101,156