First of all, one needs to understand the building blocks of Financial statement report builder:
a. Dimension focus - list of what on type of entity you want to report, e.g. accounts, dimensions, departments...
b. Row definition - lists of entities you want to report on, e.g. list of Balance accounts
c. Date intervals definitions - are helpful rules that define what "current quarter" means to AX
d. Financial statement - The combination of the above.
So, the steps to build the simplest balance sheet in Dynamics AX would be:
1. Create a dimension focus for GL accounts:
a) Go to GL > Setup > Financial Statement > Dimension focuses
b) Create a new record and on Dimension tab add Ledger account to the Dimension focus. Save.
2. Go to GL > Setup > Financial Statement > Row definition
a) Create a new Row definition. Set field Focus to the Dimension focus you've created in step 1.
b) Click button Structure designer
c) Double-click on the ledger accounts you want to see in the report. You can also use drag and drop
3. Close the structure designer. Go to: GL > Setup > Financial Statement > Financial Statement
4. Create a new financial statement record (CTRL+N).
5. Set field Main focus = [The dimension focus you've created in step 1]
6.In the lower grid, in the Overview tab, Create the following lines for the GL account and its amount.
7. On the Setup Tab in the upper part of the form, select Row definition for main focus you've created in step 2.
8. Now lets run the report: GL > Reports > Transactions > Periodic > Financial statement
9. Select the financial statement that you've defined in step 4.
10. Click OK.
Here is how your simple balance sheet would look like:
Financial statement report builder is a flexible tool. You can further define periods, compare them one to another, make breakdowns per financial dimensions and many more exiting things.
Of course you may try to implement Management Reporter or FRx, BI 360 or AtlasXL, however this is a free and standard tool, which is robust for most application, given the proper setup.
a. Dimension focus - list of what on type of entity you want to report, e.g. accounts, dimensions, departments...
b. Row definition - lists of entities you want to report on, e.g. list of Balance accounts
c. Date intervals definitions - are helpful rules that define what "current quarter" means to AX
d. Financial statement - The combination of the above.
So, the steps to build the simplest balance sheet in Dynamics AX would be:
1. Create a dimension focus for GL accounts:
a) Go to GL > Setup > Financial Statement > Dimension focuses
b) Create a new record and on Dimension tab add Ledger account to the Dimension focus. Save.
 |
| Dimension focus in Dynamics AX |
a) Create a new Row definition. Set field Focus to the Dimension focus you've created in step 1.
b) Click button Structure designer
c) Double-click on the ledger accounts you want to see in the report. You can also use drag and drop
 |
| Row definition in Dynamics AX |
4. Create a new financial statement record (CTRL+N).
5. Set field Main focus = [The dimension focus you've created in step 1]
 |
| Creating a financial statement |
7. On the Setup Tab in the upper part of the form, select Row definition for main focus you've created in step 2.
8. Now lets run the report: GL > Reports > Transactions > Periodic > Financial statement
 |
| Selecting the financial statement defaults main focus and row definition |
10. Click OK.
Here is how your simple balance sheet would look like:
Financial statement report builder is a flexible tool. You can further define periods, compare them one to another, make breakdowns per financial dimensions and many more exiting things.
Of course you may try to implement Management Reporter or FRx, BI 360 or AtlasXL, however this is a free and standard tool, which is robust for most application, given the proper setup.
Thanks !
ReplyDelete