The “Fixed Asset Statement” report in Dynamics AX is actually a roll-forward report. It’s a good report, but in my opinion it has one limitation in that there is no way to run it with asset detail. With that said, it’s very easy to setup and run and is still a valuable report.
The report is setup by defining the rows. There are 2 types of rows:
- A “Header” row which is a free text field that appears on the report.
- A “Total” row is a range of assets that will be totaled on the report with a free text description. These will be your asset groups, computers, machinery and equipment, etc.
Something to seriously consider when setting up your fixed assets is using a unique number sequence for each fixed asset group. I think most AX implantations are done this way anyway, but without it you will not be able to define your asset groups into a row. If this is not clear why this is important, it will become apparent as we setup the report.
Defining the rows
Navigate to Fixed assets> Setup> Fixed asset statement rows
- To enter a new row, click “New” and enter a description in the “Row name” column and then select the “Row type” by clicking on the drop down. Continue this process until your report rows have all been entered.
2. For the “Row types” you entered as “Total”, you will now need to define the assets to be totaled in those rows.
- Click on the row to define and click “Totals”.
- A new window will open with columns that define the “From“ and “To” range of assets. Use the drop down arrows to select the asset numbers to be included in the range. To add multiple ranges, click the “New” button. This is why a number sequence by asset group is important!
Checking the report content
Although this report cannot be run by asset, there are a couple of built-in reports that are helpful to ensure that the report rows you’ve defined are complete.
Navigate to Fixed assets> Reports> Base data> Fixed assets in fixed asset statement rows
This report will provide a listing of all assets included in the selected row of the fixed asset statement report.
- At the reports parameters screen, click the drop down menu on the “Fixed asset statement row” line and select the row to include in the report.
Here’s a sample of the “Fixed assets in fixed asset statement rows” report.
Navigate to Fixed assets> Reports> Base data> Fixed asset statement rows
This report will provide a summary listing of the rows included in the report. It will also provide a list of assets not covered in the report.
- At the reports parameters screen, click the check box “Show fixed assets not included” and then click “Ok” to run.
Here’s a sample of the “Fixed asset statement rows” report.
Run the Fixed Asset Statement
Navigate to Fixed Assets>Reports>External>Fixed asset statement
- At the parameters screen enter the fiscal period start date (must be the first day of a fiscal period) and the end date. The end date can be any date in the fiscal period i.e. the end of a quarter.
- Under the “Value models” section, you can filter for specific value model or posting layer if desired.
Here’s a sample of the “Fixed asset statement” report. (This is a landscape report so I’m going to post it in 2 screen shots.)
This post was written by Matthew Caffrey, AX Application Consultant at Tridea Partners. Tridea is a leading Microsoft Dynamics provider. www.trideapartners.com