Configure Exchange Rate according to Document Date in D365:
(1) According to the Microsoft Dynamics 365 Business Central, we get the Exchange Rate value according to the “Posting Date” of documents.
(2) But in this blog, we will see how to configure a custom setup for Exchange Rate value according to the “Document Date” of the document.
(3) For this, we will take an example of “Purchase Order”. First configured “Currency Setup” as shown.
- Currency Setup: Open Currencies page.
- The currencies list opens as shown.
- After that, select the currency and set up its Exchange Rate as shown.
- The Exchange Rate page opens and enters the currency rate date wise as shown.
(4) Now go to the search box and type “Purchase Order”, as shown.
(5) Purchase Order list opens and creates a new Purchase order or opens existing Purchase Order. In this example, the existing Purchase Order opens and sees the functionality of the Exchange Rate value.
By default, Functionality by Microsoft:
- Exchange Rate Value gets according to the “Posting Date of Purchase Order as shown.
- The system asks for confirmation, Press Yes, as shown.
- The system again asks for confirmation, Press Yes, as shown.
- Now go to the “Invoice Details” tab and click on the Assist button of the “Currency Code” field, as shown.
Custom Setup:
- Custom Functionality developed in which Exchange Rate Value gets according to the “Document Date” of Purchase Order as shown.
- The system asks for confirmation, Press Yes, as shown.
- The system again asks for confirmation, Press Yes, as shown.
- Now go to the “Invoice Details” tab and click on the Assist button of the “Currency Code” field, as shown.
- For the above custom functionality, do the below development, as shown.
