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
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
Thanks Ludwig, for your help !
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
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.
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
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.
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,113 Super User 2024 Season 2
Martin Dráb 229,918 Most Valuable Professional
nmaenpaa 101,156