Page 1 of 12112345678910...2025303540...Last »

#GPPT What’s New: Run C# and VB.Net scripts with .Net Execute

David Meego - Click for blog homepageThe Support Debugging Tool already has the ability to create and execute Dexterity sanScript and Transact-SQL scripts, without needing the Dexterity development environment or SQL Server Management Studio installed.

Now GP Power Tools adds the ability to create and execute Visual C# scripts and Visual Basic.Net scripts, without needing Visual Studio installed.

Welcome to the new .Net Execute window. Developed with the assistance of my friend Andrew Dean from Envisage Software Solutions in Sydney, the .Net Execute window allows developers with a Visual Studio and Visual Studio Tools for Microsoft Dynamics GP background to write and execute .Net scripts inside Dynamics GP.

Net Execute

When you select a script language, a template script is automatically generated in that language including the appropriate using or Imports statements. The system also adds the references to the appropriate DLLs. You can click on the References button to add additional references for other Dynamics GP dictionaries or other system or custom features.

 Net Execute References

The script editor window provides all the standard features, such as the Insert button for inserting code constructs, the Helper button for adding calls to Helper functions, the Names button for looking up and inserting dictionary resources as well as the Script menu with find, replace and syntax checking.

Using the Helper functions it is possible to create or load scripts written in Dexterity, SQL or either of the .Net languages and execute them. This allows you to write scripts in any combination of the four languages regardless of what the base language is.

Support for Visual C# and Visual Basic.Net is provided by the two addins installed with GP Power Tools. The Visual C# extension addin providing support for Visual C# scripts and the Visual Basic.Net extension addin providing support for Visual Basic.Net. These addins DLLs must be installed for the functionality to be available.

Finally, the Visual Basic.Net extension addin also provides an additional feature in the Runtime Execute window: Dexterity sanScript code can be executed in the context of a modified form, rather than the original form, and so read and write to Modifier added local fields.

Enjoy

David

This article was originally posted on http://www.winthropdc.com/blog.

Filed under: 2010, 2013, 2013 R2, 2015, 2015 R2, Dynamics, GP, GP Power Tools, Microsoft, Products Tagged: GP 2010, GP 2013, GP 2015, GP Power Tools, GPPT

Read More:
#GPPT What’s New: Run C# and VB.Net scripts with .Net Execute

August 2, 2015 · WinthropDC · No Comments
Tags: , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 15

Microsoft Windows 10 is almost here

David Meego - Click for blog homepageIt is already the 29th July 2015 in Australia and Windows 10 is almost here.

I know that because it is already downloading into a hidden C:$Windows.~BT folder onto my machines.

Now one question that many people are asking is “Can I do the free upgrade as a clean install if I have downloaded the ISO image?

The short answer is No.

The long answer is ….

Can I perform a clean install using the Free upgrade?

No, it will require that you are running a previous qualifying version and start the upgrade from within the qualifying version. You can initiate a clean install after completing the Upgrade.

Please be aware that you cannot use the free upgrade offer to perform a clean install on first attempt. You must first upgrade from the qualifying version of Windows 7 or Windows 8/8.1 (whether you do it through Windows Update or using the .ISO file). Ensure the upgrade is completed successfully and then ensure that it is activated. You can then proceed to do a clean install by using recovery media or using the Reset function in Start > Settings > Update & Security > Recovery > Reset this PC (Get Started).

For more information on all your Windows 10 questions, please see the following article:

Enjoy

David

This article was originally posted on http://www.winthropdc.com/blog.

Filed under: Microsoft, News, Public Service Announcement, Windows Tagged: General, News, Windows, Windows 10

Link:
Microsoft Windows 10 is almost here

July 28, 2015 · WinthropDC · No Comments
Tags: , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 23

GP2015 R2 Upgrade – GP Utilities “SynchronizeTableData()” Error & Fix

This issue has already been reported and it’s also been addressed. I would like to post this still. To act more like a pointer. It’s quite crucial in nature.

I have been testing GP2015 R2 upgrade on my test environment when I faced the following error message:

Screen Shot 2015-07-27 at 6.10.32 PM

Quite evidently, upgrade didn’t go through after. I remembered this being posted on our GP Support & Services blog. Dug the post and got the solution.

Here’s the post: Known Upgrade Issues When Upgrading To Microsoft Dynamics GP 2015 R2

Please note that this has been fixed already and is available with June 2015 Update.

Vaidy

Filed under: #MSDYNGP, GP 2015 R2, GP Utilities, GP2015, GP2015R2, Upgrade

More here:
GP2015 R2 Upgrade – GP Utilities “SynchronizeTableData()” Error & Fix

July 27, 2015 · Vaidyanathan Mohan · No Comments
Tags: , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 20

Bank Deposit Slip from Dynamics GP.

I want to document one of forgotten feature in Dynamics GP i.e. printing Bank Deposit Slip from Dynamics GP.

User can print Bank Deposit Slip right from Dynamics GP.

Goto–&gtTransactions–>Financial–> Bank Deposits

































Select your transactions–>Click on Print button to print Deposit Slip.





Depend on yours transactions report has all details – Checks #, Cash Details etc . User can take this form to Bank.

I have updated this forms as per customers bank preprinted format.

Thanks much for reading !!!



Until Next Post!!!

View original post here:
Bank Deposit Slip from Dynamics GP.

July 14, 2015 · Sandip Jadhav · No Comments
Tags: , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 40

Dynamics GP SQL Password – Something Interesting must test it !!!

Dynamics GP – SQL Password.
While working one of my colleague here I found something unusual in Dynamics GP2013 R2 and even GP2015 R2.

We have asked our IT department to create VM with SQL server. They have installed SQL server with ‘sa’ password ‘sql2k12@myowncompany’.

When we were trying to install GP. Utilities ran successfully with ‘sa’ user id and above password, we was able to create Production Company through Dynamics GP utilities but not able to login to Dynamics GP.

Spend almost 2 days to see why we are not able to Login GP. Asked IT team to reformatted server reinstalled SQL but again they given same ‘sql2k12@myowncompany’ password.  Again same story able to login GP Utility but not able to login GP. DYNSA user ID and password is working. Even we have checked all other security screen in Dynamics GP and log file was not showing any error.

Somehow I saw GP user login screen not taking password more than 15 character….!!! Whereas I can type password more than 15 characters in GP utility…!!! We got issue.

Now question is how come Dynamics GP Utility allow to enter password more than 15 character and GP Login screen user password restricted to 15 characters only.


Until Next Post!!!

Read the article:
Dynamics GP SQL Password – Something Interesting must test it !!!

July 13, 2015 · Sandip Jadhav · No Comments
Tags: , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 36

#GPPT Installing the GP Power Tools Public Beta

David Meego - Click for blog homepageNow that the GP Power Tools Public Beta is out there, I know that people will not read the user guide documentation (GPPTools.pdf).

So I thought it would be worth while mentioning some guidelines to make the install as smooth as possible.

Firstly, let’s discuss the contents of the downloaded archive file. The archive contains the following files:

  • GPPTools.cnk

This is the self-installing dictionary containing the Dexterity code for GP Power Tools.

  • Debugger.cnk

This is a self-installing dictionary used for migration from the Support Debugging Tool. It is almost identical to GPPTools.cnk but uses the Debugger.* filenames.

This is required when the Debugger.dic file is already installed as extracting a chunk file will not update the launch file if it already exists. So this will overwrite the old dictionary file and then update the launch file to have the new names for the product and files. When Dynamics GP is restarted, everything now points to the new GPPTools.dic and the code removes Debugger.* files.

Only install this file if the Support Debugging Tool is already in the launch file.

  • GPPTools.txt

This is the read me file which version history information. Installation is optional.

  • GPPTools.pdf

This is the user guide for GP Power Tools. It must be installed if you want the application help system to be able to open the file.

  • License.doc

This is the license agreement for GP Power Tools which you accept by using the product. Installation is optional.

  • Application.GpPowerTools.dll

This is the signed Dictionary Assembly for the GP Power Tools Dexterity dictionary.

  • Application.GpPowerTools.xml

This is the IntelliSense data for Visual Studio for the GP Power Tools Dexterity dictionary.

  • Application.GpPowerTools.Metadata.dll

This is the signed Dictionary Assembly for the GP Power Tools Service Enabled Procedures. For version 14.0 or later.

  • Application.GpPowerTools.Metadata.xml

This is the IntelliSense data for Visual Studio for the GP Power Tools Service Enabled Procedures. For version 14.0 or later.

  • Addins/WinthropDC.GpPowerToolsVC.dll

This addin dll adds Visual C# support to GP Power Tools. Removal will disable the ability to execute Visual C# scripts.

  • Addins/WinthropDC.GpPowerToolsVB.dll

This addin dll adds Visual Basic.Net support to GP Power Tools. Removal will disable the ability to execute Visual Basic.Net scripts and execute Dexterity sanScript against modified dictionaries.

 

Use the following steps will install GP Power Tools:

  1. Copy the files to the Microsoft Dynamics GP application folder and the two dlls to the Addins folder.
  2. For the dll files, right click and select Properties and click the Unblock button if it is shown on the bottom of the first tab.
  3. Launch Microsoft Dynamics GP using Run as Administrator.
  4. If asked to restart after launch file changed, go back to step 3.
  5. Log into Microsoft Dynamics GP using a user ID with system administrator or DBO privileges, such as ‘sa’ or ‘DYNSA’.
  6. GP Power Tools will create its tables and read in the Debugger.xml file if upgrading from the Support Debugging Tool.
  7. You will be asked to assign security to all users, recommended to respond Yes.
  8. You will be reminded to manually assign security to the administrator level users.

Once installed, GP Power Tools can be accessed from the Application and window level Tools menus, the GP Power Tools area page as well as from the GP Power Tools sub menu on the application menus.

Disclaimer: As with all beta code, it is provided “as is” and you use it at your own risk.

If you receive errors from the two Addin dlls, they can be removed to avoid the errors. However the Visual C# and Visual Basic.Net functionality they provide will not be available. Please let me know if you have this issue.

Enjoy the beta and please provide feedback as comments on this post and via the survey built into GP Power Tools.

David

This article was originally posted on http://www.winthropdc.com/blog.

Filed under: 2010, 2013, 2013 R2, 2015, 2015 R2, Dynamics, GP, GP Power Tools, Microsoft, Products, Support Debugging Tool Tagged: Beta, GP 2010, GP 2013, GP 2015, GP Power Tools, GPPT

Read More:
#GPPT Installing the GP Power Tools Public Beta

July 8, 2015 · WinthropDC · No Comments
Tags: , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 39

Error when trying to remove server roles in Dynamics CRM 2013

Error: Failure: The current user does not have required permissions (read/write) for the following Active Directory group: CN=ReportingGroup 94a899b0-954f-447d-86c9-7ac7bd0a081d,OU=CRM 2013,OU=Applications,DC=corp,DC=erac,DC=com Cause: The user does not have the required permissions. Solution: Provide Full Control permission for the user running the setup.

Visit site:
Error when trying to remove server roles in Dynamics CRM 2013

July 7, 2015 · Niran Belliappa · No Comments
Tags: , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 29