Exchange rate update add-on

Problem:
 
I was asked to create exchange rate add-on, It will update the exchange rate from online

• This update add-on should have the ability to work automatically (without human intervention)
• Given option to manual update also
• Average update and Closing rate update for consolidation companies.

Solved: 

There is no inbuilt functionality for exchange rate updating in dynamics AX 2009. Following are the screenshots and functionality of the add-on that I created,

• Configurable in batch job so that it automatically updates the exchange rate in exchange rate table. 
• Based on the batch job, it will update the value in exchange rate table.
• Notifications, errors and warnings will be updated in the log and shown to peoples.
• Manual update option would be given to end user
• Staging table : Its the mediator between actual exchange rate table and downloaded data from internet. It also can be viewable from the content pane 

 

If anybody need this add-on contact me on (mdashraf@live.in, india - 919043440941)
It is two hour development cost only

Following are the advantage of deploying this add-on to your company

• It is automatic and highly customizable by end user
• Easy deployment package
• Enhancement can be made according to the customer (within the cost of this add-on)
• support will be provided at free of cost
• I am a freelancer so interested customer can contact me for apart from this development also

ERD (Entity relationship diagrams) for dynamics ax tables

     Yesterday I read the news from Microsoft dynamics ax community forum that Microsoft has published ER diagrams for some dynamics ax tables. so I just want to share with you guys. It includes 30 database ERDs for tables in dynamics ax. Its very helpful for developer like us to finding the relations between tables when we are trying to customize. here I given the link go and enjoy

ERDs-  http://go.microsoft.com/fwlink/p/?linkid=296623

Microsoft dynamics ax interview questions part 3 - Senior technical consultant

         
           Before I am joining Wipro InfoTech I had attend lot of interviews and I got offer from some finest companies. I feel proud to join in Wipro. so here I am going to post my third series of dynamics questions but its senior level. get on
 

• Name the two dynamics framework newly added on Ax 2012
• Explain ledger framework in AX 2012
• In AX 2012 journal postings are running on IL code. So how do you debug the posting
• What are all the steps in Dynamics ax 2012 upgradation. in which level you worked extensively explain it.
• Name the two newly added best practices in Dynamics ax 2012 on all the AOT objects
• Explain the table inheritance in AX 2012 with examples
• Consider the situation that huge number of invoices happening on the particular company. so Client wants you to modify something on the invoice place. so what are all the steps would you take to prevent fall of performance in the system
• Have you worked on SSRS.
• When user wants to open the SSRS report I want some user input for the report. What are all the steps to get user input. (here I explained about the controller classes and dialogs to get user inputs)
• Ok I need a lookup in that SSRS dialog field. how do you achieve it. what are all the classes you use.
• Explain the types of way to get Data sources in SSRS report
• Explain the data methods in SSRS report. what is the purpose when did you use it
• Explain post handler and pre handler in AX 2012
• how do you get the exchange rate for transaction currency (here I explained about exchangeratehelper class)
• Explain trade agreements and their use
• Explain model and model store
• say some scripts you used at the time of data migration
• How do you migrate the changes from Development to UAT
• What is inbound and outbound
• Explain the steps for creating services in dynamics ax
• Explain the real time steps for development (Interviewer asking about the series of real-time development lifecycle in dynamics ax. This actually a tricky question here you have to explain the document preparation and step by step development process from Requirment to TDD)

 
 
 

Customer/Vendor Address import in dynamics AX 2012 through X++

15-07-13

Customer and Address import in Dynamics AX 2012 using X++

Problem: I was assigned to a task that import customer and their addresses from Excel sheet. I can import customer through code by using AXCustTable service class but what about addresses. In AX 2012 addresses changed a lot they created new framework for addresses.

Solved: I had gone through lot of websites for customer address import. Every code was almost identical. I am happy with all the codes but one thing the code doesn’t solve it. They all work until you have to fill all the address masters before create new address for customer. In my case I have to create new address not selecting the address for my customer. So I had gone through address framework and created the code for creating addresses as well as customers. So I had liked to share with you.  (But here I covered only the address part electronic address included)

 

