Dynamics NAV SSRS Reporting from Western Computer

Generate your standard and custom key reports faster

Some reports that come standard with Microsoft Dynamics NAV may take from half an hour to several hours to generate. For example, one customer reported that it took over 12 hours to create the standard Inventory Valuation report. By using Dynamics NAV SSRS Reporting, the wait time can be reduced to less than 5 minutes!

The Dynamics NAV SSRS Reporting solution from Western Computer is an add-on that creates high-performance replacement reports for several of NAV’s poorest performing reports. By leveraging the power of SQL Server and SQL Server Reporting Services, it makes use of optimized and tuned Stored Procedures for calculating and retrieving data. As a result, reports are produced in just a few minutes, often avoiding Out-Of-Memory Exception.

SSRS reports currently available with the add-on

Financial Management / Inventory

Inventory Valuation SSRS (Inventory Valuation)

Inv. Valuation by Location (N/A)

Inventory Reconciliation SSRS (Inventory to G/L Reconcile)

Inv. Reconciliation Location SSRS (N/A)

Financial Management / Receivables

Aged Accounts Receivable SSRS (Aged Accounts Receivable)

Customer – Detail Trial Balance SSRS (Customer – Detail Trial Balance)

Customer/Item Statistics SSRS (Customer/Item Statistics)

Customer/Item Stat by Salesperson SSRS (Customer/Item Stat. by Salesperson) 

System Requirements

Dynamics NAV 2009 R2 or higher, utilizing the Role-Tailored Client

SQL Server 2008 or higher

Reporting Services 2008 or higher

Available Custom Range NAV Objects: Tables (3) Pages (16) Codeunits (1) XMLports (7 – 6 are optional)

Customizing your reports

All of these reports are customizable. Additional high-performance reports can also be created to meet your specific needs.

Security

This solution makes use of NAV’s Role-based Security Model and extends that security to the SSRS Reports. 
 

Report Generation

The SSRS Reports are generated and rendered by Reporting Services and the Report Manager, and are displayed inside your default Web Browser. 

Would you like to schedule a demo? 

Contact us by clicking here or calling 805-581-5020. 

About the Author

As Director of Marketing at Western Computer, Amanda Sherry brings a wealth of knowledge from her nine-year tenure in the Microsoft Dynamics space. A seasoned professional who has worked extensively on the partner side, Amanda offers insights into Microsoft Dynamics applications' transformative impact on businesses.

More Content by Amanda Sherry