Feeds:
Posts
Comments

Posts Tagged ‘GP SQL view’

SQL view with AR apply detail

Posted in GP Reports, GP SQL scripts, tagged , , , on February 15, 2010 | 4 Comments »

This has been a hot topic in the newsgroups lately and several people have asked me if I have any code for Receivables (AR) apply information in Dynamics GP. Below is a view that should help you get started if you’re building a report to show AR apply information in Dynamics GP.
For more views like this, check out my [...]

Read Full Post »

SQL view with all GL distributions for AR transactions

Posted in GP Reports, GP SQL scripts, tagged , , , , on February 10, 2010 | 5 Comments »

As a corollary to my SQL view with all posted Receivables transactions, below is a view that will add all the General Ledger distributions to the AR transactions. I made a few changes to the original AR transactions view, primarily to remove some columns that are typically not needed and add underscores to the column names so [...]

Read Full Post »

SQL view for Payables payment apply detail in Dynamics GP

Posted in GP Reports, GP SQL scripts, tagged , , , on October 22, 2009 | 21 Comments »

I have published SQL views that return all posted Payables payments in Dynamics GP and Payables apply information to help identify what payments (or credits) paid off an invoice, however another frequent request is for a list of payments and their apply information.  Below is a view that returns a list of all posted payments with details on how [...]

Read Full Post »

SQL view for all posted Payables transactions in Dynamics GP

Posted in GP Reports, GP SQL scripts, tagged , , , on October 12, 2009 | 5 Comments »

Payables Transactions have been a popular request for reports lately. Below is a view that lists all posted Payables transactions in functional currency. Voided transactions are not excluded.
For other SQL views on Dynamics GP data, please visit my GP Reports page.
~~~~~
CREATE VIEW view_PM_Transactions
AS

/***************************************************************
view_PM_Transactions
Created Oct 12 2009 by Victoria Yudin – Flexible Solutions, Inc.
For updates see http://victoriayudin.com/gp-reports/
Shows all posted [...]

Read Full Post »

SQL view for all posted Payables payments in Dynamics GP

Posted in GP Reports, GP SQL scripts, tagged , , , on September 11, 2009 | 4 Comments »

This view is in response to more than a few inquiries I have had for a vendor check report. This view brings in all payments, not just checks, so if only checks are needed, add the following to the end of the WHERE clause:
AND P.PYENTTYP = 0
For other SQL code, please visit my GP Reports [...]

Read Full Post »

Older Posts »