Day: April 23, 2019

More Changes for VAT in Microsoft Dynamics GP April 2019 Hotfix

Ian Grieve2 minute read0 comment

Microsoft Dynamics GPSnuck out just before the Easter bank holidays was a new hotfix with some fixes in for the following in UK VAT:

  • To submit the file to HMRC you had to be logged into Microsoft Dynamics GP as user SA.
  • You may incorrectly receive an error in VAT Daybook Obligation period dates do not match with the VAT Daybook Calendar.
  • VAT submission changes required by HMRC.

The post on the Dynamics GP Support and Services Blog is here.

The hotfix is inclusive of the February hotfix changes and can be downloaded via these links:

Implementing SalesHQ Portal: Configure SQL Permissions

Ian Grieve3 minute read0 comment

SalesHQ PortalThis post is part of a series on Implementing SalesHQ Portal, which is one of the GP Elementz Portals from my new employer, ISC Software Solutions.

In the last post in this series, I installed the Connector Service; as part of the installation a database was created and populated with the required tables. The service account is granted access to these tables, but also needs to be granted the DYNGRP role in the Microsoft Dynamics GP system and company databases as well.

You can do this via SQL Server Management Studio. Expand Security and Logins, find the service account, right-click and select Properties.

Select User Mapping and the the system database (which in my example is called D18R2.

In the Database role membership… section, mark the checkbox next to DYNGRP:

Login Properties window showing DYNGRP on system database being assigned

Repeat this action for the company databases and then click OK to commit the changes.

This action is only required to be done for the Domain account which will run the connector service as this service handles all connections to the database, including those from the Dynamics GP client.