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
Ranger 10/25/2017 5:48:53 PM

opinion needed - view to help with queries

hi all,

so I have been diving into some of these stored procs and reports.  the thing that always gets me is that we have to constantly union join in history and working tables to get results that we expect.   we all know this is a throwback to Great Pains of old, where 8 character table names and 8 character field names were common in those days....who didn't love DOS?  but i'm sure memory constraints and all that made this necessary.

so what if I was to create a query that combined the history and working into a view or stored proc, and then just joining to that for reporting purposes?  is this something that would help clean up all those joins? 



Version: All
Section: Crystal Reports, Dynamics GP, Management Reporter, Microsoft Access, Report Writer, SQL Scripts, SSRS

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