Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Multi-currency Balance...
Microsoft Dynamics GP (Archived)

Multi-currency Balance on Receivable Historical Trial Balance

(0) ShareShare
ReportReport
Posted on by Bill Campbell 22,647

We have a client that reports the following

- an AR Trial balance for US vendors reports ZERO transactions and ZERO dollars

- a GL Control Account for the US Accounts Payable that also reports ZERO dollars

-- ALL OF THIS IS CORRECT and EXPECTED

He then runs the Historical Aged Trial Balance and the US Value comes up ZERO, but the CANADIAN value at the end of the report shows $8,000.00

Now I now the Canadian dollar is bad, but come on 8,000 in the hole just to get out to ZERO.

So we know we have a problem.  I am looking for assist on how to clear the 'mystery' 8,000.00

There are no US transactions in this company for the past 2 years - this is only a reporting issue - there are no outstanding cheques, invoices, payments or other documents that might be holding the value.

So before I spend a bunch of time I thought I would ask all of you for assistance.

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Multi-currency Balance on Receivable Historical Trial Balance

    No.

  • jliang Profile Picture
    jliang 30 on at
    RE: Multi-currency Balance on Receivable Historical Trial Balance

    Hi Bill,

    May I ask if you manage to sort out this mystery? We are running into a similar scenario and the recommendation of cleaning out from the back-end does seem to be a preferred idea. So I am googling and try to have a more reliable way to resolve it.

    Thanks in advance,

    Jimmy

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Multi-currency Balance on Receivable Historical Trial Balance

    Hi Bill:

    Did any of these suggestions work, for you?  I'm running into the same issue and need to know how to fix.

    Thank you!

    John

  • Bill Campbell Profile Picture
    Bill Campbell 22,647 on at
    RE: Multi-currency Balance on Receivable Historical Trial Balance

    Heather, thanks for this, I am in the process of getting the Test Environment configured with the last backup of the database so I can try to implement some of the suggestions coming my way.

  • Heather Roggeveen Profile Picture
    Heather Roggeveen 9,142 on at
    RE: Multi-currency Balance on Receivable Historical Trial Balance

    Have you tried using MC Revaluation on the sub-ledger?  Does that give any results?  Tools --> Routines --> Financial --> Revaluation

  • Bill Campbell Profile Picture
    Bill Campbell 22,647 on at
    RE: Multi-currency Balance on Receivable Historical Trial Balance

    THis is a screen shot of the Historical Aged Trial balance in question - hoping a picture helps jog someone memory on the solution.

  • Bill Campbell Profile Picture
    Bill Campbell 22,647 on at
    RE: Multi-currency Balance on Receivable Historical Trial Balance

    Cheryl, the client simply want to make this go away and I am prepared to work in the test company to figure this out, but I need a bit of direction on the tables that are holding this data.

    The MC020102 appears to hold the MC version of the RM table - but only parts as I can not determine the Apply side of the transactions.

    So my request now is for direction on the tables that I need to - in a TEST environment - develop a way to remove the selected data as per the request of the client.

  • Cheryl Waswick Profile Picture
    Cheryl Waswick on at
    RE: Multi-currency Balance on Receivable Historical Trial Balance

    Hi Bill,

    I am only advising to 'test' clearing out these tables to prove if these tables are the issue or not.  

    I wouldn't recommend deleting any data out of them.  It is up to you if you want to delete any data out of them.  Instead, if you want/need the history, I would recommend to find which record is causing the issue and correct it.   There could just be an amount in a column that needs to be updated...

    Cheryl

    Microsoft Community

  • Bill Campbell Profile Picture
    Bill Campbell 22,647 on at
    RE: Multi-currency Balance on Receivable Historical Trial Balance

    Can I clear the data for specific Account - some of the data must be of use to the system.

    So, I am clear, this error is related to only one account and it is historical.  The AR and the GL agree, with the exception of this MC entry.

  • Cheryl Waswick Profile Picture
    Cheryl Waswick on at
    RE: Multi-currency Balance on Receivable Historical Trial Balance

    Hi Bill,

    So it sounds like there is historical data.  Did you want the historical data?

    The AR TB is correct, so this tells me the RM tables are correct. The GL report is correct, so this tells me the GL tables are correct.   But the MC report is not, so this tells me that it may be pulling from an MC table, such as the MC020104 RM Transaction table or MC020104 RM revaluation table.      In a test company, you can clear these tables out and then verify if it is zero now to prove that its due to the data in these MC tables.

    Thanks,

    Cheryl

    Microsoft Community

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,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans