Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance forum / Foreign Currency Reval...
Finance forum
Unanswered

Foreign Currency Revaluation - AR

(1) ShareShare
ReportReport
Posted on by praveens007 138
Dear members
I have a very peculiar issue here with the revaluation of Invoices in Foreign Currency. 
I had invoice which was raised in EUR in April 24
- Revaluation for April and May went off well.
- Before I did the revaluation for June, I settled the invoice on July 2nd
- Then I ran the Revaluation for Jun'30. When I did that there was a huge amount which came in June under gain/loss. But in July it is reversing that amount also. But my June numbers go for a toss. 
 
Can someone please let me know if they  had a similar issue or are there any rules that the settlement should be done only after the Revaluation.
 
 
Any help/adivce will be great help and KB.
 
regards
PS
 
Categories:
Financial Management
  • Bharath jain Profile Picture
    Bharath jain 512 on at
    Foreign Currency Revaluation - AR
    Hi Praveen,
     
    have you verified the exchange rate. cant think of any other reason.
     
    Regards,
    Bharath Jain
  • praveens007 Profile Picture
    praveens007 138 on at
    Foreign Currency Revaluation - AR
    Dear Andre,
     
    I am sure and agree with you that this is so insane. We do have customisation with regards to decimals. We have extended to 3 decimals in our environment.
     
     
    Regards
    Pravin
     
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 287,696 Super User on at
    Foreign Currency Revaluation - AR
    Hi Praveen,
     
    This is insane! Do you have customizations or is this fully standard? In case it is standard, I would suggest checking LCS issue search for a known issue or create a ticket for Microsoft Support.
  • praveens007 Profile Picture
    praveens007 138 on at
    Foreign Currency Revaluation - AR
    Dear Andrea
    Thanks for your response.  If you look at the below example. I had now settled the invoice today which is 7th July. Then i ran the revaluation for Jun'24. Marked in blue arrow are the amount which i dont understand. Though these amounts are reversed but in July only. When i see my books for June they are way out with that amount.
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 287,696 Super User on at
    Foreign Currency Revaluation - AR
    Hi Praveen,

    Can you provide an example with amounts? Is the huge amount somehow explainable? Is July 2 used as the settlement date or is that the date when the settlement itself has been done?

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

more Community News

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,696 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,490 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans