POWERUSER Removed From ‘sa’; No Other User With Security Access

Microsoft Dynamics GPOne of the project managers was doing some testing for a development project recently and accidentally changed the security for the ‘sa’ account; they removed the ‘POWERUSER’ role (which gives global access to Microsoft Dynamics GP. In its place, they assigned the AP CLERK role.

What made this a major issue, was that the development system only had one company and this left the system with no users with access to the security windows.

They made the mistake by selecting the sa account instead of the sam account. Unfortunately, it was only after logging out as sa and back in as sam that they realised what they had done.

Fortunately, this isn’t actually too complext to fix, although it does require some SQL.

The sa account needed to be added back into the Security Assignment User Role (SY10500) table. I used a very simple script for fixing the development system, but have then tidied it up a little to post here.

This script adds POWERUSER back to the sa account for all companies and needs to be run against the system database (typically called DYNAMCIS:

/*
Created by Ian Grieve of azurecurve|Ramblings of a Dynamics GP Consultant (http://www.azurecurve.co.uk)
This code is licensed under the Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International (CC BY-NC-SA 4.0 Int).
*/
INSERT INTO SY10500
	(USERID,CMPANYID,SECURITYROLEID)
--VALUES
	(
	SELECT
		'sa',CMPANYID,'POWERUSER'
	FROM
		SY01500 AS ['Company Master']
	WHERE
		(
		SELECT
			COUNT(*)
		FROM
			SY10500 AS ['Security Assignment User Role']
		WHERE
			['Security Assignment User Role'].CMPANYID = ['Company Master'].CMPANYID
		AND
			['Security Assignment User Role'].USERID = 'sa'
		) = 0
	)
GO

Before running, please make sure you are happy with what the script will do and have a good backup of your system database.

Expiration Dates on Exchange Rates

Microsoft Dynamics GPI’ve been doing some work with a US-based company as they implement Microsoft Dynamics GP in Europe for one of their subsidiaries (we do a fair bit of this type of work for expertise with VAT and Intrastat). One of the issues they asked for assistance with was a problem they had while importing transactions.

All of the transactions which were in the functional currency, imported without a problem, but all of those in other currencies failed.

The cause of the problem was actually quite a simple one, and one I have seen before with other clients. On the Multicurrency Exchange Rate Maintenance window, there is an Expiration date field:

Multicurrency Exchange Rate Maintenance

Continue reading “Expiration Dates on Exchange Rates”

Configuring Workflow to use Gmail for Email Notifications

Microsoft Dynamics GPI’ve done a lot of work around the Microsoft Dynamics GP Workflow module and have configured Email Notifications to work with numerous different SMTP servers. One recent one we configured was Gmail.

This was not actually as straightforward as configuring other SMTP servers as the details Google publish are not accurate in that the port they list for SSL is not the correct one.

The settings required are below:

Workflow Setup

Continue reading “Configuring Workflow to use Gmail for Email Notifications”

Fix Windows 10 Lock Screen Not Changing

WindowsI have my PCs all set to share settings via OneDrive; I like this as it means I have a unifed theme everywhere, but when a problem occurs, it occurs everywhere.

his particular issue, is that I use Windows Spotlight for images on the lock screen and it became stuck on one image a while ago. After recently installing a new PC and having them same problem there as on other machines, I finally decided to fix the issue.

This was a fairly straightforward fix for me, but others report various fixes not working.

I found the fix which worked for me on Driver Easy and am reposting here, so I can easily find it again in future if necessary.

To fix the issue by re-registering Windows Spotlight, perform the following steps:

Use Run As Administrator to launch Command Prompt, click Yes when prompted by UAC (User Account Control) and type the following command:

dism /online /cleanup-image /restorehealth

Press Enter and wait for the command to run; this might take a few minutes to complete:

Command Prompt: dism /online /cleanup-image /restorehealthdism /online /cleanup-image /restorehealth

In the Command Prompt window type the following:

sfc /scannow

Hit enter and wait for the command to complete:

Command Prompt: sfc /scannowsfc /scannow

Either type powershell or launch a PowerShell window and type the following:

Get-AppXPackage -AllUsers |Where-Object {$_.InstallLocation -like “*SystemApps*”} | Foreach {Add-AppxPackage -DisableDevelopmentMode -Register “$($_.InstallLocation)\AppXManifest.xml”}

Hit enter and wait for the PowerShell command to finish (this may take a while) and generate several errors which can be ignored:

PowerShellGet-AppXPackage -AllUsers |Where-Object {$_.InstallLocation -like “*SystemApps*”} | Foreach {Add-AppxPackage -DisableDevelopmentMode -Register “$($_.InstallLocation)\AppXManifest.xml”}

I’ve found I need to wait a few minutes for the fix to take effect, but I don;t need to do anything else before the Windows Spotlight image starts to change.

Error Configuring Web Services for Microsoft Dynamics GP 2018

Microsoft Dynamics GPI’ve seen this error at two different clients now when configuring Web Services for Microsoft Dynamics GP 2018:

A loader exception has occurred.
Loader Errors:
- System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'taRequesterWSDynamicsOnlineConfiguration1' in the database.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at Microsoft.Dynamics.InstallData.SqlObjectLoader.DoSqlFromResource(String resourceName)
   at Microsoft.Dynamics.GP.GPSystemWebServiceObjectLoader.PerformActionOnEConnectStoredProcedures(Action action)
   at Microsoft.Dynamics.InstallData.Loader.Process(String[] args)
ClientConnectionId:04c704d2-d12c-40f3-9ccc-1444c4b529d9
Error Number:2714,State:3,Class:16

Both clients have previously had the Web Services implemented so that they could use Email Actions for Workflow approval. The first client got the error while we were doing the initial installation and confguration of the Web Services for Microsoft Dynamics GP 2018 and the second got them when we did a redeploy of the Web Services on the test system after refreshing the databases, but hadn;t received the error during the initial installation and configuration.

Continue reading “Error Configuring Web Services for Microsoft Dynamics GP 2018”

Microsoft Dynamics GP 2013 R2 Out of Mainstream Support

Microsoft Dynamics GPMicrosoft Dynamics GP 2013 came out of mainstream support and into extended support as of 1oth April 2018; end of mainstream support means you will no longer get statutory updates such as the addition of the Invoice Receipt Date in the January 2017 hotfix which applied to the UK or year-end tax updates for the US and Canada.

I always recommend to client to look to upgrade every two to three years; the last few years have seen many improvements and additional new functionality added to Microsoft Dynamics GP (2013, 2013 R2, 2015, 2015 R2, 2016, 2016 R2 and 2018) as well as bug fixes.

By not upgrading regularly, you not only miss out on all of these fixes and new functionality, but you also make your eventual upgrade longer and more complex due to the number of versions which need to be upgraded through.

You can review the product lifecycle on the Microsoft Lifecycle Policy – Microsoft Dynamics GP page.

How to Schedule a Skype for Business Meeting

Microsoft Dynamics GPI’m posting this because it took me far longer to work out how to schedule a Skype for Business meeting than it should have done.

The reason it took so long to find out how to do this, was because I was looking in Skype for Business itself. I should have been looking in Outlook:

Continue reading “How to Schedule a Skype for Business Meeting”

Doc Attach Button in Notes Window Missing

Microsoft Dynamics GPAfter a clients system was upgraded a while ago from Microsoft Dynamics GP 2010 SP3 to Microsoft Dynamics GP 2018, we enabled the Document Attachment feature for the client to use. Unfortunately when showing the client how to use the feaute, we found that the Doc Attach button was missing (the red square is where the button should be):

Notes

Continue reading “Doc Attach Button in Notes Window Missing”

Debugging Integration Manager Crashes

Microsoft Dynamics GPWe’ve had two separate clients recently log calls where Integration Manager was crashing while performing an integration.

The first client was doing an Inventory Items integration on Microsoft Dynamics GP 2015 R2 and the other was doing a Sales Transaction integration on Microsoft Dynamics GP 2016 R2.

Both of the integrations had been running fine for quite a long period of time before starting to crash; no changes had been made to either system and I’ve not been able to determine why Integration Manager (IM) has started crashing.

However, by the use of two ini file switches, we were able to determine what error was being encountered by IM resulted in a crash.

The two switches are already present in the ini file (C:\Program Files (x86)\Microsoft Dynamics\Integration Manager nn/Microsoft.Dynamics.GP.IntegrationManager.ini by default) whre the False value needs to be changed to True:

[IMGPPrv]
ShowDynamics=False
DoUIRedraw=False

When these switches are set to True, the Microsoft Dynamics GP windows are not hidden when the integration runs.

We found that for the Inventory Items integration, accounts either didn’t exist, didn’t allow account entry or were inactive; for the Sales Transaction integration, Analytical Accounting (AA) had been enabled for one of the accounts and the integration didn’t handle AA.

I created a VB script for the Inventory Items integration to check the accounts in the Before Document script and cancel the document if the account was going to be a problem.

Access Windows Settings App Using ms-settings URIs

WindowsWindows 10 saw the introduction of a enw Settings app, which has been improved in every major update. The Settings app is a replacement for the old Control Panel, the applets of which could be accessed from either the command line or from the Run dialog.

The Settings app also allows you to directly open individual settings pages by using a URI. The list of URI’s below is for Windows 10 “Creators Update” (version 1704).

Not all dettings pages will be available in every SKU of Windows 10. The notes column details any additional requirements that must be met for a page to be available.

Continue reading “Access Windows Settings App Using ms-settings URIs”