SQL Reporting Services Error- Maximum request length exceeded

By Ryan McBee When trying to deploy a large Dynamics GP report to your SSRS server or creating a subscription for one of your canned GP SSRS reports, you may run into an error like this: Error 2 There was an exception running the extensions specified in the config file. —> Maximum request length exceeded. […]

Read More

SQL Script to Report against multiple GP Companies

By Ryan McBee One of the most common needs when setting up multiple Great Plains Companies is to report against each company in a single report.  If you are looking for Financial reporting, it is fairly easy to setup a tree within Management Reporter or FRx which will meet your needs.  However, data that is in the […]

Read More

Warm up Script for SQL 2008 Reporting Services

By Ryan McBee In SSRS 2005, after a period of inactivity (no calls to Reporting services), the first call to RS is very slow. This is more of an IIS issue than reporting services. The app pool generally winds down if there is no activity for a certain period of time. When the subsequent (first) […]

Read More

SQL Script to Assign ALL GP Items to ALL Warehouses

By Ryan McBee When setting up new items within Microsoft Dynamics GP, you will often run into the error message below which reads “This site is not assigned to the selected item.  Do you want to assign this site?” The fix is quite simple given that you simply click the Add button below which opens […]

Read More

Migrating Dynamics GP and CRM to SQL 2008 R2

By Ryan McBee   GP must be on SP5 for GP 10. https://mbs.microsoft.com/customersource/documentation/systemrequirements/mdgp2010_system_requirements.htm?printpage=false&stext=system requirements CRM must be on a minimum of roll up 7. http://support.microsoft.com/kb/971782    

Read More