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
DavidM 10/20/2014 5:23:04 PM

Customizing the standard Dynamics SSRS reports

Recently, a client asked us to add an additional filter field to the standard GL Trial Balance SSRS report for Dynamics GP.  

This tutorial contains the report and the custom SQL that you will need to implement this for yourself. The object is to add an additional filtering field (in our case the User Defined 1 in the Account card) to a report.

The script and report can be further altered without too much effort.
Version: GP 2010,GP 2013
Section: Dynamics GP,SQL Scripts

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