Wednesday, October 26, 2011

MVP Jivtesh Singh shows the power of Business Analyzer with Windows tablets

If you are one of those who love cutting edge Microsoft Dynamics GP stuff, then take a look at fellow Microsoft Dynamics GP MVP Jivtesh Singh showing off Business Analyzer on a Microsoft Windows Touch tablet. Jivtesh emphasizes usability, simplicity, and availability of meaningful enterprise data for information consumers who need solid grounds for quick decision making.


Furthermore, Jivtesh shows off how you can add more power by using Microsoft Lync integration.



This sure makes selling Microsoft Dynamics GP much easier.

Until next post!

MG.-
Mariano Gomez, MVP
IntellPartners, LLC
http://www.IntellPartners.com/

Mark Polino shows some love for Microsoft Dynamics GP integration tools

Like Mark, a lot of the work I do centers around large and complex systems integration with Microsoft Dynamics GP. It's good to see that Mark addresses some of the glories, pains, and considerations for systems selection and integration to Microsoft Dynamics GP in his new article Dynamics GP Integration Flexibility and Frustration over at his Community column Mad Mark, The GP Road Warrior. In addition, he points out some of the integration tools and methods he's used to get these to happen.

And speaking of integrations...

Please come join me at the GPUG Summit 2011 for the Optional Academy Training Classes. I will be delivering a full day training class on Data Migration and Integration Techniques where I will be highlighting some of the issues I have faced throughout my career when migrating and integrating data from and into GP.

My training curriculum is almost locked down, but if you are attending this class and want to see a particular topic being discussed please do so by adding a comment at the bottom of this post.

Until next post!

MG.-
Mariano Gomez, MVP
IntellPartners, LLC
http://www.IntellPartners.com/

Monday, October 24, 2011

Copying Smartlists favorites from one user to another

I get this question asked very often and sometimes have to dig up my notes on the subject, so I figured I would just post the SQL script that I use for this.

Smartlist favorites are traditionally stored in the ASIEXP81 table on a user-company basis. It's important to keep this in mind, as you can tailor this script to copy favorites from one user to another in the same company or the same user across various companies. However, this script replicates all favorites, across all companies for one user to another user.

USE DYNAMICS;
GO
-- remove any records for the destination user prior to synchronizing
DELETE FROM ASIEXP81 WHERE USERID = '<DestinationUserID>';

