Monday, December 12, 2011

Everything Dynamics GP #49

Missed Decisions 2011? You can register and they will alert you when the sessions are available to be viewed on-demand. This is a slightly rushed update, in a rushed and busy few weeks.

Now you can subscribe to Everything Dynamics GP via email






Troubleshooting/GP Help

Other Interesting Stuff

Jivtesh (Microsoft Dynamics GP MVP)
Microsoft Dynamics Certified Technology Specialist: GP 2010
Have any GP related questions ? Feel free to email me at Jivtesh AT gmail.com
Blog : www.jivtesh.com
GP Help Website : www.gpwindow.com (Over 10,000 Dynamics GP Resources)

Sunday, December 11, 2011

Developer Productivity - Tools to Save 100 Hours a year as a .Net Developer (Microsoft Mondays)

Thank you all who attended today’s presentation. The presentation with all the screenshots is available for download at - http://www.box.com/s/dy7qtramxako6sapf0th 

Here are further resources related to the presentation :



Tuesday, December 6, 2011

Resources for Business Analyzer Presentation at Decisions 2011

Below are some resources related for the Decisions 2011 presentation - Dashboard Charts and Graphs for Everybody with Business Analyzer for Microsoft Dynamics GP 2010

The PowerPoint presentation is available for download now.

Inside GP Blog Posts about Business Analyzer

Business Analyzer with Gestures

Using Lync with Business Analyzer – Video Series

Reporting Services Troubleshooting Errors

Turning off Business Analyzer inside GP

http://dynamicssmallbusiness.blogspot.com/2011/07/rsitemnotfound-error-when-clicking-on.html - and http://social.microsoft.com/Forums/en-US/partnerdynamicsgp/thread/f86a89e4-0867-42b0-8cc3-f64c380721eb

Sunday, December 4, 2011

SQL Prompt–Intellisense for SQL Server and more

Some of you might have started using intellisense with SQL Server 2008. Intellisense is a great feature, and its something I can’t live without when I am coding.

What do you do when you are working on an older SQL Server instance ? In such scenario’s you can use Red Gate’s SQL Prompt

SQL Prompt is a tool I have used for a long time – and I highly recommend it if you spend more than a few minutes writing SQL Code.

Here are some screenshots of all it can do, the feature list is elaborate, I recommend you check it out -

Wild Card Expansion

For Example is you have


When you press TAB you get -



SQL Code Expansions

type ssf and press ENTER and you get SELECT * FROM.



INSERT Statements

This is a HUGE time saver



Press Tab and you get


There is a 14 day trial as well - http://www.red-gate.com/products/sql-development/sql-prompt/

Another tool that offers intellisense in SQL Management Studio is http://www.devart.com/dbforge/sql/sqlcomplete/, however, I personally have not used it.

Thursday, December 1, 2011

3 Top Scenarios when I use Support Debugging Tool

Mariano Gomez has an upcoming presentation - Five Support Debugging Tool Features You Should be Using Today with Microsoft Dynamics GP | Decisions Fall 2011. Mariano is one of the foremost experts on Support Debugging Tool – and I highly recommend you register and watch this presentation.

I thought I would share the 3 most common scenario’s, when I use the Support Debugging Tool  -

#1 Resolving security and permission issues

Last year with help from Rubal – I had built a page that let you find out the Security Task/Role associated with a Dynamics GP Window. I still use this page and the Security Report page while planning Security Roles. However, for resolving Security and permission issues – the Support Debugging Tool lets you do everything from inside Dynamics GP. See details here - Solving Security Privileges Errors Using the Support Debugging Tool - Developing for Dynamics GP

#2 Backup Table Data / migrate data between databases

You can use the XML Table Export/Import to transfer /backup table data. This is great when you are migrating data from test to production or vice versa.

Check out two examples - How to transfer Security Tasks and Roles between Systems - Developing for Dynamics GP and Dynamics GP SDT Essential Series 2 – Transfer AA Dimensions and Codes from Test to Production


#3 Email screenshots of multiple Dynamics GP windows

This is one of the coolest features. If you are explaining a complicated issue – which involves showing multiple Dynamics GP Windows, this feature is a God Send. Instead of manually taking 4 separate screenshots, you can use one button in Support Debugging Tool to capture multiple screenshots!




You can also attach the dex.ini and Dynamics.set file from this screen, and email the files!


Thank you to David Musgrave and the MS team for this awesome tool!

For more details about SDT check out