Error Creating A New Company: Cannot Insert Duplicate Key In Object ‘dbo.SY60100’

● Ian Grieve ●  ● 0 Comments   ● 

Microsoft Dynamics GPOne of our clients was creating a new company recently when GP Utilities produced an error:

Microsoft Dynamics GP: Cannot insert duplicate key in object 'dbo.SY60100'

Microsoft Dynamics GP

[Microsoft][SQL Server Native Client 11.0]p[SQL Server]Violation of PRIMARY KEY constraint 'PKSY60100'. Cannot insert duplicate key in object 'dbo.SY60100'. The duplicate key value is (sa, 114).

The client clicked the OK button and GP Utilities ran through to completion. However, when the user logged into Microsoft Dynamics GP using the sa account, the company was not available for selection.

This is when they called us asking for help.

When we connected in we found that the company did have a record in Company Master (SY01500), but did not have an entry in User-Company Access (SY60100).

The company was listed in the Delete Company window (Administration >> Utilities >> Delete Company). However when the company was deleted, the database remained behind.

I’ve had problems deleting databases this way before, so when I was called over, I directed my colleague to delete the database directly in SQL Server Management Studio and run the Clear Companies script available in Microsoft KB 855361.

A quick search for the error message, revealed a Microsoft Knowledge Base article covering this exact issue.

At some point, the system database’s owner had been changed away from DYNSA. Running the following script set the owner back to DYNSA, allowing the company to be created:

sp_changedbowner 'DYNSA'
● Categories: Dynamics, GP, GP Utilities, Microsoft ● Tags: , , , ,  ● Permalink ● Shortlink ●

Manually Activating Windows 10 Enterprise

● Ian Grieve ●  ● 0 Comments   ● 

Windows 10One of the perks of being a Microsoft Most Valuable Professional (MVP) is the fee MSDN VisualStudio account. This gives access to pretty much all of Microsoft’s software for development and testing purposes.

The main pieces of software I use is Windows and SQL Server. Usually when writing blog posts about Microsoft Dynamics GP, I use Windows 2012 or 2012 R2, but occasionally I create a Windows client machine with Windows 10.

Usually these machines don’t last long enough to need registering, but I have lately been working on one or two projects which required a somewhat longer life than the free registration period. For Windows Server, this isn’t a problem as the server version of Windows registers online without problems. However, registering Windows 10 Enterprise is not so simple, as the Enterprise editions of Windows requires a Key Management Server to successfully register.

I have never configured one of these as my installations for development and testing are usually fleeting. Instead, there are a couple of commands which can be run which will allow Windows 10 Enterprise to be registered online.

The first command is where you install the KMS key:

slmgr.vbs /ipk {Windows 10 Enterprise Key}

slmgr.vbs /ipk {Windows 10 Enterprise Key}

Once installed, a confirmation dialog is displayed:

Installed product key successfully

Then you run another command which activates Windows online:

slmgr.vbs /ato

slmgr.vbs /ato

If activation is successful, a confirmation dialog will be displayed:

Windows 10 Enterprise will now be registered and will continue working as normal.

Further details are available from TechNet.

● Categories: Microsoft, Windows, Windows 10 ● Tags: , , ,  ● Permalink ● Shortlink ●

Workflow Email Action Request Error After Approval

● Ian Grieve ●  ● 0 Comments   ● 

Microsoft Dynamics GPA client who had recently upgraded to Microsoft Dynamics GP 2016 reported an error when approving a purchase order via Workflow 2.0 Email Actions. The user would click Approve on the email, enter their comment and click Approve and then received the following message:

Workflow Email Action Request Error

Request Error

The server encountered an error processing the request. See server logs for more details.

The purchase order was showing as approved, so Workflow itself was working correctly from this point of view and I couldn’t find any logs which might explain the issue.

However, while I was having a look at the workflow setup, I noticed that the Purchase Order Approval workflow type, did not have a manager set. There had been a workflow manager defined or the workflow process could not have been activated, but at some point it disappeared.

Adding a manager for the workflow type, saw the error message stop appearing.

The manager’s disappearance could be related to the upgrade, but I’ve upgraded some other clients who were using workflow and not had his same problem.

● Categories: Dynamics, GP, Microsoft, Workflow ● Tags: , , , , ,  ● Permalink ● Shortlink ●

MS Connect Suggestion: Allow Workflow Steps to Have Multiple Parents

● Ian Grieve ●  ● 0 Comments   ● 

Microsoft Dynamics GPI have another Workflow related MS Connect Suggestion I’d like you to vote for.

I have worked on a number of projects for clients implementing Workflow 2.0 where being able to set one step with multiple parents would greatly reduce the work involved in creating the workflow.

For example I have recently worked with a client who has a Function segment in the chart of accounts, which requires approval by the Function Approver, which is a different person for each Function, and then a second level of approval by a Finance Panel, which is always the same five people.

When we create the workflow for POs we need to create forty Steps, one for each Function with it’s set of approvers, and then forty Finance Panel Approval Steps after each of the Function approval steps.

For example:

Step for Function = "IT"
	followed by a Finance Panel approval step.
Step for Function = "HR"
	followed by a Finance Panel approval step.
Step for Function = "TRAINING"
	followed by a Finance Panel approval step.
Step for Function = "SALES"
	followed by a Finance Panel approval step.
Step for Function = "ADMIN"
	followed by a Finance Panel approval step.
Step for Function = "OPERATIONS"
	followed by a Finance Panel approval step.

If we could define the Finance Panel step and assign it to follow multiple steps instead of only the one parent which can be assigned at the moment, it would save so much time and effort when creating and maintaining the workflow.

You can vote on the suggestion here.

● Categories: Dynamics, GP, Microsoft, Microsoft Connect, Workflow ● Tags: , , , , , ,  ● Permalink ● Shortlink ●

Management Reporter Fact Check

● Ian Grieve ●  ● 0 Comments   ● 

Microsoft Dynamics GPFollowing the announcement by Microsoft back in June last year of a partnership with Jet Reports, the future of Management Reporter has been a topic of conversation amongst the community with rumours constantly swirling that Management Reporter would disappear from the Microsoft Dynamics GP space.

On the Inside Microsoft Dynamics GP team blog, Pam Misialek has posted a Management Reporter Fact Check:

  • Management Reporter is available and fully supported by Microsoft. It is still included in the Starter Pack and will continue to be.
  • Management Reporter will ship with GP Next later this calendar year and will ship in future releases as well.
  • Microsoft are looking for any feature enhancements ideas which can be added to the product.
  • HTTP support was added for Microsoft Dynamics GP 2016 R2
  • Management Reporter will not go fully to the cloud in a multi-tenant environment. It can be used in the cloud, with a RDP connection.

Management Reporter is technically a separate product because it works across all Dynamics products. So what? Who cares? It works great at creating financial statements.

● Categories: Dynamics, GP, Management Reporter, Microsoft ● Tags: , , , , ,  ● Permalink ● Shortlink ●

MS Connect Suggestion: Allow Parenthesis in Workflow Step Conditions

● Ian Grieve ●  ● 0 Comments   ● 

MS Connect Suggestion: Allow Parenthesis in Workflow Step Conditions

Microsoft Dynamics GPI have a Workflow related MS Connect Suggestion I’d like you to vote for.

I would like to request the facility to use parenthesis in Workflow Step Conditions in order to simplfy the creation of the conditions.

For example, currently a condition may need to be entered as:
VendorClass = “EU” and ItemClass = “IT” and CostCentre = “NEWCASTLE”
or
VendorClass = “EU” and ItemClass = “IT” and CostCentre = “LONDON”
or
VendorClass = “EU” and ItemClass = “IT” and CostCentre = “EDINBURGH”

And that is with only an or clause on one of the parameters. I might have 6 VendorClasses and 20 ItemClasses; it gets real big, real quick.

If parenthesis could be used, as in a mathematical equation, I could enter the condition as:
VendorClass = “EU” and ItemClass = “IT” and (CostCentre = “NEWCASTLE” or CostCentre = “LONDON” or CostCentre = “EDINBURGH”)

