victoriayudin.com
Crystal Reports service packs and versions | Victoria Yudin
https://victoriayudin.com/2009/05/25/crystal-reports-service-packs-and-versions
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. Crystal Reports service packs and versions. May 25, 2009 by Victoria Yudin. Here is a handy list for determining what version and service pack of Crystal Reports you are running:. For Crystal 2011, it seems to always say ‘RTM’ after the version number. For example, I just installed SP 6, and it says:. On the SAP site.
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
Victoria Yudin | GP Tables
https://victoriayudin.com/gp-tables
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. Below are pages with table information for Dynamics GP as well as some additional resources for finding table information. This is not meant to be a listing of all tables or all modules, just the tables and fields we most often use when reporting. Pages with Table Information for Dynamics GP. 8211; General Ledger. Dynam...
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.