victoriayudin.com
SQL view for last sale by customer and item | Victoria Yudin
https://victoriayudin.com/2011/03/29/sql-view-for-last-sale-by-customer-and-item
Ramblings and musings of a Dynamics GP MVP. Dynamics GP Build Numbers. GP 90 and Older Versions. MR and FRx Resources. All Reports / Code. General Ledger SQL Code. SQL Server Coding Tips. SQL view for last sale by customer and item. March 29, 2011 by Victoria Yudin. When was the last time a particular customer bought a particular item? Here is a little view that will tell you. For other Dynamics GP views and reporting tips, take a look at my GP Reports page. Or check out the SOP Tables page. Inner join S...
victoriayudin.com
Victoria Yudin | GP 2015 Resources
https://victoriayudin.com/resources/gp-2015-resources
Ramblings and musings of a Dynamics GP MVP. Dynamics GP Build Numbers. GP 90 and Older Versions. MR and FRx Resources. All Reports / Code. General Ledger SQL Code. SQL Server Coding Tips. Anything marked with a λ. Requires access to either CustomerSource or PartnerSource. GP 2015 System Requirements. GP 2015 Version List in Excel. GP 2015 Installation Guide. GP 2015 Service Packs and Hotfixes. GP 2015 Upgrade Guide. GP 2015 Upgrade Hot Topic. GP 2015 U.S. Payroll Tax Updates. GP 2015 What’s New. For exam...
victoriayudin.com
Victoria Yudin | SQL Server Resources
https://victoriayudin.com/resources/sql-server-resources
Ramblings and musings of a Dynamics GP MVP. Dynamics GP Build Numbers. GP 90 and Older Versions. MR and FRx Resources. All Reports / Code. General Ledger SQL Code. SQL Server Coding Tips. SQL Server service packs and versions. SQL Server support lifecycle. SQL 2012 Edition Comparison. SQL 2012 Hardware and Software Requirements. SQL 2008 R2 Edition Comparison. SQL 2008 R2 – Configuring Virtual Memory. SQL 2008 R2 Hardware and Software Requirements. SQL 2000 and 2005 Capacity Specifications. I have not he...
victoriayudin.com
Victoria Yudin | SQL Server Coding Tips
https://victoriayudin.com/gp-reports/sql-server-coding-tips
Ramblings and musings of a Dynamics GP MVP. Dynamics GP Build Numbers. GP 90 and Older Versions. MR and FRx Resources. All Reports / Code. General Ledger SQL Code. SQL Server Coding Tips. SQL Server Coding Tips. Changing part of a string using REPLACE. Getting the name of a month from the month number. How to find all SQL tables with a column name. Search an entire database for a value. Searching for strings using LIKE. Examples of how to calculate different dates. January 2, 2015 at 2:08 pm. How to rese...
victoriayudin.com
Dynamics GP build numbers and service packs | Victoria Yudin
https://victoriayudin.com/2010/09/11/dynamics-gp-version-numbers-and-service-packs
Ramblings and musings of a Dynamics GP MVP. Dynamics GP Build Numbers. GP 90 and Older Versions. MR and FRx Resources. All Reports / Code. General Ledger SQL Code. SQL Server Coding Tips. Dynamics GP build numbers and service packs. September 11, 2010 by Victoria Yudin. Requires CustomerSource of PartnerSource login). Additional links for GP 2016. GP 2015 detailed list of build numbers in Excel. Shows all products and versions, including hot fixes, requires CustomerSource of PartnerSource login). Require...
victoriayudin.com
SQL view for all posted GL transactions in Dynamics GP | Victoria Yudin
https://victoriayudin.com/2009/08/11/sql-view-for-all-posted-gl-transactions-in-dynamics-gp
Ramblings and musings of a Dynamics GP MVP. Dynamics GP Build Numbers. GP 90 and Older Versions. MR and FRx Resources. All Reports / Code. General Ledger SQL Code. SQL Server Coding Tips. SQL view for all posted GL transactions in Dynamics GP. August 11, 2009 by Victoria Yudin. Or the GP Reports page. A few notes on this view:. Year-end close transactions are excluded. Only functional amounts are brought in. Unposted transactions will not be shown. Service Pack 4 for Dynamics GP 10. May 19, 2016 at 11:28...
victoriayudin.com
Victoria Yudin | GP 9.0 & Older Versions
https://victoriayudin.com/resources/gp-9-0-and-older
Ramblings and musings of a Dynamics GP MVP. Dynamics GP Build Numbers. GP 90 and Older Versions. MR and FRx Resources. All Reports / Code. General Ledger SQL Code. SQL Server Coding Tips. GP 90 and Older Versions. Anything marked with a λ. Requires access to either CustomerSource or PartnerSource. If you have questions about accessing CustomerSource or PartnerSource, check out this post. By David Musgrave and Scott Stephenson. GP 90 Service Pack versions. GP 90 System Requirements. Upgrading to GP 9.0.
victoriayudin.com
Victoria Yudin | GP 10.0 Resources
https://victoriayudin.com/resources/gp-10-0-resources
Ramblings and musings of a Dynamics GP MVP. Dynamics GP Build Numbers. GP 90 and Older Versions. MR and FRx Resources. All Reports / Code. General Ledger SQL Code. SQL Server Coding Tips. Anything marked with a λ. Requires access to either CustomerSource or PartnerSource. If you have questions about accessing CustomerSource or PartnerSource, check out this post. By David Musgrave and Scott Stephenson. GP 100 System Requirements. GP 100 System Requirements for Web Applications. GP 100 Printer Compatibility.
victoriayudin.com
Victoria Yudin | General Ledger SQL Code
https://victoriayudin.com/gp-reports/general-ledger-sql-views
Ramblings and musings of a Dynamics GP MVP. Dynamics GP Build Numbers. GP 90 and Older Versions. MR and FRx Resources. All Reports / Code. General Ledger SQL Code. SQL Server Coding Tips. General Ledger SQL Code. Dynamics GP General Ledger SQL Code. Includes posted, unposted and historical GL transactions. All Posted GL Transactions. Includes posted and historical GL transactions only (nothing unposted). Refreshable Excel report for monthly GL budget in Dynamics GP. Historical GL Trial Balance. I believe...