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

D365 Print Management Setup to print reports

In Microsoft Dynamics Ax D365, we have the out of the box feature of print management to print report either OOTB or custom reports of our clients so for that we need to configure the print management settings. We normally faces this warning message when we print the reports without the setting has been done. Firstly , select Form setup ( Accounts Receivable >> Forms >> Form setup  ) Secondly, In the General tab , select Print Management Thirdly, In the Document Tab right click and select New tab Moreover , we need to set the listed below details and need to select our required reports to load using print management Furthermore , we now nee to go to All Free Tax Invoices in AR Lastly you can use the FTI to generate the respective report using the print button. This time the Warning will be Gone!!! 
Post a Comment
Read more

Upload and Download file to BLOB storage Account in D365 F&O using X++

Hello Devs! This blog will be a source of help for many Devs who are working on Azure Blog Storage account. We normally use azure blob storage account to hold thing that need to be further processed and stored on cloud. Scenario:  We have been asked to * Upload file to azure * Download file from azure "We will be using Share File Management technique" Case #1 : Uploading File to Azure  Note : Here we are using  PurchParameter  table to extract urls and other folder related details you can use your own folder name to access the azure blob folder Further, Credential details have already been extracted i.e vault key,authorization key and has been stored in our custom table and extracted from d365 through azure parameters  storageCredentials  = new Microsoft.WindowsAzure.Storage.Auth.StorageCredentials(SystemParameters::find().CMTStorageAccountName, purchParameters.CMTTankKeyVaultSecret); Or alternatively, CloudStorageAccount storageAccount = ...
1 comment
Read more

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