-- execute synchronization
INSERT INTO ASIEXP81
           (ASI_Favorite_Dict_ID
           ,ASI_Favorite_Type
           ,ASI_Favorite_Save_Level
           ,CMPANYID
           ,USRCLASS
           ,USERID
           ,ASI_Favorite_Name
           ,ASI_Field_Dict_ID_1
           ,ASI_Field_Dict_ID_2
           ,ASI_Field_Dict_ID_3
           ,ASI_Field_Dict_ID_4
           ,ASI_Field_List_1
           ,ASI_Field_List_2
           ,ASI_Field_List_3
           ,ASI_Field_List_4
           ,ASI_Search_Type_1
           ,ASI_Search_Type_2
           ,ASI_Search_Type_3
           ,ASI_Search_Type_4
           ,ASI_Match_Case_1
           ,ASI_Match_Case_2
           ,ASI_Match_Case_3
           ,ASI_Match_Case_4
           ,ASI_Start_Account_Number_1_1
           ,ASI_Start_Account_Number_1_2
           ,ASI_Start_Account_Number_1_3
           ,ASI_Start_Account_Number_1_4
           ,ASI_Start_Account_Number_1_5
           ,ASI_Start_Account_Number_1_6
           ,ASI_Start_Account_Number_1_7
           ,ASI_Start_Account_Number_1_8
           ,ASI_Start_Account_Number_1_9
           ,ASI_Start_Account_Number_1_10
           ,ASI_Start_Account_Number_2_1
           ,ASI_Start_Account_Number_2_2
           ,ASI_Start_Account_Number_2_3
           ,ASI_Start_Account_Number_2_4
           ,ASI_Start_Account_Number_2_5
           ,ASI_Start_Account_Number_2_6
           ,ASI_Start_Account_Number_2_7
           ,ASI_Start_Account_Number_2_8
           ,ASI_Start_Account_Number_2_9
           ,ASI_Start_Account_Number_2_10
           ,ASI_Start_Account_Number_3_1
           ,ASI_Start_Account_Number_3_2
           ,ASI_Start_Account_Number_3_3
           ,ASI_Start_Account_Number_3_4
           ,ASI_Start_Account_Number_3_5
           ,ASI_Start_Account_Number_3_6
           ,ASI_Start_Account_Number_3_7
           ,ASI_Start_Account_Number_3_8
           ,ASI_Start_Account_Number_3_9
           ,ASI_Start_Account_Number_3_10
           ,ASI_Start_Account_Number_4_1
           ,ASI_Start_Account_Number_4_2
           ,ASI_Start_Account_Number_4_3
           ,ASI_Start_Account_Number_4_4
           ,ASI_Start_Account_Number_4_5
           ,ASI_Start_Account_Number_4_6
           ,ASI_Start_Account_Number_4_7
           ,ASI_Start_Account_Number_4_8
           ,ASI_Start_Account_Number_4_9
           ,ASI_Start_Account_Number_4_10
           ,ASI_Start_Date_Token_DDL_1
           ,ASI_Start_Date_Token_DDL_2
           ,ASI_Start_Date_Token_DDL_3
           ,ASI_Start_Date_Token_DDL_4
           ,ASI_Start_Date_1
           ,ASI_Start_Date_2
           ,ASI_Start_Date_3
           ,ASI_Start_Date_4
           ,ASI_Start_DDL_1
           ,ASI_Start_DDL_2
           ,ASI_Start_DDL_3
           ,ASI_Start_DDL_4
           ,ASI_String_Start_1
           ,ASI_String_Start_2
           ,ASI_String_Start_3
           ,ASI_String_Start_4
           ,ASI_End_Account_Number_1_1
           ,ASI_End_Account_Number_1_2
           ,ASI_End_Account_Number_1_3
           ,ASI_End_Account_Number_1_4
           ,ASI_End_Account_Number_1_5
           ,ASI_End_Account_Number_1_6
           ,ASI_End_Account_Number_1_7
           ,ASI_End_Account_Number_1_8
           ,ASI_End_Account_Number_1_9
           ,ASI_End_Account_Number_1_10
           ,ASI_End_Account_Number_2_1
           ,ASI_End_Account_Number_2_2
           ,ASI_End_Account_Number_2_3
           ,ASI_End_Account_Number_2_4
           ,ASI_End_Account_Number_2_5
           ,ASI_End_Account_Number_2_6
           ,ASI_End_Account_Number_2_7
           ,ASI_End_Account_Number_2_8
           ,ASI_End_Account_Number_2_9
           ,ASI_End_Account_Number_2_10
           ,ASI_End_Account_Number_3_1
           ,ASI_End_Account_Number_3_2
           ,ASI_End_Account_Number_3_3
           ,ASI_End_Account_Number_3_4
           ,ASI_End_Account_Number_3_5
           ,ASI_End_Account_Number_3_6
           ,ASI_End_Account_Number_3_7
           ,ASI_End_Account_Number_3_8
           ,ASI_End_Account_Number_3_9
           ,ASI_End_Account_Number_3_10
           ,ASI_End_Account_Number_4_1
           ,ASI_End_Account_Number_4_2
           ,ASI_End_Account_Number_4_3
           ,ASI_End_Account_Number_4_4
           ,ASI_End_Account_Number_4_5
           ,ASI_End_Account_Number_4_6
           ,ASI_End_Account_Number_4_7
           ,ASI_End_Account_Number_4_8
           ,ASI_End_Account_Number_4_9
           ,ASI_End_Account_Number_4_10
           ,ASI_End_Date_Token_DDL_1
           ,ASI_End_Date_Token_DDL_2
           ,ASI_End_Date_Token_DDL_3
           ,ASI_End_Date_Token_DDL_4
           ,ASI_End_Date_1
           ,ASI_End_Date_2
           ,ASI_End_Date_3
           ,ASI_End_Date_4
           ,ASI_End_DDL_1
           ,ASI_End_DDL_2
           ,ASI_End_DDL_3
           ,ASI_End_DDL_4
           ,ASI_String_End_1
           ,ASI_String_End_2
           ,ASI_String_End_3
           ,ASI_String_End_4
           ,ASI_Search_From_Str_1
           ,ASI_Search_From_Str_2
           ,ASI_Search_From_Str_3
           ,ASI_Search_From_Str_4
           ,ASI_Search_To_Str_1
           ,ASI_Search_To_Str_2
           ,ASI_Search_To_Str_3
           ,ASI_Search_To_Str_4
           ,ASI_Search_Logic_Type
           ,ASI_Max_Records
           ,ASI_Sort_Dict_ID
           ,ASI_Sort_Field
           ,ASI_Sort_Type
           ,ASI_Field_Comparison_1
           ,ASI_Field_Comparison_2
           ,ASI_Field_Comparison_3
           ,ASI_Field_Comparison_4
           ,ASI_Start_Comp_Field_ID_1
           ,ASI_Start_Comp_Field_ID_2
           ,ASI_Start_Comp_Field_ID_3
           ,ASI_Start_Comp_Field_ID_4
           ,ASI_Start_Comp_Field_Dic_1
           ,ASI_Start_Comp_Field_Dic_2
           ,ASI_Start_Comp_Field_Dic_3
           ,ASI_Start_Comp_Field_Dic_4
           ,ASI_End_Comp_Field_ID_1
           ,ASI_End_Comp_Field_ID_2
           ,ASI_End_Comp_Field_ID_3
           ,ASI_End_Comp_Field_ID_4
           ,ASI_End_Comp_Field_Dict_1
           ,ASI_End_Comp_Field_Dict_2
           ,ASI_End_Comp_Field_Dict_3
           ,ASI_End_Comp_Field_Dict_4)
