web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Detail Historical Aged...
Microsoft Dynamics GP (Archived)

Detail Historical Aged Trial Balance problem

(0) ShareShare
ReportReport
Posted on by Daisy_P 435

When I run the Detail Historical Aged Trial Balance for Receivables it shows items that have been in History for years.  I ran the historical and regular aged trial balance with a date of today and there are several items on the historical that are not on the regular.  Any ideas how to remove them from the historical report so it will be accurate?

Thanks for your help!

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Tim W Profile Picture
    Tim W 2,925 on at

    There are some number of rogue apply records or missing records in ether RM20201 or RM30201 (or both) which cause this issue and I've seen it a number of times. 

    If you query RM20201 and RM30201 where APTODCNM = <one of the several items> you will see that the totals of the actual apply records (as opposed to the current trx amount in RM20101  RM30101 which would say zero) wont add to the document total.

    When GP does the HATB it takes the document amount then subtracts off the applied amounts it finds within the date you specify so it can do an 'As Was' report.  I've even seen the document amount go negative in the report when there were 'extra' apply records.  I've decided  that the Apply/Un-Apply/ Remove Paid Transactions processes are not done in a transaction state so you are at the mercy of the process completing correctly.   I've seen this issue come up like this many times over the years.   

    I've always had to fix this from SQL both inserting missing records (that's pure pain) and deleting extra ones, I've never had checklinks fix this issue but others here might have a different experience.

    Best

    Tim

      

  • Community Member Profile Picture
    Community Member on at

    Start by verifying that both reports are excluding the same values in report options window. I would exclude Fully Paid Documents, Zero Balance, No activity. Also, make sure that both reports have the same selection as Historical Trial balance can be by Document Date while AR Trial Balance with Options is by GL Posting Date and no other restrictions are selected. Reprint reports. Check the totals. If there is a difference between the two, then you may have missing apply records or may have damaged records in your historical apply tables.  The ATB pulls from the open table. The HATB pulls from the Open and History tables.

  • Daisy_P Profile Picture
    Daisy_P 435 on at

    We will try that.  Thanks!

  • Daisy_P Profile Picture
    Daisy_P 435 on at

    Both reports are setup exactly the same.  

  • sandipdjadhav Profile Picture
    sandipdjadhav 18,306 on at

    Hi Daisy,

    Did you try to remove paid transaction removal from Tools-->Routines-->Sales-->Paid Transaction Removal.

    Please do this R&D on your test enviornment and before running Paid Transaction Removal on Production keep good backup.

    It will move all your fully paid transactions into Historical tables.

    Thanks
    Sandip

  • Daisy_P Profile Picture
    Daisy_P 435 on at

    I did paid transaction removal and it didn't make a difference.  The items are already listed as history, they do not show open.  Yet they show on the trial balance report even though they have been in history for years.  

  • Bill Campbell Profile Picture
    Bill Campbell 12 on at

    Tim, do you know if the same would apply to Multicurrency transactions?  We have a case from a client with ZERO in the Functional Currency, but showing amounts in the Reporting currency.

    Thanks for the feedback

  • Tim W Profile Picture
    Tim W 2,925 on at

    Hi Bill.

    Not so much as detailed above for that but probably there are issues with the MC020102 table which holds the currency values for MC transactions.  If you query it against the documents in question you will probably see those records misrepresented there.

  • ateel7 Profile Picture
    ateel7 5 on at

    Bump. Any answer to this? Having same issue.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans