Archive | POP SQL code RSS feed for this section

SQL view for Payables invoices originating from POP in Dynamics GP

September 1, 2010 by Victoria Yudin 40 Comments

This Dynamics GP SQL view originated from a request on the Dynamics GP customer forum, but is also something that I can see being useful in a variety of situations. It returns all posted Payables invoices that came from the Purchase Order Processing module with details of the items that were received on each invoice as well […]

Continue reading →
Dynamics GP, GL SQL code, GP Reports code, GP SQL scripts, Payables SQL code, POP SQL code
, , , , ,

SQL view to show items with SOP POP link

February 4, 2009 by Victoria Yudin 15 Comments

Here is a view to show all Sales Order Processing line items with the SOP-POP link in Dynamics GP.  You can use this with either SmartList Builder Crystal Reports, as I have made sure not to put any spaces in the column names.  I maintain a list of all the SQL code I’ve published on […]

Continue reading →
Dynamics GP, GP Reports code, GP SQL scripts, POP SQL code, SOP SQL code
, , , ,