Comments (6)

  1. Anonymous says:

    I noticed that you stated that the main account does not have to be in the first segment.  I understand this in theory, but it seems that the Data Import Export Framework assumes that the Main Account is in the first position.   If you view the source data formats, there is no place to choose the correct dimension string that includes with main account is any other position but the (assumed) first.

    Thanks for your help,

    Kevin

  2. KimNelson says:

    Hi Kevin,

    This should now be corrected in the Data Import Export Framework. It was missed initially. Please let me know if that is not the case.

    Regards,

    Kim

  3. Anonymous says:

    Thanks Kim,

    Would we define the order of Account dimensions when uploading with DIEF through the source data formats?   Main Account is not an option to select in the drop-down, therefore assuming it's first.  We are AX 2012 R2 CU7.

    For example, the account string is BU-MAIN-CC-DEPT.  

    Thanks!

    Kevin  

  4. KimNelson says:

    Hi Kevin,

    The source data formats are used for default dimensions so there is no main account. Different account numbers could have different segments available based on how the account structures are defined. For the account number, you would need to specify in the format of the appropriate account structure (BU-MAIN-CC-DEPT).

    I don't know if you have seen this, but there are some sample files available on TechNet that may be of help to you: technet.microsoft.com/…/jj225591.aspx

    Let us know if you have additional questions.

    Regards,

    Kim

  5. Anonymous says:

    Kim,

    I am searching for information about the Management Reporter Fast Tab Setup in the Main Chart of Accounts.  Is there a document on this that explains how to setup the accounts for Management Reporter fast tab?

    Thanks

    Daren Phillips

    Daren.Phillips@McGladrey.com

  6. KimNelson says:

    Hi Daren,

    Here is some information from the blog posting on currency translation in Management Reporter:

    •Weighted average – used most often for profit and loss accounts, this method takes the (exchange rate * days in effect)/days in period

    •Average – an alternative method for profit and loss accounts, this method takes the total of exchange rates/# of exchange rates

    •Current – method used most often for balance sheet accounts, the exchange rate used is the rate on or before the date of the report or column in Management Reporter

    •Transaction date – method used for fixed assets accounts, the exchange rate used is the rate on the day the asset was acquired. If a rate is not entered for that date, the rate used is the previously entered rate closest to the asset acquisition date

    More information as to how it is used is in the blog posting: blogs.msdn.com/…/currency-translation-for-microsoft-dynamics-ax-2012-cu7-feature.aspx

    Let us know if you still have questions.

    Regards,

    Kim