Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Can someone explain the MC020104 table - when and how it is updated and why does a field value in this table impact results that appear on the Historical Aged Trial Balance AR report?

Posted on by Microsoft Employee

 It appears the RM Transaction History removal isn't clearing this table for certain transactions for us - and I want to know if its safe to manually clear it?

 

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Can someone explain the MC020104 table - when and how it is updated and why does a field value in this table impact results that appear on the Historical Aged Trial Balance AR report?

    I agree that it should impact the HATB if the transaction is still open.  But this item was paid - by the time you run paid transaction removal - all forex gain loss recognition should have happened.  

    We have tested using the prof. tool to unapply the payment - reapplied it - ran reconcile etc it is not clearing out the amounts from this table.  The orig HATB line amount is zero - yet it shows a functional currency amount because of the amount in this table.

    I will go after GP to get to the bottom of this - but curious if anyone else ran into this - looks like a bug in the report picking up a balance on a fully paid item.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Can someone explain the MC020104 table - when and how it is updated and why does a field value in this table impact results that appear on the Historical Aged Trial Balance AR report?

    This is the Receivables Management revaluation table. It tracks multicurrency revaluations on RM documents. I believe it would affect the Hist. Aged TB since depending on the date that you print the TB at - the functional totals of documents could change.

    Normally, this table should not manually cleared.

    Do the transactions have anything in common?

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans