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

Announcements

The Next Big Bite | Aussie Classics & Starting Small with Clay Wesener | EP04
Check out the Community Spotlight Video Series
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Foreign Currency Reval...
Microsoft Dynamics AX (Archived)

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

(0) ShareShare
ReportReport
Posted on by Community Member

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

I have the same question (0)
  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    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

  • Community Member Profile Picture
    Community Member on at

    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.

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    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 on at

    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.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    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 on at

    Thanks Ludwig,  for your help !

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    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

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

News and Announcements

The Next Big Bite | Aussie Classics & Starting Small with Clay Wesener | EP04
Check out the Community Spotlight Video Series

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans