Microsoft Dynamics 365 Blog

Category: Information

  • SBS Group, USA Expands with Solugenix’s Dynamics AX Practice

    SBS Group, USA Expands with Solugenix’s Dynamics AX Practice

    SBS Group, a leading technology consulting firm integrating business management solutions, announced today the acquisition of Solugenix’s Microsoft Dynamics® AX Practice.

    SBS Group USA, is focused on business management solution and is one of the Microsoft master VARs and also a member of Microsoft’s inner circle. It will be an unbeatable combination of SBS group’s vast experience in dynamics line of products, their long term relationship with MS and Solugenix’s exceptionally experienced Dynamics AX team.

    SBS

    Looking forward to work with SBS Group.

    Click here to Learn more.

  • Aston Martin selects Micrososft Dynamics AX 2012

    Aston Martin selects Micrososft Dynamics AX 2012

    Aston Martin, the renowned automaker, switches gears with Microsoft Dynamics AX 2012.

    Another success story with Microsoft Dynamics AX.

    The flexible and seamless integration of all ledgers including General, purchase, fixed assets and sales, made Aston Martin’s operations and information flow more easily and efficiently than before.

    Read the success story in the link below.

    http://www.microsoft.com/en-us/news/press/2012/jun12/06-19AstonMartinPR.aspx

    Way to go !

    Thanks

    Sandeep

  • Statement currency conversion and consolidation in microsoft dynamics AX

    Hi Friends,

    Hope all is well your way. It’s been almost a month i could not write here as i went busy with work. Now here is one which i recently worked on for a customer.

    In the subsequent paragraphs i will explain how to perform the currency conversion for a subsidiary company operating on a foreign currency and also we will explore how to perform consolidation of this company with the parent company transactions.

    Scenario: let us assume that the subsidiary company is SUB which operates in GBP (Britain Pounds) currency and the parent company PAR reports in USD(US Dollar) currency. We will perform currency conversion followed by consolidation for the subsidiary company.

    The first task we have for this requirement is to perform the currency conversion for SUB company so that we can perform the consolidation then.

    Steps for the currency conversion:

    1. Navigate to Administration > Company accounts form and create a new company account and name it as CUR , Consolidation I – Currency conversion.
    2. Select the company account.
    3. Navigate to GL > Setup > Exchange rates form.
    4. Create a new currency called USD(main currency of parent company) and give 100.00 as exchange rate for this with a blank date.
    5. Navigate to GL > Setup > Parameters form and Mark the Consolidated company account check box.
    6. Come back to the Exchange rates form and create the currency of the subsidiary company which is GBP is this case.
    7. In the exchange rates grid below , setup all the historical exchange rates.
    8. Click on the consolidate tab and setup the closing and average rate.
    9. Navigate to Basic > Setup > Company information and give suitable company information and setup the primary currency as USD under the Other tab.
    10. Create the chart of accounts in the consolidated company. For the currency conversion task , you may prefer to choose identical COA as of the subsidiary company and then set the consolidation conversion principle for each of the accounts. Select between Historical, Average and Closing.
    11. Select the Subsidiary company and go to chart of accounts form. For each of the accounts, setup the mapping for the chart of accounts for the consolidation company CUR.
    12. Now , navigate back to the CUR company and go to GL > Periodic > Consolidation > Consolidation Online.
    13. Select an account range if needed if not leave it blank, select the period for which you want to convert the transactions into USD, Mark the Consolidation account, Current check box.
    14. Click the Companies tab and Select SUB from the look-up. Give Share = 100 %.
    15. Click Ok button.
    16. This will convert all the transactions into USD and you can enquire the same at Inquiries > Consolidation.

    Note : The setup for historical, average and closing rates are required as usually Income statement accounts will be converted on month average, balance sheet (non-equity) accounts on month closing and balance sheet (equity) accounts will be converted on historical rates under the US GAAP.

    Steps for the Actual consolidation:

    1. Create a new company account called CON.
    2. Do the similar setup as done above. Note that the GBP setup is not needed here as we will just consolidate the transactions.
    3. Do the COA setup for this and map these accounts both is PAR and CUR companies by specifying these in the Consolidation account field.
    4. Run consolidation from Periodic > Consolidation Online and specify both companies PAR and CUR under companies tab.
    5. Go to consolidation inquiries and verify that the transactions are consolidated.

    Assumption:

    The scenario described above is just one of the cases for consolidation when the subsidiary company is in a foreign currency. The COA setup, exchange rate setup and account mapping will differ from customer to customer. The best decision is to be taken as per that.

    Questions on this are most welcome.

    Thanks, keep DAXING. :)