In this video, we present a custom report created in SQL Server Reporting Services (SSRS), but also possible to use in Crystal Reports or Power BI.

What does this SQL Server Reporting Services Report Do?

This custom SSRS report lists items that are needed for current open sales orders in Dynamics GP. It also shows a running total of the projected available quantity for each item, based on the requested ship date or the promise date for PO’s. Finally, the report will highlight items with quantity available of 0 or less.

If this SSRS report would be useful in your business, or if you would like assistance in report design, creating other custom reports in SSRS, Crystal Reports, or Power BI, or custom code and applications, please contact the report designer experts at CSSI. CSSI can also assist you with custom programming services, developing unique high-value applications for your business.