Skip to main content

Importing Exchange Rate in D365 F&O AX 2012 using X++ code

Exchange rate is one of the common factor used in D365 F&O used usually when conversion in between Accounting currency-Reporting currency or transnational currency-Accounting currency is required. Purpose of this code is to retrieve current conversion rate configured in our AX for a particular date.


public CurrencyExchangeRate CMTExchangeRateCalculator( TransDate transDate,VendCurrencyCode fromCurrency,VendCurrencyCode toCurrency)
    {
        ExchangeRateType ExchangeRateType;
        ExchangeRateCurrencyPair exchangeRateCurrencyPair;
        real             exchRate;
     
     if(fromCurrency != toCurrency)
        {
            select firstonly exchangeRateCurrencyPair
            where
                exchangeRateCurrencyPair.ExchangeRateType ==               Ledger::find(Ledger::current()).DefaultExchangeRateType
                &&  exchangeRateCurrencyPair.FromCurrencyCode == fromCurrency
                &&  exchangeRateCurrencyPair.ToCurrencyCode   == toCurrency;

            exchRate = ExchangeRate::findByDate(exchangeRateCurrencyPair.RecId,transDate).ExchangeRate;

            if(exchangeRateCurrencyPair)
            {
                return (exchRate/100);
            }
            //for vise-versa case of conversion
            else
            {
                select firstonly exchangeRateCurrencyPair
                where
                    exchangeRateCurrencyPair.ExchangeRateType ==     Ledger::find(Ledger::current()).DefaultExchangeRateType
                    &&  exchangeRateCurrencyPair.FromCurrencyCode == toCurrency
                    &&  exchangeRateCurrencyPair.ToCurrencyCode   == fromCurrency;

                exchRate = exchangeRate::findByDate(exchangeRateCurrencyPair.RecId,transDate).ExchangeRate;
                return (1/minOne((exchRate/100)));
            }
        }
//for No conversion rate case
        else
        {
            return 1;
        }
 }

Comments

Post a Comment

Popular posts from this blog

Update record set using update_recordset in d365 F&O | AX 2012 using X++

Hello Devs! One the most common condition that we being a developer faces is to update existing records set that is mostly done on report level when we need to add new fields in the Temporary table and we don't wants to make extensions on class level. Here is a small piece of code that will assist you in updating existing record sets.  update_recordset custAgingReportTmp                 setting                 CMTCustInternalCollector = hcmWorker.PersonnelNumber,                 PaymDayId                         = custTable.PaymDayId,                 PaymTermId                       = custTable.PaymTermId,                 CashDisc      ...
1 comment
Read more

Import DB backup from .BacPac file in D365 F&O using CMD

Hello Devs! This is one of the most quickest way to import DB from .Bacpac file. Bacpac files are those which are generated from Tier 2 or higher environments as a DB backup.   Alternate Approach ----> Using wizard Prerequisites: 1) Access to LCS folder Asset library --> Database Backup Incase you don't see the folder ask your project owner to give you the access. Step 1:  Download the file and save it in local non-user directory.  Step 2: - Services to be stopped World Wide Web Publishing Service Management Reporter 2012 Process Service Microsoft Dynamics 365 Unified Operations: Batch Management Service Microsoft Dynamics 365 Unified Operations: Data Import Export Framework Service - Download SqlPackage.Exe.  Download link :  https://learn.microsoft.com/en-us/sql/tools/sqlpackage/sqlpackage-download?view=sql-server-ver15 Extract it and Open CMD as admin.  Step 3 :  Navigate to directory where you have extracted the SqlPackage.Exe folder us...
Post a Comment
Read more

Adding D365 F&O Extension in Visual Studio 2022 | Dynamics

  Hello Devs! This is a very common scenario when it comes to enabling D365 extension within VS 2022, so for that below are list of steps needs to be done to enable extension for development. Please note for Older VS versions please refer to my blog below : https://www.linkedin.com/feed/update/urn:li:ugcPost:7033677029451440128/ Prerequisites: Visual Studio 2022 should be installed before performing below steps. Step # 1: Login to LCS (Microsoft Dynamics lifecycle services). In the main page after login there is a option of Shared asset library (without entering into project folder). Step # 2: In the list of sub menus , Select Software deployment package and search for latest Service update. For my case I am downloading 10.0.41 Step # 3 : Once you have downloaded it. Unzip the folder and search for FinanceAndOperations_10.0.2015.54_Application\DevToolsService\Scripts Before installation you will not be able to see Dynamics 365 option within VS 2022. Now please clos...
Post a Comment
Read more