We often are asked by customers to write reports from the data in
This approach provides the "best of both worlds". In SQL logic, we can easily assemble data from the "Work-Open-History" movement of records in Microsoft Dynamics GP; we can easily join Receivables back to Sales Order Processing (a challenge because the "Type" value is not the same); and we can quickly develop, debug, and test the queries and logic. Then the reporting exercise is simply formatting - grouping, sorting, and subtotaling - just organizing the results and making them look "pretty".
Another benefit of this approach is that the SQL stored procedures are generally unaffected by Microsoft Dynamics GP upgrades. Because the queries are written off specific tables and columns - unless the column or table goes away - these stored procedures do not even require recompilation following an upgrade. They really withstand the test of time.
And as different reporting tools have come onto the scene, we still use the same stored procedures developed years ago to return results. We have customers with reports that use the same stored procedure that were originally used with Crystal, but now also are called by Excel and SRS front-ends. Even the logic is simple - using a SQL stored procedure with your favorite reporting tool can make reporting on Microsoft Dynamics GP data a breeze and we can help with our
If your organization is located in the
By Sherwood Systems –