Dynamics Financial Reporting

All about financial reporting and consolidations for Microsoft Dynamics ERPs

Acquisition date attribute for Dynamics AX 2012 (CU7 feature)

Acquisition date attribute for Dynamics AX 2012 (CU7 feature)

  • Comments 9

Management Reporter CU7 introduced currency translation for Dynamics AX 2012 customers. Along with this feature we added the ability to see the attribute date associated with each transaction so you can track what date the exchange rate uses for translation. View this video to learn more about acquisition date.

Leave a Comment
  • Please add 8 and 2 and type the answer here:
  • Post
  • Hi April,

    Thank you for the post .

    I have one more question about the consolidation of Fixed Asset accounts , hope fully you can answer me.

    I have 3 companies   - USA , AU, FR , parent company is USD.

    When it comes to Consolidation process we need to consider the different exchange rates for the Balance sheet , P&L and Fixed Asset accounts.

    Closing rate for Balance sheet accounts.

    Avearage rare for Profit & loss accounts.

    Transaction date for Fixed Asset accounts.

    During consolidation process in the Management Reporter , we will define the main account codes then  system would consider the General ledger entries only for consolidation . It does not consider the subledger entries of Customer , Vendor and Fixed Asset.

    I have a doubt about the Transaction date for the Fixed Assets. Fixed Assets has the two dates  Actual Acquistion date and Transaction date ( Opening balance date in Ax )

    Assume that client is going on Go-live  04/01/2014 , So generally we will upload the opening balances of G/L(main account)  , Sub ledger( Customer , vendor , bank , Item , FA ) on 03/31/2014.

    But the question is on which date i need to upload the FA opening balances because some assets had purchased in 2010, 2011 , 2012 also.

    Exchange Rate  - 5/15/2010   - 1USD - 1.25 AUD.

    Fixed Asset purchased on  5/15/2010 - 8000 AUD (Company Currency)

    Fixed Asset value was on 5/15/2010 -  6400 USD (Reporting currency)

    If i upload the FA opening balances on 3/31/2014 , then during consolidation system would take the exchange rate on 3/31/2014, but actual asset acquistion date ( transaction date ) was  on 5/15 /2010.

    Exchange Rate   - 3/31/2014   1 USD   - 1.75 AUD.

    Assume that i uploaded the FA opening balances on 3/31/2014 , but General ledger level ( Voucher entries )  there is no field to update the Actual asset acquistion date .

    If i upload the FA opening balances of Acquistion amount and Accumulate depreciation amount  on 3/31/2014 , during consolidation system would take the exchange rate of 3/31/2014 ,  then After consoidation system would show the wrong amount , but it suppose to take exchange rate on 5/15/2010.

    So my question is do I need to upload the FA entries based on Actual Asset acquisition date (05/15 /2010) or prior to Go-Live date ( 3/31/2014). ?

    How to overcome this problem?

    Thanks in advance

    Lally

  • Lally,

    If a transaction with a historical method has an acquisition date populated, then that is the date we use to get the rate. So I would upload your assets with the field populated appropriately and then we will use that date to get the exchange rate regardless of what the transaction date is. If there is no acquisition date populated, then we use the transaction date.

  • Thank you for the reply April,

    You mentioned that " So I would upload your assets with the field populated appropriately and then we will use that date to get the exchange rate regardless of what the transaction date is "

    I did not understand above sentence clearly.

    What is that field populated ?

    On which date you suggest me to upload the assets ?

    In MR report how to get those rates ?

    If possible could you blog my scenario , which would helpful to me and others also ?

    Thank you for understanding.

  • I got struck in this process , Could any one please help me to over come the above mentioned problem.

  • Thank you for the reply April,

    You mentioned that " So I would upload your assets with the field populated appropriately and then we will use that date to get the exchange rate regardless of what the transaction date is "

    I did not understand above sentence clearly.

    Could you explain in detail ?

    Thanks in advance

  • Hello Lally,

    There is actually an acquisition date in the General Ledger tables now titled HistoricalExchangeRateDate. Its on the GeneralJournalAccountEntry table. In your example, the transaction date would be 3/31/2014, but you would populate the HistoricalExchangeRateDate field with the acquisition date, in your example, 5/15/2010. When the translation happens on an account with a Historical translation method, Management Reporter first looks to the HistoricalExchangeRateDate field for the date, and if it doesn't exist then it looks to the transaction date. So, if you are on a AX 2012 Cu7 then you will have this field and this should resolve your issue.

  • Thank you for the reply April ,

    You suggested that acquisition date need to be updated in the HistoricalExchangeRateDate field. But the field is availble in the GeneralJournalAccountEntry table , so how could i update data in that field from a end user point of view ?

    Generally when we post any financial journals then the data will be updated in then GeneralJournalAccountEntry table.

    So what I am thinking is during creation of the Fixed asset opening balances in the general journal , i need to enter the HistoricalExchangeRateDate also , but i did not find that field in the any financial journals.

    So my question how to update that HistoricalExchangeRateDate in the GeneralJournalAccount entry table ?

    Please guide me.

    Thanks in advance for the support.

  • Thank you for the reply April ,

    You suggested that acquisition date need to be updated in the HistoricalExchangeRateDate field. But the field is availble in the GeneralJournalAccountEntry table , so how could i update data in that field from a end user point of view ?

    Generally when we post any financial journals then the data will be updated in then GeneralJournalAccountEntry table.

    So what I am thinking is during creation of the Fixed asset opening balances in the general journal , i need to enter the HistoricalExchangeRateDate also , but i did not find that field in the any financial journals.

    So my question how to update that HistoricalExchangeRateDate in the GeneralJournalAccount entry table ?

    Being Microsoft Employee , You can guide me the best way .

    Please help me.

    Thanks in advance for the support.

  • Lally,

    The field is updated with the acquisition date from Fixed Assets when the asset is entered and the field is populated. For additional help and stepping through it would be best to contact Support so they can step through the process from a Fixed Assets perspective and options from a GL perspective if you are not using Fixed Assets.

Page 1 of 1 (9 items)