Using Financial Dimensions in Financial Report Designer

By - January 31, 2017

As we go into 2017, I’m sure everyone is still getting comfortable with the new name, Financial Report Designer. In this blog, we will explore using financial dimensions from the General ledger module in reports created in Financial Report Designer.

Financial Dimensions

In this blog we will look at two ways to utilize financial dimensions in Financial Report Designer. Both methods use the financial dimension, MainAccount, however they differ in how MainAccount is displayed on reports. The first approach displays all MainAccounts for cash on separate rows of the report, while the second introduces dimension value sets to display a total of all the accounts on just one row of the report.

Method 1 – Single Financial Dimension

In this example we will work with the Financial dimension MainAccount.

  1. To insert the single financial dimension MainAccount for all cash accounts in a new row definition, we need to follow these steps.
  2. Open General ledger > Inquiries and reports > Financial reports.
  3. Choose New from the action
  4. Log on to Financial Report Designer.
  5. Create a new Row
  6. In the Edit menu, choose Insert Rows from Dimensions….

fd1

  1. Enter the MainAccount Dimension Range Start and Dimension Range End (See the Chart of Accounts below.)

 fd22

fd222

fd2

  1. Click MainAccount dimension from 110110 to 119998 will insert into the new Row definition.

fd3

Method 2 – Dimension Value Sets

Now let’s look at a method of reporting all the cash accounts as a single total. Instead of displaying each cash account with the balance, we will display a total for the combined cash accounts. We can achieve this by creating a Dimension Value Set for the cash accounts.

  1. On the Edit menu, choose Manage Dimension Value
  2. Choose MainAccount from the drop-down in
  3. Click

fd4

  1. In the Name field, type
  2. In the Description field, type Cash
  3. From, double-click and choose the first Cash account
  4. In the To field, type

Note: By entering a number 1 < the Totaling account number, you will ensure that any new cash accounts added to the Chart of Accounts between 110110 and 119999, will be included in the Total for Cash. This means less maintenance on reports.)

 fd5

  1. Click OK and close the
  2. Create a new row
  3. On Row Code 100, type in Cash Accounts.
  4. Double-click in Column
  5. On the Dimensions form, in the drop-down list, choose
  6. Double-click

 fd6

  1. Click the Dimension Value Set b
  2. Click the ellipsis beside the Name field.

 fd7

  1. Choose
  2. Click

 fd8

fd9

  1. Click OK to close the last two
  2. The Dimensions form will look like the screenshot

 

  1. Click OK. The Dimension Value Set will display in the new row

fd11

fd1

Now that you have seen two ways to use Financial Dimensions in Financial Report Designer, I hope you are thinking about how this robust reporting tool can meet and simplify your reporting needs. To learn more about Financial Report Designer or any of the other Dynamics 365 for Operations modules, check it out at RSM Technology Academy or subscribe to our Microsoft Dynamics Community News publication.

by Bo Powe for RSM

Receive Posts by Email

Subscribe and receive notifications of new posts by email.