Microsoft Dynamics AX Support

This blog contains posts by the Microsoft Dynamics AX Support Teams Worldwide

Adding Exchange Rates using the AIF LedgerExchangeRateService Service

The following is a quick example that may help if you need to add an Exchange Rate to an existing Currency Pair in Microsoft Dynamics AX 2012 R3 using the AIF LedgerExchangeRateService service. I ran into a couple snags along the way and finally was able to insert data correctly in AX using the below. When you create the AIF Inbound Port for this service, I recommend to enable logging under the Troubleshooting section in case you need to review the XML that is created. 

C# Console Application Example

The goal in the support case was to add an Exchange Rate to at an already existing Currency Pair (EUR to USD) pair.

 

 

The code below adds a new Exchange Rate to this existing Currency Pair. 

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

using UpdateExchangeRateTester.ERService;

namespace UpdateExchangeRateTester
{
    class Program
    {
        static void Main(string[] args)
        {
            ExchangeRateServiceClient proxy = new ExchangeRateServiceClient();

            CallContext cc = new CallContext();
            cc.Company = “USMF”;

            // Call Read First per http://community.dynamics.com/ax/f/33/t/75714.aspx
            //Criteria will be the From and To for the CurrencyPair (EUR to USD)
            QueryCriteria qc = new QueryCriteria();
            qc.CriteriaElement = new CriteriaElement[2];
            qc.CriteriaElement[0] = new CriteriaElement();
            qc.CriteriaElement[0].FieldName = “FromCurrencyCode”;
            qc.CriteriaElement[0].DataSourceName = “CurrencyPair”;
            qc.CriteriaElement[0].Value1 = “EUR”;
            qc.CriteriaElement[1] = new CriteriaElement();
            qc.CriteriaElement[1].FieldName = “ToCurrencyCode”;
            qc.CriteriaElement[1].DataSourceName = “CurrencyPair”;
            qc.CriteriaElement[1].Value1 = “USD”;
            EntityKey[] keylist = proxy.findKeys(cc, qc);
            AxdLedgerExchangeRate axdExchangeRate = proxy.read(cc, keylist);


            foreach (AxdEntity_CurrencyPair currencyPair in axdExchangeRate.CurrencyPair)
            {
                currencyPair.action = AxdEnum_AxdEntityAction.update;
                currencyPair.actionSpecified = true;        
                currencyPair.RateType = null; // do not send in a CurrencyPair RateType on updates
               
                //create new exchange rate
                AxdEntity_ExchangeRate newExchangeRate = new AxdEntity_ExchangeRate();
                newExchangeRate.ExchangeRate = 95.60M; //AX value is .95600
                newExchangeRate.ExchangeRateSpecified = true;
                newExchangeRate.ValidFrom = new DateTime(2015, 2, 5);
                newExchangeRate.ValidFromSpecified = true;
                newExchangeRate.action = AxdEnum_AxdEntityAction.create;
                newExchangeRate.actionSpecified = true;
               
                currencyPair.ExchangeRate = new AxdEntity_ExchangeRate[1] { newExchangeRate };
            }

 

            try
            {
                proxy.update(cc, keylist, axdExchangeRate);
                Console.WriteLine(“Update Call Complete”);
            }
            catch (Exception e)
            {
                Console.WriteLine(e.Message);
                Console.WriteLine(“The AxdLedgerExchangeRate was not updated.”);
            }
            Console.ReadLine();
        }
    }
}

A couple items I had to do was set the RateType to null on the AxdEntity_CurrencyPair object otherwise I was receiving an AIF Exception on RateType. I also did not send the existing Exchange Rate data in the AxdEntity_ExchangeRate[] collection.I just created a new AxdEntity_ExchangeRate with the action property set to create. The final result looks like what I wanted to achieve with a new Exchange Rate added with correct dates:

 

 

XML Example

This is the XML document that AIF processes from the C# Console Application. You can use this as a starting point if you need to know what the XML schema should look like if you need to create XML for a File Adapter Inbound port.

<?xml version=”1.0″ encoding=”UTF-8″?>
<ExchangeRateServiceUpdateRequest xmlns=”http://schemas.microsoft.com/dynamics/2008/01/services“>
  <EntityKeyList xmlns=”http://schemas.microsoft.com/dynamics/2006/02/documents/EntityKeyList“>
    <EntityKey xmlns=”http://schemas.microsoft.com/dynamics/2006/02/documents/EntityKey“>
      <KeyData>
        <KeyField>
          <Field>RecId</Field>
          <Value>22565423204</Value>
        </KeyField>
      </KeyData>
    </EntityKey>
  </EntityKeyList>
  <LedgerExchangeRate xmlns=”http://schemas.microsoft.com/dynamics/2008/01/documents/LedgerExchangeRate“>
    <DocPurpose>Original</DocPurpose>
    <SenderId>USMF</SenderId>
    <ValidAsOfDateTime>2015-02-05T00:00:00Z</ValidAsOfDateTime>
    <ValidFromDateTime xsi:nil=”true” xmlns:xsi=”http://www.w3.org/2001/XMLSchema-instance”></ValidFromDateTime>
    <ValidTimeStateType>AsOf</ValidTimeStateType>
    <ValidToDateTime xsi:nil=”true” xmlns:xsi=”http://www.w3.org/2001/XMLSchema-instance”></ValidToDateTime>
    <CurrencyPair class=”entity” action=”update”>
      <_DocumentHash>911f6653fc2da5d3ce42d69fb95f7269</_DocumentHash>
      <RecId>22565423204</RecId>
      <RecVersion>1</RecVersion>
      <FromCurrencyCode>EUR</FromCurrencyCode>
      <ToCurrencyCode>USD</ToCurrencyCode>
      <ExchangeRateType>Average</ExchangeRateType>
      <ExchangeRateDisplayFactor>One</ExchangeRateDisplayFactor>
      <ExchangeRate class=”entity” action=”create”>
        <ExchangeRate>95.60</ExchangeRate>
        <ValidFrom>2015-02-05</ValidFrom>
      </ExchangeRate>
    </CurrencyPair>
  </LedgerExchangeRate>
</ExchangeRateServiceUpdateRequest>