Skip to main content

Notifications

Microsoft Dynamics AX (Archived)

AX2012 : Two companies with multi-currency

Posted on by 15

Hi every AX Expert, :) 


In Ax 2012, We have two companies with multi-currency (2 currency TND and EUR), example Campany1 with TND currency (3numbers after comma 200,000 TND) and Company2 with EUR currency (2numbers after comma 200,00 EUR).


I need to know how to treat all transactions of my 2 companies separately. Means i need to know how to save transaction data of my Company1 with 3numbers after comma and save transaction data of Company2 with 2 numbers after comma in different Ledger and Transaction Tables in AX 2012.

We haven't any idea how to make it. Thanks in advance for your help.

*This post is locked for comments

  • Suggested answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,240 Super User 2024 Season 2 on at
    RE: AX2012 : Two companies with multi-currency

    You can use event handlers in AX 2012 which prevents the overlayering. That makes is more easy to merge with other solutions which are also having changes on this class: docs.microsoft.com/.../event-handler-nodes-in-the-aot

  • Suggested answer
    Belgacem Afif Profile Picture
    Belgacem Afif 15 on at
    RE: AX2012 : Two companies with multi-currency

    Hi,

    Thanks @André. Surly i should be careful because i use SysSetupFormRun class (system class) and i I have overide run() method.

    what do you mean about "extending this class"? i have made simple overide

    have you know a method to save our modification in system class when we make update of version to another (about AX environment )?

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,240 Super User 2024 Season 2 on at
    RE: AX2012 : Two companies with multi-currency

    Hi Belgacem,

    There is a central class in AX2012 called SysSetupFormRun. Be careful extending this class. Make sure you have a backup of the environment as wrong coding might cause failures during AX client startup.

  • Belgacem Afif Profile Picture
    Belgacem Afif 15 on at
    RE: AX2012 : Two companies with multi-currency

    Hi,

    I'm tring to resolve our need, i have find a part of solution ....

    Description of my work : We have some company with TND and only one with EUR currency,

    for that I make my update in the ETD to take three decimals after comma.

    Then i made manually modification of NoOfDecimals property of control (type REAL)

    in one form with only 2 decimals "NoOfDecimals=2". it works well.

    Then i developped some code to make all controls in one form with property "REAL type" be updated with 2 decimals after comma in EUR company.

    It works well also.

    But i don't find where exactly should i add my code to be executed in any form before open of all forms

    (to loop all controls in any form).

    Have you any idea where should i make my code exactly

    THANKS in adv

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: AX2012 : Two companies with multi-currency

    Hello Belgacem Afif,

    Have you been able to review the answers and been able to review it?

    Please let us know whether your questions got answered or some additional help is needed here.

    Many thanks and best regards,

    Ludwig

  • Suggested answer
    guk1964 Profile Picture
    guk1964 10,877 on at
    RE: AX2012 : Two companies with multi-currency

    You would need to develop some branching code logic by company, In practise most implementations I have seen have had separate instances to deal with this or both have used 3 dec places.   

    This post might be of interest to you, even though it does not address your company specific requirement; https://community.dynamics.com/365/financeandoperations/b/microsoftdynamicsaxextensions/archive/2018/03/20/number-of-decimals-in-entire-application

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,240 Super User 2024 Season 2 on at
    RE: AX2012 : Two companies with multi-currency

    Hi Belgacem,

    It is inevitable to work with three decimals if you extend the amount again to three. The rounding settings should take care of the rounding correctly. I'm not aware what type of and how transactions you need to do in the EUR company. At least external documents can be customized to have a report design for three and another one for two decimals.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: AX2012 : Two companies with multi-currency

    Hi Belgacem Afif,

    I am not a developer and can thus not tell you whether it is possible to make your adjustment for a number of companies only. I believe that this is not possible. Yet, I don't think that you are the only company operating with TND who has this problem. Have you already checked possible ISV / partner solutions that address this issue?

    Best regards,

    Ludwig

  • Belgacem Afif Profile Picture
    Belgacem Afif 15 on at
    RE: AX2012 : Two companies with multi-currency

    I cancel the modification of DataType done by our members.

    Now i have amount with 2 decimals (standart amount) and i have a company with TND currency witch i need to implement this TND currency with (3 decimals) for all amount of this campany.

  • Belgacem Afif Profile Picture
    Belgacem Afif 15 on at
    RE: AX2012 : Two companies with multi-currency

    @Ludwig : I have many company with TND currency and i want just one Company with EUR currency for that i make a modification in EDT with 3 decimal

    @André : yes i made rounding settings yet.

    EuroSetting.png

    André yes i know we always see 3 decimals in amount columns. If you have an idea, i can even cancel the system modification of EDT made recently because we are in phase of preparing of our environment.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,240 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans