Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Currency Revaluation Stuck with Local Balances for customer

Posted on by Microsoft Employee

Last month when I made a currency-revaluation for sales module from financial, found any customer in foreign currency is in its balance in (sales & financial posted journal) but in local currency found that the difference in currency shown in his balance summary Inquiry!

Ex.  Customer Nu 51009, follow data from financial in excel report and in exactly balances local & foreign.

5282.diff22.gif

But in sales module shown not real balance for local currency

this customer paid his balance in USD but in local currency still have balance equal to loss/revenue for currency revaluation.

Thanks for knowing why this happen & how to correct it

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Currency Revaluation Stuck with Local Balances for customer

    1145.AR_2D00_TRX_2D00_Disttribution.jpg

    4034.AR_2D00_TRX_2D00_Inquiry_2D002D00_USD.jpg

    5076.AR_2D00_TRX_2D00_Inquiry_2D002D00_LE.jpg

  • Olaf Laos Profile Picture
    Olaf Laos 1,890 on at
    RE: Currency Revaluation Stuck with Local Balances for customer

    Can you show a screen shot of one of the sales transactions in the "Receivables Transaction Inquiry Zoom" window - and then also the screen print of the "Receivables Transaction Revaluation Zoom" window after the Revaluation button is pressed from the "Receivables Transaction Inquiry Zoom" window?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Currency Revaluation Stuck with Local Balances for customer

    Thanks your reply Mr OLLY,

    I'm already checked Reconcile and check link for sales, unfortunately not work

    Is there is a way to refresh the  Original amount to be equal Unapplied amount in Inquiry? notes I don't use apply document in sales module.

  • Suggested answer
    Olaf Laos Profile Picture
    Olaf Laos 1,890 on at
    RE: Currency Revaluation Stuck with Local Balances for customer

    If you believe the Receivables Summary is incorrect, it may first be worth running a reconcile via Tools > Utilities > Sales > Reconcile  - and reconcile the Current Debtor Information and the Outstanding Document Amounts for certain customer accounts.

    This will at least help to narrow down the 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

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans