Скачать или смотреть Dynamics 365 Enterprise AX Fixed Assets Value by Location Power BI report

We use pure SQL query, no content packs. Our select statement should fit to standard reporting tools, such as SSRS, Excel, Crystal or you name it. For simplicity we used Power BI Desktop
Report has summary page with Pie and Table visualizations, however it is simple enough to create additional detail pages, where you could show depreciation transactions by asset and book with drill through from/to summary page
Here we assume that each asset has Location specified. In Contoso group of companies some assets do not have it set, and we disregard these assets. Also we restrict it to USD meaning that multicurrency is disregarded as well
At the end of this video we provide you guidelines and sample scripts to handle currency conversion
Narrator Andrew Karasev [email protected] 331-330-6879