Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP forum
Answered

A/R Historical Aged Trial Balance Not Matching SmartList

Posted on by 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

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: A/R Historical Aged Trial Balance Not Matching SmartList

    Thanks, Brandon!  Running the aging again helped!

  • Verified answer
    Hokuminaria Profile Picture
    Hokuminaria 2,950 on at
    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.

    1. If the HATB report is incorrect, run the report in Detail so you can see what makes up the balances of the Current Field.
      1. Compare the transaction on the Detail Report to the Smartlist to determine which one is not the same on both the HATB and Smartlist. 
      2. You can then dig into the Transaction(s) that are different in SQL and determine the data and how to correct it.
    2. If the Smartlist is incorrect,  run the HATB report in Detail so you can see what makes up the balances of the Current Field.
      1. Compare the two to determine which document does not have the same value for the current field.
      2. Double click on the Transaction in the Smartlist to drill back.
      3. Review the Transaction and Apply records to verify if any issues.
      4. If you don't see any issues, review the transaction in SQL.
      5. 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. 
      6. The Smartlist is not going to use any calculations like the HATB Report. The Smartlist is going to pull directly from the tables. 
    3. You can also go into the Customer Summary window and drill into the Specific Buckets to determine what transactions make up the Aging Buckets.
      1. Sales >> Cards >> Summary
      2. Enter the customer.
      3. Select the Bucker in question.
      4. Click the blue Amount hyperlink to drill into the documents that make up this value.
      5. Dig into the transactions that make up this balance.
    4. You could try run Aging to adjust the Current Aging bucket.
      1. 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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,532 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,501 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Product updates

Dynamics 365 release plans