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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / How does Order Date af...
Small and medium business | Business Central, N...
Answered

How does Order Date affect the FX rate of Posting Date in Sales order?

(6) ShareShare
ReportReport
Posted on by joshtechsolutions 4,979
Hi Community,
 
In Sales Order, when I try to set the posting date to a later date, the NAV will ask me whether I wants to update the FX rate.
This I can understand, that in every sales invoice, the FX rate is based on the posting rate.
 
However,  when I try to change the Order Date, NAV will also warn me that the FX rate will be change, for this I don't quite understand why would the Order Date be triggering the FX Rate.
 
Since when you post no matter what the FX rate for Order Date is, ultimately, NAV will still take the FX rate of the Posting Date for Sales Invoice.
 
May I right? 
 
Can anyone please explain?
Categories:
Dynamics 365 Business Central
Microsoft Dynamics NAV
I have the same question (0)
  • Verified answer
    Mansi Soni Profile Picture
    Mansi Soni 8,909 Super User 2025 Season 2 on at
    Hello, Yes, you're correct that NAV (or Business Central) ultimately uses the FX rate based on the Posting Date when the Sales Invoice is posted. However, the system also updates the FX rate when changing the Order Date because NAV allows businesses to manage exchange rates dynamically. The Order Date can be used for pricing, planning, or reporting purposes, and some companies may use it as a reference for expected exchange rates. This is why NAV prompts you about an FX rate change when modifying the Order Date, even though the final rate for posting will be determined by the Posting Date.

    Hope this answer helps you!

    Regards,
    Mansi Soni
  • Verified answer
    Jainam M. Kothari Profile Picture
    Jainam M. Kothari 15,639 Super User 2025 Season 2 on at
    Hello
     
    In Business Central, the FX rate is indeed based on the posting date for sales invoices. However, when you change the order date, the system prompts you about the FX rate change because the order date can influence the initial FX rate used for the transaction. This is to ensure that any changes in the order date are reflected accurately in the FX rate calculations, even though the final FX rate applied at posting will be based on the posting date. This mechanism helps maintain consistency and accuracy in financial records throughout the order processing cycle.
  • Verified answer
    Khushbu Rajvi. Profile Picture
    Khushbu Rajvi. 20,601 Super User 2025 Season 2 on at
    when posting a sales invoice, NAV ultimately uses the FX rate based on the Posting Date. However, the system's warning when changing the Order Date is due to how NAV retrieves and updates exchange rates.
     
  • joshtechsolutions Profile Picture
    joshtechsolutions 4,979 on at
    Hi Mansi Soni ,
     
    Thank you so much for the direct and clear explanation !
     
     
    When you said that the fx rate in the order date can influence the fx in the posting date, can you explain how does it influence and also if you have any examples to provide, that will be great.
     
     
    Thank you for the further clarification.
  • Verified answer
    Jainam M. Kothari Profile Picture
    Jainam M. Kothari 15,639 Super User 2025 Season 2 on at
    Helllo,
     
    Sure, Please find the attached Example
    Example
     
    Let's consider an example to illustrate this:
    1. Order Creation:
    Order Date: January 1 2026
    FX Rate on Order Date: 1 DKK = 8 INR
    Transaction Amount: 4500 DKK
    Estimated LCY Value: 4500 DKK * 8 INR/DKK = 36,000 INR
     
    2. Posting the Transaction:
    Posting Date: January 31 2026
    FX Rate on Posting Date: 1 DKK = 8.15 INR
    Actual LCY Value: 4500 DKK * 8.15 INR/DKK = 36,675 INR
     
    3. Resulting Gain:
    Gain: 36,657 INR (Actual) - 36,000 INR (Estimated) = 675 INR
     
    In this example, the company experiences a gain of 675 INR due to the appreciation of the DKK against the INR between the order date and the posting date.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,238

#2
YUN ZHU Profile Picture

YUN ZHU 773 Super User 2025 Season 2

#3
Sumit Singh Profile Picture

Sumit Singh 630

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans