A/R Historical Aged Trial Balance Not Matching SmartList

(0) Share

Report

Posted on by Community Member Microsoft Employee

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

Categories:

Microsoft Dynamics GP

All responses (2)

Answers (1)

Community Member Microsoft Employee on at

Like (0)

Report

RE: A/R Historical Aged Trial Balance Not Matching SmartList

Thanks, Brandon! Running the aging again helped!
Verified answer

Hokuminaria 2,950 on at

Like (1)

Report
RE: A/R Historical Aged Trial Balance Not Matching SmartList

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.

If the HATB report is incorrect, run the report in Detail so you can see what makes up the balances of the Current Field.

Compare the transaction on the Detail Report to the Smartlist to determine which one is not the same on both the HATB and Smartlist.

You can then dig into the Transaction(s) that are different in SQL and determine the data and how to correct it.

If the Smartlist is incorrect, run the HATB report in Detail so you can see what makes up the balances of the Current Field.

Compare the two to determine which document does not have the same value for the current field.

Double click on the Transaction in the Smartlist to drill back.

Review the Transaction and Apply records to verify if any issues.

If you don't see any issues, review the transaction in SQL.

The HATB looks at the Transaction and Apply Records to determine what the values are on the aging buckets. If one of the transactions is damaged and either of the records are missing but the other exists, you can see incorrect info on the HATB Report.

The Smartlist is not going to use any calculations like the HATB Report. The Smartlist is going to pull directly from the tables.

You can also go into the Customer Summary window and drill into the Specific Buckets to determine what transactions make up the Aging Buckets.

Sales >> Cards >> Summary

Enter the customer.

Select the Bucker in question.

Click the blue Amount hyperlink to drill into the documents that make up this value.

Dig into the transactions that make up this balance.

You could try run Aging to adjust the Current Aging bucket.

Sales >> Routines >> Aging

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