Home » SQL SCRIPTS » SOP/POP (SQL)
Top Websites
- Mark Polino's DynamicAccounting.net
Over 5100 resources listed. - Dynamics GP Help
Over 1700 resources listed. - Developing for Dynamics GP - By David Musgrave and the MS GP Dev Support Team
Over 900 resources listed. - Mariano Gomez at The Dynamics GP Blogster
Over 700 resources listed. - Microsoft Dynamics Partner Community Blog
Over 700 resources listed. - Mohammad Daoud's Dynamics GP Blog
Over 500 resources listed. - Vaidy Mohan at Dynamics GP - Learn & Discuss
Over 400 resources listed. - Inside Microsoft Dynamics GP Official Blog
Over 400 resources listed. - Christina Phillips, Steve Endow & Lorren Zemke at Dynamics GP Land
Over 300 resources listed. - eOne Business Solutions Blog
Over 300 resources listed. - Frank Hamelly at GP2theMax
Over 300 resources listed. - About Dynamics, Development and Life
Over 300 resources listed. - Dynamics CPM
Over 200 resources listed. - Rose Business Solutions Blog New
Over 200 resources listed. - Janakiram M.P. at DynamicsBlogger
Over 100 resources listed. - Victoria Yudin's Dynamics GP Website
Over 100 resources listed.Victoria Yudin - VS Tools Forum
Over 100 resources listed.Your Resource for Visual Studio Tools for Dynamics GP - Inside Microsoft Dynamics GP Official Blog
Over 100 resources listed. - Leslie Vail at Dynamics Confessor Blogspot
Over 100 resources listed. - BKD Dynamics GP Insights Blog
Over 100 resources listed. - US Dynamics GP Field Team Blog
Over 100 resources listed. - Catherine Eibner MBS Developer Evangelist
Over 100 resources listed. - Sivakumar Venkataraman at Interesting Findings & Knowledge Sharing
Over 100 resources listed. - Dynamics Small Business
Over 100 resources listed. - Belinda, The GP CSI
Over 100 resources listed.
Useful Dynamics GP Links
Search all GP Blogs, Groups and Forums New!
GPWindow is Everything Dynamics GP. Try the Custom GP Search engine which searches high quality GP Blogs, and the Microsoft Dynamics GP Community Forums.
Parent Category: SOP/POP (SQL)
Links Sort by: Hits | References | Alphabetical
SQL view with all SOP line items
http://victoriayudin.com/2009/05/17/sql-view-with-all-sop-line-items/
Weekly Dynamic: Customers Who Bought “X” Also Bought…
http://msdynamicsgp.blogspot.com/2010/06/weekly-dynamic-customers-who-bought-x.html
I was reworking the list of SQL Scripts for DynamicAccounting.net and I realized that it would be nice to have some SQL code that showed related items. In other word, something similar to Amazon.com’s “Customers who bought “X” also bought “A”, “M” and “Y”.
I wanted to add a frequency to make it more relevant. What I was looking for was “Customers who bought “X” also bought “A” 56% of the time, “M” 42% of the time and “Y” 38% of the time. I could swear I’ve seen code like this but I couldn’t find it,…
I wanted to add a frequency to make it more relevant. What I was looking for was “Customers who bought “X” also bought “A” 56% of the time, “M” 42% of the time and “Y” 38% of the time. I could swear I’ve seen code like this but I couldn’t find it,…
Deleting Empty SOP Batches Made Easy
http://mbsguru.blogspot.com/2010/08/deleting-empty-sop-batches-made-easy.html
I took a support call recently in which a client explained that they had accumulated hundreds of empty SOP Batches that they wanted to delete. In response, I produced a simple proc that will scroll through the "Sales Entry" Batches and, like Check Links on Sales Work, will update the Number of Transactions and Batch Total…
Posted by
SQL view to show items with SOP POP link
http://victoriayudin.com/2009/02/04/sql-view-to-show-items-with-sop-pop-link/
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 my GP Reports page so if you’re looking for other scripts, take a look there.
~~~~~
CREATE VIEW view_SOP_POP_Link
AS
/**
view_SOP_POP_Link
Created Feb. 4 2009 by Victoria Yudin - Flexible Solutions, Inc.
For updates see http://victoriayudin.com/gp-reports/
Shows all SOP line items with SOP - POP link…SQL view to show what check paid a Purchase Order
http://victoriayudin.com/2008/10/17/sql-view-what-check-paid-purchase-order/
There is no easy way in Dynamics GP to see what check or credit memo was applied to a particular Purchase Order. If…
SQL View – SOP to POP Links
http://rldu.wordpress.com/2010/04/06/sql-view-sop-to-pop-links/
The following view returns the all the Sales Order Processing to Purchase Order Processing (SOP to POP) links in your GP database.
This view is also a modification of the spvSopToPop view from Salespad (www.salespad.net).
You can name the view whatever you want by change the [tspvSopToPop] below. Also the USE [TSP] tells the script to only execute on…
Posted by
SQL View – SOP to POP Links
http://msdynamicsgp.blogspot.com/2010/04/sql-view-sop-to-pop-links.html
It’s been a busy week and promises to stay busy through Convergence 2010 so I’m just…
SQL Scripts – Purchase Order Line Item Discrepancy
http://rldu.wordpress.com/2010/05/19/sql-scripts-purchase-order-line-item-discrepancy/
SQL Scripts – SOP to POP Margin Analysis
http://rldu.wordpress.com/2010/04/09/sql-scripts-sop-to-pop-margin-analysis/
SQL View – Purchase Order Line Items
http://rldu.wordpress.com/2010/03/23/sql-view-purchase-order-line-items/
SQL Views – Dynamics GP Purchase Order View
http://rldu.wordpress.com/2010/03/11/dynamics-gp-purchase-order-view/
SQL View with All Dynamics GP SOP Lines
http://msdynamicsgp.blogspot.com/2009/05/sql-view-with-all-dynamics-gp-sop-lines.html
Victoria Yudin has a new SQL View up to show all of the Sales Order Processing transaction…
SQL View to Show SOP POP Link 
http://msdynamicsgp.blogspot.com/2009/02/sql-view-to-show-sop-pop-link.html
Victoria Yudin has a SQL View to show items with a SOP POP link on her blog.
Posted by
Dynamics GP SQL View to Show What Check Paid a PO
http://msdynamicsgp.blogspot.com/2008/10/dynamics-gp-sql-view-to-show-what-check.html
Ooooo! Victoria Yudin has a SQL view that will show what check paid a Purchase Order! Make…
Posted by
Latest links
- Website is down...but not for long!
- “Doug Pitcher’s OFFICIAL 100 most famous, awesome and totally influential Dynamics people for 2013” is almost here
- Doug Pitcher’s OFFICIAL 100 most famous, awesome and totally influential Dynamics people for 2013
- Rob Collie’s Open Letter to My Friends at Microsoft: The Power of Excel’s Internal Network Effect « PowerPivotPro
- Using Maps to Visualize Data in SQL Server Reporting Services Reports | Dynamics GP Insights
- Dynamics GP Land: Dynamics GP 2013 appears to still have bug in Payables EFT CTX File Format
- Dynamics GP 2013 FAQ: How to Run File Maintenance. – Etelligent Solutions
- Error message -Could not find a part of the path when publishing Excel Report Builder report in GP
- Warning “Sales Order Processing and Invoicing are both installed” in Microsoft Dynamics GP
- SOP Quote Warning -Line item quantities are not fully distributed. Do you want to continue ?
GPWindow.com
Developed and presented by
Smith & Allen Consulting, Inc.,
GP specialists since 1991.