Search the GP Tables
Search by TABLE NAME
Search by FIELD NAME
These are our SOP scripts. All of our scripts for Dynamics GP can be found here

Table Edits Forum Articles
Table Edits 0 Table Edits 0 Table Edits 0
Sign Up Now!Log In
Isaac 11/20/2014 12:46:30 PM

SSRS - Sales by item report

 Recently a customer asked us to build a report to give them visibility to their item sales. The report needed to have quantity, cost, extended price and Gross Margin.

This article contains the SSRS .rdl file and the stored procedure to power it. The finished report looks like this.
Version: All
Section: Dynamics GP,Report Writer,SQL Scripts,.NET Development,Crystal Reports

Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables