Archive | Payables SQL code RSS feed for this section
i found you!

SQL view to show AP apply information in GP

October 22, 2008 by Victoria Yudin 51 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 [...]

Read more
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 8 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. ~~~~~ [...]

Read more
GP Reports code, GP SQL scripts, Payables SQL code
, , , ,
Newer Entries

Follow

Get every new post delivered to your Inbox.

Join 486 other followers