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 [...]
Posts Tagged ‘GP SQL view’
SQL view with AR apply detail
Posted in GP Reports, GP SQL scripts, tagged GP Reports, GP SQL view, Receivables, SQL code on February 15, 2010 | 4 Comments »
SQL view with all GL distributions for AR transactions
Posted in GP Reports, GP SQL scripts, tagged General Ledger, GP Reports, GP SQL view, Receivables, SQL code 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 [...]
SQL view for Payables payment apply detail in Dynamics GP
Posted in GP Reports, GP SQL scripts, tagged GP Reports, GP SQL view, Payables, SQL code 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 [...]
SQL view for all posted Payables transactions in Dynamics GP
Posted in GP Reports, GP SQL scripts, tagged GP Reports, GP SQL view, Payables, SQL code 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 [...]
SQL view for all posted Payables payments in Dynamics GP
Posted in GP Reports, GP SQL scripts, tagged GP Reports, GP SQL view, Payables, SQL code 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 [...]