VAT - Dynamics 365 Fin Ops

Out of the box, D365FO provides External codes feature to capture external references for Customers and Vendors. This could be an external system reference of Customer or Vendor accounts. Standard D365FO External codes data model limits an external code value to be linked to only one account per type - meaning when customer "C0001" has an external code "MemberId" with value "M0001", system will not allow another customer "C0002" to have external code "MemberId" with value "M0001". This limitation is implemented at the table index level. However, there will be scenarios where the business requires same external code value to be allocated to multiple customer accounts. One such is multiple customer accounts linked to one dealer or some businesses having multiple accounts for same customer segregated by state or other criteria. In such cases, the out of the box index limitation will not allow same external code value to be alloca...

In some D365 FinOps implementations, we face scenarios where there is a requirement for reciprocal exchange rate between currencies. Out of the Box, D365 FinOps calculates B to A rate when A to B rate is configured and does not allow set up of B to A when A to B rate is configured. To achieve the requirement, we can make a small customization /extension to allow configuration of exchange rate B to A, while having A to B configured in the same exchange rate type.                                                                                                                                                         ...

Often in implementations, organizations require different exchange rates per legal entities as per the Forex rates agreed with Banks in the Legal entity country. Dynamics 365 Finance and Operations provides the feasibility via Currency exchange rate types and Ledger settings. (Understand this might be 101 for many FinOps functionals, however off late faced some D365 consultants missing this knowledge so posting to help others in need) Currency Exchange rates per type – “Default” and “USRT Default” On Ledger form in General Ledger module,  Accounting currency exchange rate type  can be setup for a Legal Entity. The below screen shots depict different legal entities setup with different  Accounting currency exchange rate type – “Default” for “USMF” and “USRT Default" This way separate Currency exchange rates can be applied in different legal entities. Happy DAXing :)