Financial statement example: Budget statement

The objective of this article is to describe the setup of a budget report by using the financial statement functionality in DynamicsAX 2012.

1/ Report

Example of report

FinancialStatementGL025

2/ Step 1: Dimension sets

Access: GL > Setup > Financial Dimensions > Financials Dimensions sets

  • First dimension set with the budget dimension

FinancialStatementGL026

  • Second dimension set with the main account

FinancialStatementGL027

3/ Step 2: Row definition

Access: GL > Setup > Financial statement > Row definition

  • First row definition for the budget organization:
    • Two lines with the type “Group” to create a title and a subtotal
    • One line with the type “Dimension” for each budget dimension

FinancialStatementGL028

  • Second row definition for the main account organization:
    • Selection of charge account to be display in the statement.
    • Values are created with the type “dimension”.

FinancialStatementGL029

4/ Step 3: Column definition

Access: GL > Setup > Financial statement > Financial statement

  • Statement “BUD_Detail”
  • Select one primary dimension set : budget dimension
  • Select one second primary dimension set : main account

FinancialStatementGL030

  • Detail of “Current period” column. (date interval code are created in GL > Setup > Periods > Interval date)

FinancialStatementGL031

  • Details of “Diff” column

FinancialStatementGL032

5/ Step 4: Link all the elements

Access: GL > Setup > Financial statement > Financial statement

  • Select row definition for primary dimension set
  • Select row definition for secondary dimension set

FinancialStatementGL033

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s