Skip to main content

Notifications

Microsoft Dynamics AX (Archived)

Foreign Currency Revaluation AR and AP option checked "Foreign currency revaluation" in MainAcount

Posted on by Microsoft Employee

Hi all ! 

I have a problem ,  i checked "Foreign currency revaluation" for main account in MainAccount when i revalued in AR and AP, I want only the main account has been made operational check revaluation. Help Solution or Customize for me, please !

*This post is locked for comments

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Foreign Currency Revaluation AR and AP option checked "Foreign currency revaluation" in MainAcount

    Hi Thanh Nguyen,

    I just thought that your requirement can be achieved by applying the following workaround.

    Probably you can test this in a demo environment.

    Step 1: Setup a new posting profile that you use for your AP (or AR) revaluation process. Assign a new account - for example - 13100003 - as summary account to this posting profile

    Step 2: Run the foreign currency revaluation and check the adjustment that has been recorded on account 13100003

    Step 3: Now you have to make an adjustment posting based on the foreign currency amounts posted on account 13100001 and 13100002. To realize this you have to calculate the ratio of the  foreign currency amounts posted on account 13100001 and 13100002 and multiply this ratio by the amount posted on account 13100003. I do not know if you Need to record this adjustment on the vendor account or not. If you only require it at the main account level, you could make use of the GL allocation rules that would automatically do the calculations and postings for you.

    This is not a perfect and 'manual' solution but maybe one that helps you getting around this issue. Probably test this in a demo environment and see if you can use this as a workaround.

    Hope this helps,

    Ludwig

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Foreign Currency Revaluation AR and AP option checked "Foreign currency revaluation" in MainAcount

    Thanks Ludwig,  for your help !

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Foreign Currency Revaluation AR and AP option checked "Foreign currency revaluation" in MainAcount

    Hi Thanh Nguyen,

    So you have two summary accounts that you use for a single vendor - by making use of different posting profiles for different kinds of transactions - and you want only one of them to be revaluated.

    Is that right?

    I do not think that this can be achieved with the standard solution and would require a system modification as the GL Parameter that you activate at the COA level does not influence the foreign currency revaluation you run in AP/AR.

    If I remember it correctly some similar questions have been raised before in this forum. Probably check if you can find them and what has been suggested to get this resolved.

    Would be great if you could Keep us upated here how things are going.

    Many thanks,

    Ludwig

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Foreign Currency Revaluation AR and AP option checked "Foreign currency revaluation" in MainAcount

    Hi Ludwig ! because my Customer required when they revalued in AR or AP then only the main account has been made operational check revaluation. Example : i have posted 2 payment journals : 1 payment journals use main account 13100001---- ( this main acount checked)  and 1 payment journal 13100002---- ( this main acount not checked) . when i revalued  in AR then only 13100001---- ( this main acount checked) be done.

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Foreign Currency Revaluation AR and AP option checked "Foreign currency revaluation" in MainAcount

    Hi Thanh Nguyen,

    I do not fully get your issue.

    If you already run a foreign currency revaluation in AP or AR, Dynamics is already adjusting your customer/vendor balances and the related ledger summary accounts.

    Why would you want to do another secondary currency revaluation for those summary accounts?

    Ludwig

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Foreign Currency Revaluation AR and AP option checked "Foreign currency revaluation" in MainAcount

    Hi Ludwig ! I want revalued in AR or AP, Example:  AR i want to get maincount has been check for trasactions AP.

    But GL will revalued main acount irrespective AP or AD.

    Best regards, Thanh Nguyen.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Foreign Currency Revaluation AR and AP option checked "Foreign currency revaluation" in MainAcount

    Hi Thanh Nguyen,

    Did I get you right that you only want to see the foreign currency revaluation at the ledger account Level but not at the customer/vendor Level?

    If so, have you tried running the foreign currency revaluation in GL?

    (There is a specific periodic feature available there that only affects your ledger accounts)

    Best regards,

    Ludwig

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 229,918 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans