Is There a Report That Will Project Depreciation Expense by Line Item or by GL Account Number

TechKnowledge Content

Issue

Is there a report that will project Depreciation Expense by Line Item or by GL Account Number?

Resolution

Modify the FA Period Projection - Detail report (Report | Fixed Assets | Projections). This will add the Depreciation Expense Account Number to this report.

1. Go to Report Writer and select the FA Period Projection - Detail report and open the Report Definition Window.

2. Click on the Tables button to open the Report Table Relationships Window.

3. Select Asset General Information Master and click New.

4. Link the Depreciation Expense Account to it by highlighting it and clicking OK.

5. Back in the Report Table Relationships Window, click on the Depreciation Expense Account and click New.

6. Link the Account Master to it.

7. Click OK back to the Report Definition Window.

8. Click on Layout to open the report layout.

9. In the Toolbox, choose the Account Master as your table.

10. Drag the Account Number field onto the body of your report.

11. Go back to Dynamics and grant the users security to the report (Setup | System | Security).

This article was TechKnowledge Document ID: 29765

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×