Points: 7400

7/18/2014 1:20:57 PM

Historical Aged Trial Balance script

* This article, and all our great SQL (Dynamics) documentation, Is available on the SQL (Dynamics) menu

Earlier I wrote about using the native script for the RM Historical Aged Trial Balance report. This is  an example of using that script in a report.

 Because we're using a stored procedure from Dynamics GP, we have to use a 'Select Into' approach to get the stored procedure fields into a table. I created all the fields in the temp table as VARCHAR(100) except for the fields that I needed, those I typed correctly. There are 87 fields and time was a concern. The job of correctly typing those fields is left to you <smiles>

The resulting stored procedure produces this output. It is summed by customer:
Version: GP 2010,GP 2013
Section: 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