SELECT ASI_Favorite_Dict_ID
      ,ASI_Favorite_Type
      ,ASI_Favorite_Save_Level
      ,CMPANYID
      ,USRCLASS
      ,'<DestinationUserID>'
      ,ASI_Favorite_Name
      ,ASI_Field_Dict_ID_1
      ,ASI_Field_Dict_ID_2
      ,ASI_Field_Dict_ID_3
      ,ASI_Field_Dict_ID_4
      ,ASI_Field_List_1
      ,ASI_Field_List_2
      ,ASI_Field_List_3
      ,ASI_Field_List_4
      ,ASI_Search_Type_1
      ,ASI_Search_Type_2
      ,ASI_Search_Type_3
      ,ASI_Search_Type_4
      ,ASI_Match_Case_1
      ,ASI_Match_Case_2
      ,ASI_Match_Case_3
      ,ASI_Match_Case_4
      ,ASI_Start_Account_Number_1_1
      ,ASI_Start_Account_Number_1_2
      ,ASI_Start_Account_Number_1_3
      ,ASI_Start_Account_Number_1_4
      ,ASI_Start_Account_Number_1_5
      ,ASI_Start_Account_Number_1_6
      ,ASI_Start_Account_Number_1_7
      ,ASI_Start_Account_Number_1_8
      ,ASI_Start_Account_Number_1_9
      ,ASI_Start_Account_Number_1_10
      ,ASI_Start_Account_Number_2_1
      ,ASI_Start_Account_Number_2_2
      ,ASI_Start_Account_Number_2_3
      ,ASI_Start_Account_Number_2_4
      ,ASI_Start_Account_Number_2_5
      ,ASI_Start_Account_Number_2_6
      ,ASI_Start_Account_Number_2_7
      ,ASI_Start_Account_Number_2_8
      ,ASI_Start_Account_Number_2_9
      ,ASI_Start_Account_Number_2_10
      ,ASI_Start_Account_Number_3_1
      ,ASI_Start_Account_Number_3_2
      ,ASI_Start_Account_Number_3_3
      ,ASI_Start_Account_Number_3_4
      ,ASI_Start_Account_Number_3_5
      ,ASI_Start_Account_Number_3_6
      ,ASI_Start_Account_Number_3_7
      ,ASI_Start_Account_Number_3_8
      ,ASI_Start_Account_Number_3_9
      ,ASI_Start_Account_Number_3_10
      ,ASI_Start_Account_Number_4_1
      ,ASI_Start_Account_Number_4_2
      ,ASI_Start_Account_Number_4_3
      ,ASI_Start_Account_Number_4_4
      ,ASI_Start_Account_Number_4_5
      ,ASI_Start_Account_Number_4_6
      ,ASI_Start_Account_Number_4_7
      ,ASI_Start_Account_Number_4_8
      ,ASI_Start_Account_Number_4_9
      ,ASI_Start_Account_Number_4_10
      ,ASI_Start_Date_Token_DDL_1
      ,ASI_Start_Date_Token_DDL_2
      ,ASI_Start_Date_Token_DDL_3
      ,ASI_Start_Date_Token_DDL_4
      ,ASI_Start_Date_1
      ,ASI_Start_Date_2
      ,ASI_Start_Date_3
      ,ASI_Start_Date_4
      ,ASI_Start_DDL_1
      ,ASI_Start_DDL_2
      ,ASI_Start_DDL_3
      ,ASI_Start_DDL_4
      ,ASI_String_Start_1
      ,ASI_String_Start_2
      ,ASI_String_Start_3
      ,ASI_String_Start_4
      ,ASI_End_Account_Number_1_1
      ,ASI_End_Account_Number_1_2
      ,ASI_End_Account_Number_1_3
      ,ASI_End_Account_Number_1_4
      ,ASI_End_Account_Number_1_5
      ,ASI_End_Account_Number_1_6
      ,ASI_End_Account_Number_1_7
      ,ASI_End_Account_Number_1_8
      ,ASI_End_Account_Number_1_9
      ,ASI_End_Account_Number_1_10
      ,ASI_End_Account_Number_2_1
      ,ASI_End_Account_Number_2_2
      ,ASI_End_Account_Number_2_3
      ,ASI_End_Account_Number_2_4
      ,ASI_End_Account_Number_2_5
      ,ASI_End_Account_Number_2_6
      ,ASI_End_Account_Number_2_7
      ,ASI_End_Account_Number_2_8
      ,ASI_End_Account_Number_2_9
      ,ASI_End_Account_Number_2_10
      ,ASI_End_Account_Number_3_1
      ,ASI_End_Account_Number_3_2
      ,ASI_End_Account_Number_3_3
      ,ASI_End_Account_Number_3_4
      ,ASI_End_Account_Number_3_5
      ,ASI_End_Account_Number_3_6
      ,ASI_End_Account_Number_3_7
      ,ASI_End_Account_Number_3_8
      ,ASI_End_Account_Number_3_9
      ,ASI_End_Account_Number_3_10
      ,ASI_End_Account_Number_4_1
      ,ASI_End_Account_Number_4_2
      ,ASI_End_Account_Number_4_3
      ,ASI_End_Account_Number_4_4
      ,ASI_End_Account_Number_4_5
      ,ASI_End_Account_Number_4_6
      ,ASI_End_Account_Number_4_7
      ,ASI_End_Account_Number_4_8
      ,ASI_End_Account_Number_4_9
      ,ASI_End_Account_Number_4_10
      ,ASI_End_Date_Token_DDL_1
      ,ASI_End_Date_Token_DDL_2
      ,ASI_End_Date_Token_DDL_3
      ,ASI_End_Date_Token_DDL_4
      ,ASI_End_Date_1
      ,ASI_End_Date_2
      ,ASI_End_Date_3
      ,ASI_End_Date_4
      ,ASI_End_DDL_1
      ,ASI_End_DDL_2
      ,ASI_End_DDL_3
      ,ASI_End_DDL_4
      ,ASI_String_End_1
      ,ASI_String_End_2
      ,ASI_String_End_3
      ,ASI_String_End_4
      ,ASI_Search_From_Str_1
      ,ASI_Search_From_Str_2
      ,ASI_Search_From_Str_3
      ,ASI_Search_From_Str_4
      ,ASI_Search_To_Str_1
      ,ASI_Search_To_Str_2
      ,ASI_Search_To_Str_3
      ,ASI_Search_To_Str_4
      ,ASI_Search_Logic_Type
      ,ASI_Max_Records
      ,ASI_Sort_Dict_ID
      ,ASI_Sort_Field
      ,ASI_Sort_Type
      ,ASI_Field_Comparison_1
      ,ASI_Field_Comparison_2
      ,ASI_Field_Comparison_3
      ,ASI_Field_Comparison_4
      ,ASI_Start_Comp_Field_ID_1
      ,ASI_Start_Comp_Field_ID_2
      ,ASI_Start_Comp_Field_ID_3
      ,ASI_Start_Comp_Field_ID_4
      ,ASI_Start_Comp_Field_Dic_1
      ,ASI_Start_Comp_Field_Dic_2
      ,ASI_Start_Comp_Field_Dic_3
      ,ASI_Start_Comp_Field_Dic_4
      ,ASI_End_Comp_Field_ID_1
      ,ASI_End_Comp_Field_ID_2
      ,ASI_End_Comp_Field_ID_3
      ,ASI_End_Comp_Field_ID_4
      ,ASI_End_Comp_Field_Dict_1
      ,ASI_End_Comp_Field_Dict_2
      ,ASI_End_Comp_Field_Dict_3
      ,ASI_End_Comp_Field_Dict_4
FROM ASIEXP81 WHERE USERID = '<SourceUserID>';

GO

In the above script <SourceUserID> and <DestinationUserID> are placeholders for the actual user IDs.

Until next post!

MG.-
Mariano Gomez, MVP
IntellPartners, LLC
http://www.IntellPartners.com/

Tuesday, October 18, 2011

Decisions Fall 2011 Virtual Conference registrations now open


Well folks, as I mentioned before, this year-end is going to be a bit busy on my calendar. In addition to my Las Vegas adventure with the GPUG folks, I am speaking at the MSDynamicsWorld Decisions Fall 2011 virtual conference. This time, I am adding a 30-minute, fast paced Support Debugging Tool session.

Please come join my session Five Support Debugging Tool Features You Should be Using Today with Microsoft Dynamics GP. That's it! You just need to sit in for 30 minutes and as a result you will gain a good understanding of the key end-user and administrative functions available in the tool.

Also join me in a live Microsoft Dynamics GP MVP Panel featuring my fellow MVPs, Frank Hamelly, Jivtesh Singh, and Mark Polino. Seriously, in what circus do you get to ask four clowns a question and get an intelligent response? Well, now is your chance. We promise to make this entertaining and fun in a relaxed setting.

Register now!

Until next post!

MG.-
Mariano Gomez, MVP
IntellPartners, LLC
http://www.IntellPartners.com/

Monday, October 17, 2011

Printing to screen and PDF file causes default printer to change to Acrobat PDF Writer

A user recently reported a strange Microsoft Dynamics GP behavior when trying to print any report in to file in PDF format, while simultaneously sending the report to screen.

The PDF gets created and the report appears on the screen as it would be expected. However, when she attempts to print the report from the screen to printer, the only printer available is Adobe PDF Writer. While having the report on screen, the user checked the default printer, which remained unchanged, nonetheless the report on screen would only print to Adobe PDF Writer, bypassing the default printer.

I suspect what is happening in this case is, when the report is directed to screen and a PDF file simultaneously, the Runtime Engine changes the default printer to the Adobe PDF Writer (Adobe Distiller in some cases) printer in order to write the file in PDF format - after all, Microsoft Dynamics GP does not save files in native PDF format like say, Word or Excel. At the end of writing the file, but before outputing the report to screen, the default printer is not being re-established.

Given the number of printer related posts on the forums lately and the responses by Microsoft staff, it seems this has been identified (along with a few more issues) as part of a list of upcoming fixes - but just in case, I am writing about it today.

Until next post!

MG.-
Mariano Gomez, MVP
IntellPartners, LLC
http://www.IntellPartners.com/

Tuesday, October 4, 2011

Come join me at GPUG Academy and Summit in November

This is it folks! If you haven't registered for the GPUG Academy training classes or the GPUG Summit, you are running out of time!

This year's events will take place at the majestic Caesars Palace hotel in Las Vegas, Nevada, U.S.A. from November 7 through November 11 and I will be delivering some training and presenting at both events as well.

The following is my schedule:




Training Schedule

Leveraging Drill-Down Builder and Navigation List Builder in GP 2010
Monday, November 7, 2011 - 1:00 PM - 5:00 PM PST

This will be a very exciting class for beginners showing some of the capabilities of the SmartList Builder extended family.

Microsoft Dynamics GP 2010 Data Migration and Integration Techniques
Tuesday, November 8, 2011 - 8:00 AM - 5:00 PM PST

Don’t miss this in-depth walk through of the considerations and techniques needed to ensure a successful data migration or integration from any system to Microsoft Dynamics GP. In the process, you will learn about the tools available from Microsoft and ISVs to complete your migration or integration project. This class is oriented to beginners.

Remember: GPUG Academy classes have the added incentive of CPE credits.


Summit Schedule

Where do the Experts turn for answers
Thursday, November 10, 2011 - 3:00 PM - 4:00 PM PST

If you ever want to know where people like me turn for help then this session is for you. Come to this highly interactive session that uncovers some of the secrets used by MVPs and Community experts looking for information on everything Dynamics GP... and more! This session is for all levels.

Administering Microsoft Dynamics GP like a pro with the Support Debugging Tool
Friday, November 11, 2011 - 8:00 AM- 9:00 AM PST
 
This session features David Musgrave, the architect and developer of the Support Debugging Tool live from Australia. MVP Mark Polino and I will be assisting David from the stage and taking questions from the audience.
 
Ask the Experts: Microsoft Dynamics GP Development Tools
Friday, November 11, 2011 - 1:30 PM - 2:30 PM PST

Come to this very educational session on Microsoft Dynamics GP Development Tools and get a primer on what the tools are and how to select the right tool for the right job. I will contrast the tools and provide some insight up close and personal. This session is for beginners and intermediate level users.

I hope to see as many of you as possible. If you haven't registered please visit the GPUG site for registration and classes information at http://www.gpug.com/.

Until next post!

MG.-
Mariano Gomez, MVP
IntellPartners, LLC



Monday, October 3, 2011

Congrats to MVPs Mark Polino and Siva Venkataraman!

Mark Polino and Siva Venkataraman received news from Microsoft over the weekend that they will, once, more hold the Microsoft Most Valuable Professional award for another year.

Please join me in extending my sincere congratulations to these gentlemen who work tirelessly for the Microsoft Dynamics GP community.

MG.-
Mariano Gomez, MVP
IntellPartners, LLC
http://www.IntellPartners.com/