The May 2009 Flexible Solutions GP Reports Newsletter brings us a tip for dynamically changing decimal places in Crystal Reports. This can be really useful for creating Sales Order Processing (SOP) reports for Dynamics GP, where GP stores the number of decimal places for each line item in the SOP10200 and SOP30300 tables. Here are the […]
Continue reading
Archive by Author
Crystal Reports service packs and versions
May 25, 2009 
39 Comments
Here is a handy list for determining what version and service pack of Crystal Reports you are running: CR 2013 2011 2008 XI R2 XI R1 RTM 14.0.0.760 12.0.0.549 11.5.0.313 11.0.0.895 SP 0 12.0.0.683 SP 1 14.1.1.1036 14.0.1.287 12.1.0.892 11.5.3.417 11.0.0.1282 SP 2 14.1.2.1121 14.0.2.364 12.2.0.290 11.5.8.826 link SP 3 14.1.3.1257 14.0.3.613 12.3.0.601 11.5.9.1076 11.0.0.2269 […]
Continue reading SQL view with all SOP line items in Dynamics GP
May 17, 2009 72 Comments
Here is a script that I have found useful on numerous occasions – it returns the lines items for all SOP (Sales Order Processing) transactions, both posted and unposted. This view will work with either SmartList Builder or Crystal Reports. For more scripts like this, take a look at my GP Reports page. ~~~~~ CREATE […]
Continue readingAdding watermarks to Crystal Reports
May 5, 2009 26 Comments
Here is the latest tip from the Flexible Solutions GP Reports Newsletter: how to add a watermark to your Crystal Reports. I am going to demonstrate with an example. I have created a statement report, but it’s a little bland, especially when there are only a few lines of data to show: First step is to […]
Continue readingSQL view with all posted Receivables transactions
April 24, 2009 30 Comments
Below is code to create a SQL view that returns all the posted Receivables transactions in Dynamics GP. I have had an abbreviated version of this view on my GP Reports page for a while, but I cleaned it up a bit and gave it some more friendly column names. I also added values for the commonly used […]
Continue readingHow to use a SQL view in SmartList Builder
April 20, 2009 43 Comments
Something I have been asked more than a few times is how to use a SQL view in SmartList Builder to create a new SmartList. I am going to walk through this step by step using Dynamics GP 10.0 SP 3 and SQL Server 2005 SP 3: STEP 1 – create SQL view To start […]
Continue reading Where did my transaction go?
April 11, 2009 7 Comments
This is a common question, especially with new users of Dynamics GP, and I was recently reminded of it by a post in the Microsoft Dynamics GP Newsgroup. While every transaction type will be slightly different, there is a basic lesson that is important for all GP users: beware of the Delete button. Most GP actions are updated automatically […]
Continue readingAlternating shading for lines in Crystal Reports
March 31, 2009 16 Comments
Here is a new Crystal Reports tip from the GP Reports Viewer newsletter collection. I have added an example with some screenshots to better illustrate. Want to spruce up your Crystal report a little by adding alternate color shading to the lines? Here is how. (Click on the screenshots to see them clearer.) As an example, let’s start with […]
Continue readingChanging the color scheme for Office 2007
March 30, 2009 4 Comments
There are many things I love about Office 2007. I think the ribbon is great and I cannot even remember how to work without it when I am on a computer with an older version of Office. But what I have always wondered is who decided that baby blue was the right choice for a default color scheme in […]
Continue readingSQL view with security resource details for Dynamics GP
March 20, 2009 38 Comments
As a corollary to my view showing the Dynamics GP security roles and tasks assigned to users, I have created another view that adds the security resource details. Thank you very much to Tim Foster for pointing me to a newsgroup post by David Musgrave detailing how to populate the SY09400 table in SQL which holds […]
Continue readingSQL view to show security roles and tasks in Dynamics GP
March 12, 2009 25 Comments
Dynamics GP 10.0 has brought about a drastic change in GP security. Not only is the security pessimistic now, so by default no permissions are granted, but setting up and administering security is quite different from what many of us are used to after working with previous versions of GP for many years. And, of course, reporting on […]
Continue readingSearching for strings in SQL Server using LIKE
March 2, 2009 7 Comments
Many times when searching for data in SQL Server we need to search for strings and use wild cards. One common wild card is %. As an example, I am going to use the Customer Master table (RM00101) in the Dynamics GP sample company, Fabrikam, Inc. If I want to all customers with ‘USA’ in the Class ID, […]
Continue readingHow to get a definition of your Crystal Report
February 19, 2009 2 Comments
Here is the latest Crystal Reports tip from the Flexible Solutions GP Reports Newsletter: Ever try to delete a parameter from a Crystal Report and get a pop-up message saying the field is in use on the report and then discover that you can’t find where it is actually used? Or need to be able […]
Continue readingGet Dynamics GP tips from an expert
February 10, 2009 0 Comments
Mark Polino, fellow Microsoft Dynamics GP MVP and prolific author of one of the most popular Dynamics GP blogs, DynamicAccounting.net, will be presenting at Convergence 2009! Mark’s session is called “Getting More out of Microsoft Dynamics GP, 50 Tips in 50 Minutes” and there are two time slots scheduled: Tuesday, March 10, 2009 | 5:00 PM – 6:00 PM […]
Continue readingSQL view to show items with SOP POP link
February 4, 2009 15 Comments
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 […]
Continue reading Why support only part of a solution on SQL Server 2008?
February 3, 2009 30 Comments
This is something that came up as I was reviewing posts in the FRx newsgroup and talking to customers about GP upgrades. I wanted to rant about it a little and see what others thought. Maybe I am over-reacting? Dynamics GP 10.0 is supported on SQL Server 2008. However, FRx Reporter 6.7 is only compatible […]
Continue reading Dynamics GP Integration Manager versions
January 28, 2009 22 Comments
With the help of the wonderful Microsoft support engineers I have been able to get a list of most of the Service Pack versions for Integration Manager 7.5 through 11 (for GP 2010): SP / IM IM 7.5 IM 8.0 IM 9.0 IM 10.0 IM 11 (GP 2010) IM 12 (GP 2013) RTM 7.05.0129 8.0.0.00 […]
Continue readingGreat Plains 7.0 and 7.5 service packs and versions
January 20, 2009 7 Comments
To complete the list I have been asked to publish the Great Plains version 7.0 and 7.5 service pack versions. Check out my GP support lifecycle post to see support end dates for these versions. Here is the detailed list for GP 7.x: Service Pack Version Great Plains 7.0 SP 1 7.00g5 Great Plains 7.0 SP 2 […]
Continue readingMy Last Book
Dynamics GP 2013 Implementation
My Previous Book
Dynamics GP 2010 Implementation
-
Using credit cards to pay vendors in Dynamics GP
-
SQL view for Payables GL distributions in Dynamics GP
-
SQL view for all posted GL transactions in Dynamics GP
-
SQL view for Payables payment apply detail in GP
-
Sales Transaction Entry GL distributions in Dynamics GP
-
SQL view to show AP apply information in GP
-
Year end close in Dynamics GP
- SQL view with AR apply detail
-
Granting access to a new SmartList in Dynamics GP
-
SQL view with all SOP line items in Dynamics GP
-
SQL view for unposted checks in Dynamics GP
-
SQL view for rolling 12 months of sales by item by site in Dynamics GP
-
Dynamics GP sales amounts and quantities for rolling 12 months
-
Updating Dynamics GP data directly in SQL
-
Did you know you can change Void dates on Payables transactions?
-
Refreshable Excel report for monthly actuals vs. budgets in Dynamics GP
-
SQL code to show top X percent of vendor data
-
Discount from Packt Publishing
-
Refreshable Excel report for historical GL trial balance in Dynamics GP
-
Refreshable Excel report for monthly GL budget in Dynamics GP
-
Victoria Yudin: Hi Matthew, This is a limitation in GP. "Why" is ...
-
Matthew: Why does "Sales" type distr...
-
-
Kevin Mackol: Does this still work on new...
-
-
Alex: Hi Victoria, Hi Victoria, Hi Victoria,Thank you so mu...
Victoria Yudin 
Recent Blog Comments