Microsoft Dynamics 365 Blog

Preparing Financial Statements with financial dimensions getting printed in different Columns in the report in Microsoft Dynamics AX 2012

Written by

Sandeep Chaudhury

in

,

Sometimes companies may want to generate their financial statements with one or more of their financial dimensions getting printed in different columns of the financial statement report for comparison and review purpose. For example, a company may want to generate the income statement with the data for each of its “Business Units” getting printed in separate columns in the report.

Take a look at the dummy screenshot of such a report below.

Sample Income Statement

Here are the quick guide lines how to achieve this in Microsoft Dynamics AX.

1. First of all, configure the financial statement by navigating to General Ledger > Setup > Financial Statement > Financial statement.

2. Define the financial statement column structure as shown in sample screen below.

Financial Statement Column Structure

3. Now assuming that your row definition for the financial statement is ready, let us go and generate the financial statement.

4. Navigate to General Ledger > Reports > Transactions > Financial Statement. Key in the values for financial statement, Row definition(If not already defaulted from financial statement) and click the Columns tab.

Generate Financial Statement

5. You will notice the 3 columns(Current) which we configured in the financial statement.

6. Select the first record and click Select button.

Select Business units/Financial dimensions during report generation

7. Click Add button and select the business unit financial dimension in the “Field” and provide the criteria value(For example BU-001)

Select the financial dimensions

8. Repeat steps 6 and 7 to complete this for business unit 2 and 3.

9. Click Ok button and we are done. This will print the financial statement as depicted in the sample screenshot above in this post.

Companies may also have different financial dimensions like Territory/Region, Product Line etc. They may also report based on these financial dimensions with having these printed in separate columns in the report.

Complex Reporting !!! Made Powerfully simple. Smile

Microsoft Dynamics AX 2012 - Powerfully Simple

Comments

6 responses to “Preparing Financial Statements with financial dimensions getting printed in different Columns in the report in Microsoft Dynamics AX 2012”

  1. Sunny Avatar
    Sunny

    hello sandeep, i followed up your suggestion to print the dimensions on the statement, it doesn’t print but zero. i have three dimensions. I chose main-account set. My accounting structure for P&L is with BU and department. I want to see the Business Unit code or name printed.

    Reply
  2. Marc Avatar
    Marc

    Hi Sandeep,

    Thanks for the information. Is there any way to save the configuration (i.e. query for each Business Unit) so I don’t have to re-enter the queries everytime I want to run the report?

    Reply
    1. Sandeep Chaudhury Avatar
      Sandeep Chaudhury

      Hi Marc,

      You could save the queries for each business units. But you have to select the query for each business unit every time. This is little inefficient.

      I would recommend to have your developer to write a small custom code to save the whole query.

      Regards
      Sandeep

      Reply
  3. Sunny Avatar
    Sunny

    Hello Sandeep, this is good post. If we were to take an Income statement with columns BU, Customer and product line, i assume that we don’t need to create dimension-set for these. In stead, I can add them into the column. Is that right? Assuming my account structure has BU+Department dimensions? or could I not create a dimensionset and refer to that ‘as primary dimension set or secondary dimensionset?

    Reply
    1. Sandeep Chaudhury Avatar
      Sandeep Chaudhury

      Sunny,

      Having BU and product line in the columns will make sense. But i cannot think the customer to be presented in columns as the number of customers will be large always.

      Not sure if i misunderstood your question.

      Thanks
      Sandeep

      Reply
  4. kiran Avatar
    kiran

    Hi Sandeep,
    AX2009
    i am doing onaccount forecasting in ax2009 and generating my project stament .When i select acutal VS Budget = budget ,The revenue column is not showing it showing zero. could you pls let me know the problem. i have forecasted account with xxxx value. forecsted hours and expense are shoiwng .

    i guess for onaccount they wont be any costprice ,so that i may not showing.

    Reply

Leave a comment

More posts