DavidM
4Penny.net
Points: 7450

11/12/2014 1:33:45 PM

Adding custom filtering to the Dynamics Financial report "Trial Balance Summary"

Recently, a client asked us to add an additional filter field to the standard GL Trial Balance Summary 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.

4Penny.net
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
3