This would shrink the amount of work required to create anything but the simplest of workflow processes enormously.

You can vote on the suggestion here

● Categories: Dynamics, GP, Microsoft, Microsoft Connect, Workflow ● Tags: , , , , , ,  ● Permalink ● Shortlink ●

MS Connect Suggestion: Make User Preferences Shortcut Bar Entry Available to All users

● Ian Grieve ●  ● 0 Comments   ● 

Microsoft Dynamics GPThis MS Connect suggestion has come from Belinda Allen.

Microsoft Dynamics GP users who use either the traditional desktop client or the web client when logged in as SQL user see the User Preferences shortcut on the Dynamics GP home page.

However users logged in using an Azure AD account, do not see the shortcut for User Preferences.

Belinda is asking Microsoft to make this shortcut available to all users.

You can read and vote on the suggestion here.

● Categories: Dynamics, GP, Microsoft, Web Client ● Tags: , , , ,  ● Permalink ● Shortlink ●

Management Reporter 2012 CU16 Now Available

● Ian Grieve ●  ● 0 Comments   ● 

Microsoft Dynamics GPThe Dynamics CPM Team has recently announced the release of Cumulative Update 16 for Management Reporter 2012.

The big new feature in this CU, is HTTPS support which was announced as a new feature alongside Microsoft Dynamics GP 2016 R2.

Vaidy Mohan has posted an article on the functionality for Microsoft Dynamics GP.

● Categories: GP, Management Reporter, Microsoft ● Tags: , , , , , ,  ● Permalink ● Shortlink ●

MS Connect Suggestion: Include Multicurrency Vouchers in Select Checks Window

● Ian Grieve ●  ● 1 Comment   ● 

Microsoft Dynamics GPThis suggestion is one from MVP Mariano Gomez to improve the payment run process by allowing multicurrency invoices to be included.

Currently, the payment selection process only allows vouchers issued in the batch currency to be selected and added to the check run. If the user wants to add foreign currency vouchers, he/she needs to use the Edit Checks window to add such vouchers. It would be nice to be able to have an option to include functional currency vouchers in the case of a foreign currency batch, or foreign currency vouchers in the case of a functional currency batch.

This is the use case:

Vendor A Invoice 1 CA$10.00
Vendor A Invoice 2 US$20.00
Vendor A Invoice 3 US$30.00

If a payment selection is performed and the batch currency is CA$, only the first voucher will be selected. To add Invoice 2 and 3, you would have to use the Edit Checks window to include both vouchers.

Conversely, if the batch currency is US$ and the payment selection for vendor A is performed, only invoices 2 and 3 would be selected and you would have to use the Edit Checks window to include Invoice 1.

What Mariano would like to see is all invoices selected (based on selection rules) and let the user deal with the exceptions, as it should be.

As mentioned, all the logic is already there via the Edit Checks window and it would be nice to incorporate as part of the payment selection process. As others have mentioned, having multicurrency vouchers included could be a payables configuration item or simply an additional option in the Select Payments (Select Checks) window.

Mark Polino has also suggested that this functionality be optioned with Rod O’Connor further suggesting the option be on the Select Checks window itself to allow maximum flexibility. Both of these seem like a good addition to Mariano’s idea.

The suggestion can be voted on here.

● Categories: Dynamics, GP, Microsoft, Microsoft Connect ● Tags: , , , , , , , , , , ,  ● Permalink ● Shortlink ●

How To Find Out What SQL Features Are Installed

● Ian Grieve ●  ● 1 Comment   ● 

Microsoft SQL ServerNo day when you learn something new is a wasted day. I was onsite with a client recently to do some work with them on Microsoft Dynamics GP and got chatting to Den in their IT department.

It turns out that SQL Server has a report you can run which will show which features are installed.

The report is run from the SQL Server Installation Center which is available from the Windows Start menu. Click on Tools and then on Installed SQL Server features discovery report:

SQL Server Installation Center

Continue reading → How To Find Out What SQL Features Are Installed

● Categories: Microsoft, SQL Server ● Tags: , , ,  ● Permalink ● Shortlink ●