You’re offline. This is a read only version of the page.
Hi,
I have a question on the Multicurrency Revaluation in the Financial Management (Routines).
I noticed that the revaluation on both Sales and Purchasing Series does not revalue the outstanding invoices as at the revaluation date (posting date) if these transactions have been moved to history at time revaluation is run. Example, invoice outstanding of C$1,000 as at 31 Dec 2015. Payment applied on 15 January 2016. When user run revaluation on says, 31 January 2016 with posting date and Cutoff Document Date on 31 Dec 2015 , this invoice will not be revalued.
This should not be case as revaluation should applies to all outstanding invoices on the posting date eventhough they have been fully applied at the time revaluation is run.
Does anyone have any idea why is the inconsistency in how Dynamics GP works?
*This post is locked for comments
Hi Pierre,
Appreciate for your feedback. I agree that those are the few things we can at the moment. And thanks for suggesting to add this in Microsoft Connect. I have just done that.
Thanks!
Hi Joyce
I've been using/implementing Dynamics GP since version 7.5 and this always been a problem. It is probably due to the structure of the tables of the Database and the way the stored procedure for the revaluation has been built. In the tables MC020102 and MC020103 which contains the multicurrency information for the receivables and for the payables there is no field to let the system know the date the invoice has been paid, that information is other tables, so what they probably did to calculate the unrealized revaluation is to use the cutoff date and the current originating transaction amount without looking for the paid date.
The only things I can suggest :
- Don't enter any payments until the revaluation is done for the sub-ledger
- Don't revalue the sub-ledger, only revalue at the financial level
- Go on the Microsoft Connect website and add the suggestion to fix this problem, at every service pack they are trying to include the top suggestions (https://connect.microsoft.com/dynamicssuggestions/feedback/CreateFeedback.aspx)
Hope it helps
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (