Is There a Report That Will Project Depreciation Expense by Line Item or by GL Account Number Content provided by Microsoft Applies to: Fixed Assets Select Product Version All Products 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 Last Updated: Feb 28, 2017 Was this information helpful? Yes No Tell us what we can do to improve the article Submit Thanks! Your feedback will help us improve the support experience.