Tag Archives: Purchase Order Processing

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
, , , , ,

What’s with all these dates?

September 8, 2009 by Victoria Yudin 21 Comments

There are many different dates stored in Dynamics GP. This is typically a good thing, my philosophy is that it is always better to have more data than you need and not the other way around. However, it can get confusing rather quickly since a lot of the labels for the dates sound very similar. I will attempt […]

Continue reading →
Dynamics GP
, , , , , ,

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
, , , ,

SQL view to show what check paid a Purchase Order

October 17, 2008 by Victoria Yudin 14 Comments

There is no easy way in Dynamics GP to see what check or credit memo was applied to a particular Purchase Order. Here is a SQL view that can be used in SmartList Builder or any other reporting tool you choose to see this information. For other SQL scripts please visit my GP Reports Page. ~~~~~ […]

Continue reading →
GP Reports code, GP SQL scripts, Payables SQL code
, , , ,

Dynamics GP POP table information

October 10, 2008 by Victoria Yudin 2 Comments

There is a new page with information now available for Purchase Order Processing tables.  I have also updated the Company/System Tables page with more data.  As always, you can see a list of all the information available so far on the main GP Reports page, which will also show the dates the individual pages have […]

Continue reading →
Dynamics GP
, ,