(IND) Depreciation schedule (report)
Important
This content is archived and is not being updated. For the latest documentation, see Microsoft Dynamics 365 product documentation. For the latest release plans, see Dynamics 365 and Microsoft Power Platform release plans.
Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2
Generate a report that displays the depreciation schedule for fixed asset groups.
The generated report shows values under gross block, depreciation, and net block for tangible and intangible assets, including the following values.
Gross block value |
Depreciation/amortization value |
Net block value |
|---|---|---|
Opening balance |
Opening balance |
Net block value for the current year |
Additions and adjustments made during the year |
Deductions and adjustments made during the year |
Net block value for the previous year |
Deductions and adjustment made during the year |
Year-end total |
|
Reversals or impairments made during the year |
||
Year-end total |
How to filter the data on this report
When you generate this report, the following default parameters are displayed. You can use these parameters to filter the data that will be displayed on the report. For more information, see Filter the data on a report.
Field |
Description |
|---|---|
Closing date prior year |
Select the closing date of the previous year. |
Closing date this year |
Select the closing date of the current year. |
From |
Select the starting value for fixed asset group inclusion on the report. |
To |
Select the end point for fixed asset group inclusion on the report. |
Book type |
Select the book type of the fixed asset groups. |
Posting layers |
Select the posting layer of the value model. This field is available only if you selected Value model in the Book type field. |
Depreciation book |
Select the depreciation book. This field is available only if you selected Depreciation book in the Book type field. |
Schedule number |
Enter the depreciation schedule number. |
Header note |
Enter any text that you want to appear in the header of the report. |
Footer note |
Enter any text that you want to appear in the footer of the report. |
How to work with reports
The following topics explain how to print a report and how to filter and sort the data on a report.
Details of this report
The following table explains where to find the report in the Application Object Tree (AOT) and how to navigate to the report in the Microsoft Dynamics AX client.
Detail |
Description |
|---|---|
Name of report in the AOT |
AssetDepreciationSchedule_IN |
Location of report in the AOT |
SSRS Reports\Reports\AssetDepreciationSchedule_IN |
Menu item of the report |
AssetDepreciationSchedule_IN |
Navigation to the report |
Click Fixed assets > Reports > Transactions > Periodic > Depreciation schedule. |
Where the data in this report comes from
The data on this report comes from the following sources:
TmpAssetTable_IN
TmpDepreciationSchedule_IN
TmpItemGroup_IN
If you are a developer, you can learn more about where the data on a report comes from by using the following procedure.
Open the AOT.
Locate the report in the SSRS Reports\Reports node.
Right-click the report and click Add-Ins > Cross-reference > Using (instant view).