Main method creating for address:

    DirPartyRecId                                                partyRecId;

    DirPartyPostalAddressView                          addressView;

    AxLogisticsAddressCountryRegion              axCountryRegion;

    AxLogisticsAddressCounty                           axCounty;

    AxLogisticsAddressState                               axState;

    AxLogisticsAddressZipCode                         axZipcode;

    AxLogisticsAddresssCity                               axCity;

    DirParty                                                          DirParty;

    DirPartyContactInfoView                              contactView;

    LogisticsLocationRecId                                 locationRecid;

    ;

    try

    {

            addressView.CountryRegionId = _CountryRegionId;

            addressView.State   = _state;

            addressView.City    = _city  ;

            addressView.ZipCode = _zipCode;

            addressView.Street  = _street;

            addressView.Party   = _custTable.Party;

            //addressView.Location    =   locationRecid;

                //Separate method find it in below code

            this.processAddress(addressView,_custTable);

            DirParty = DirParty::constructFromPartyRecId(addressView.Party);

                //Creating new address using dir party class

            if( addressView.Street || addressView.ZipCode || addressView.City || addressView.State ||                       addressView.CountryRegionId)

            {

                DirParty.createOrUpdatePostalAddress(addressView,_roleId);

            }

                //Electronic address creaiton

            if(_AccountManagerEmail!='')

            {

                contactView.LocationName = "Delivery email";

                contactView.Locator      = _AccountManagerEmail;

                contactView.Type         = LogisticsElectronicAddressMethodType::Email;

                contactView.Party        = _custTable.Party;

                contactView.IsPrimary    = NoYes::Yes;

                DirParty = DirParty::constructFromPartyRecId(contactView.Party);

                dirParty.createOrUpdateContactInfo(contactView);

            }

            if(_phone!='')

            {

                contactView.LocationName = "Phone";

                contactView.Locator      = _phone;

                contactView.Type         = LogisticsElectronicAddressMethodType::Phone;

                contactView.Party        = _custTable.Party;

                contactView.IsPrimary    = NoYes::Yes;

                dirParty.createOrUpdateContactInfo(contactView);

            }

            if(_teleFax!='')

            {

                contactView.LocationName = "Tele Fax";

                contactView.Locator      = _teleFax;

                contactView.Type         = LogisticsElectronicAddressMethodType::Telex;

                contactView.Party        = _custTable.Party;

                contactView.IsPrimary    = NoYes::Yes;

                dirParty.createOrUpdateContactInfo(contactView);

            }

            if(_url!='')

            {

                contactView.LocationName = "URL";

                contactView.Locator      = _url;

                contactView.Type         = LogisticsElectronicAddressMethodType::URL;

                contactView.Party        = _custTable.Party;

                contactView.IsPrimary    = NoYes::Yes;

                dirParty.createOrUpdateContactInfo(contactView);

            }

    }

    catch (Exception::Error)

    {

        info ("Customers not created");

    }

 

  Process address method:

    AxLogisticsAddressCountryRegion axCountryRegion;

    AxLogisticsAddressCounty        axCounty;

    AxLogisticsAddressState         axState;

    AxLogisticsAddressZipCode       axZipcode;

    AxLogisticsAddresssCity         axCity;

    LogisticsAddresssCity            addressCity; 

    ; 

    if(addressView.CountryRegionId  &&  !LogisticsAddressCountryRegion::exist       (addressView.CountryRegionId))

    {

        axCountryRegion =   new AxLogisticsAddressCountryRegion();

        axCountryRegion.parmCountryRegionId(addressView.CountryRegionId);

        axCountryRegion.parmCurrencyCode(_custTable.Currency);

        axCountryRegion.parmAddrFormat("0014");

        axCountryRegion.save();

    }

    if (addressView.State && !LogisticsAddressState::exist(addressView.CountryRegionId, addressView.State))

    {

        axState =   new AxLogisticsAddressState();

        axState.parmCountryRegionId(addressview.CountryRegionId);

        axState.parmStateId(addressView.State);

        axState.parmName(addressView.State);

        axstate.save();

    }

    if (addressView.County && !LogisticsAddressCounty::exist(addressView.CountryRegionId, addressView.State, addressView.County))

    {

        axCounty    =   new AxLogisticsAddressCounty();

        axCounty.parmCountryRegionId(addressview.CountryRegionId);

        axCounty.parmStateId(addressview.State);

        axCounty.parmCountyId(addressView.County);

        axCounty.parmName(addressview.County);

        axCounty.save();

    }

    if(AddressView.City &&  !Logisticsaddressscity::exist(Logisticsaddressscity::find(addressView.city).RecId))

    {

        /*axcity  =   new AxLogisticsAddresssCity();

        axCity.parmCountryRegionId(addressview.CountryRegionId);

        axCity.parmCountyId(addressview.County);

        axCity.parmName(addressView.City);

        axCity.parmStateId(addressview.State);

        axCity.save();*/

        addressCity.CountryRegionId =   addressView.CountryRegionId;

        addressCity.Name    =   addressView.City;

        addressCity.StateId =   addressView.State;

        addressCity.doInsert();

    }

    if (addressView.ZipCode &&  !LogisticsAddressZipCode::exist(addressView.ZipCode))

    {

        axZipcode   =   new AxLogisticsAddressZipCode();

        axZipcode.parmCity(addressview.City);

        axZipcode.parmCityRecId(Logisticsaddressscity::find(addressView.city).RecId);

        axZipcode.parmCountryRegionId(addressview.CountryRegionId);

        axZipcode.parmCounty(addressView.County);

        axZipcode.parmState(addressView.State);

        axZipcode.parmStreetName(addressView.Street);

        axZipcode.parmZipCode(addressView.ZipCode);

        axZipcode.save();

    }