Archive | Payables SQL code RSS feed for this section

SQL view to show AP apply information in GP

October 22, 2008 by Victoria Yudin 80 Comments

Here is a corollary to the view I posted last week. The view below will show you what payments/credit memos were applied to payables transactions in GP. If you have SmartList Builder you can easily incorporate this SQL view into a new SmartList.  [Update: You can also use this in Crystal with the changes I made on […]

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

SQL view to show what check paid a Purchase Order

October 17, 2008 by Victoria Yudin 12 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
, , , ,
Newer Entries