Perfect Image Are Recruiting for a Dynamics GP Consultant (Grade 3)

Perfect ImagePerfect Image have an opening for a Dynamics GP Consultant (Grade 3).

The position is for a full time position based in Newcastle upon Tyne in the North East of England, working on a growing team of consultants which includes the UK’s only Microsoft Most Valuable Professional for Microsoft Dynamics GP (and one of only two in Europe).

The full job specification is below and you can email me your CV to cv@nospam.azurecurve.co.uk (remove the nospam.).

The typically approach we have is that in the first instance I’ll review the CV and, if it shows the appropriate skills, I’ll conduct a quick phone call to confirm experience and system knowledge (no pressure), before we look to organise an in person interview with the relevant people at PI (HR Manager, the Director of Project Delivery and I) for anyone successful on the call.

Please only candidates who have not already applied via a recruiter and ABSOLUTELY NO RECRUITERS. If these rules aren’t abided by, I will immediately delete the CV.

Click to show/hide the full job specification

Job type
Full time
Salary
£30,000 to £45,000 p/a depending on skills and experience
Benefits
25 days annual leave plus bank holidays, profit and performance related bonus, occupational sick scheme, company pension scheme, career progression plan, cycle to work scheme, childcare voucher scheme.
Job summary

Perfect Image works with clients to define, implement and support IT systems which will help to make them more successful.  Our range of offerings cover bespoke web and Windows-based systems, the integration of existing and new systems, intranet, CRM, business intelligence and ERP systems.

The role of the Dynamics GP Consultant is pivotal to the success of our clients’ ERP projects and therefore to Perfect Image.  You will need to be a motivated, enthusiastic and have experience in supporting and implementing Dynamics GP. Ideally this will include upgrading Dynamics GP implementations to recent releases. This should also include experience of the financial and distribution modules.

The ideal candidate will also be able to demonstrate experience which includes initial pre-sales consultation with the clients, assisting with the creation of sales proposals, presentation and demonstration skills and the management of the resultant project through to a successful implementation.

The Dynamics GP consultant needs to be willing to learn, or have previous experience in, solutions that are complimentary to Dynamics GP, including SharePoint and Dynamics CRM. A proven track record in delivering customer care to diverse clients is a must.

Key responsibilities and accountabilities
  • To work with clients at all levels helping to shape business priorities and to determine the resultant requirements for an ERP solution.
  • Document business and systems requirements to the required level of detail and in an appropriate format.
  • To take on principal responsibility for pre-sales consulting in significant opportunities.
  • Support all elements of Dynamics GP implementations, including server and client installations, data migration exercises, system upgrades, trouble shooting issues as they arise, fixing data issues within a SQL environment, and report writing.
  • Providing a 3rd line support function, assisting our support department in resolving more complex customer enquiries.
  • Keep abreast of changes and opportunities in the technology marketing.

This is not exhaustive.

Job requirements
  • Experience in all aspects of ERP Consultancy, with existing Dynamics GP consultancy experience.
  • Good level of knowledge and experience with accountancy principals and practices.
  • Ability to support all elements of Dynamics GP implementations including server and client installs, data migration exercises, system upgrades, trouble shooting issues as they arise, fixing data issues within a SQL environment and report writing.
  • Experience in or hunger to learn new skills and technologies that compliment Dynamics GP and our clients, such as Dynamics CRM, SharePoint, Visual Basic, Job Costing / Construction Accounting.
  • A good level of IT and accounting knowledge and an ability to express this knowledge in terms appropriate to the audience which includes client senior executives, IT managers and end-users.
  • Ability to building strong relationships with clients, supporting income generation and securing repeat business.
  • Experience in managing implementation projects would be beneficial.
  • Ability to think clearly, and to write clear documentation which is sufficiently detailed, unambiguous and complete.
  • Ability to work under pressure and to tight deadlines.
  • Strong presentation skills.
  • Experience of the ERP core modules including Financials and ideally Distribution.
  • Strong skills in spoken and written English.
  • Proven ability to deliver results.
Qualifications

Education to degree level (or equivalent).

Personal profile
  • Is able to deal positively about ambiguity and complexity. Is positive in seeing a way through client problems and challenges.
  • Work well under pressure and will go the extra mile to provide excellent client service.
  • Understand that asking for help and input from others is a strength, not a weakness, so actively involves others.
  • Concern yourself principally with the development of the business of our clients and our firm.
  • Look to develop our consulting capability through recruitment, training, mentoring of our people and the development of our methods.
  • Facilitate cooperation within the consulting team and across the firm.
  • Start to develop a personal and social relationship with clients.

Update Setup Mistake On Inventory User Categories

Microsoft Dynamics GPWe implemented Microsoft Dynamics GP for a client a while ago; they are quite heavy users of the Inventory Control module.

Unfortunately, when they configured the User Categories in Inventory Control Setup (Inventory >> Setup >> Inventory Control) the description for the category was entered in the Image field instead of the Description field.

Rather than making them go through and manually change all of the categories that had been defined, I put together a small script to do the job.

The script checks if the length of the entry in the Image field is greater than zero and that the Description has not been set before doing the update.

UPDATE
	IV40600
SET
	UserCatLongDescr = Image_URL
	,Image_URL = ''
WHERE
	LEN(RTRIM(Image_URL)) > 0
 AND 
	LEN(RTRIM(UserCatLongDescr)) = 0
GO

As I was writing this script we encountered the same setup issue on a client installation we took over from another partner so this looks like it may be more common that I thought it would be; caused I think be the fact the window has the Image field visible by default and not the Description which people expect.

GP Power Tools Now Available

Winthrop DCWinthrop DC has now officially launched the GP Power Tools and which are available to purchase from Winthrop DC’s partner Mekorma.

The GP Power Tools includes all of the functionality of the old Support Debugging Tool that they replace, but have new functionality, enhancements and bug fixes.

There is a special introductory annual subscription price of US$365 (one free day every four years!).

More information can be found on the GP Power Tools here.

I am/was a Support Debugging Tool user; what now?


If you were a Support Debugging Tool user on Microsoft Dynamics GP 2010 or 2013 then absolutely nothing needs to change. SUpport Debugging Tool will not expire.

That said, you should consider upgrading to GP Power Tools for one major benefit: GP Power Tools is fully supported by Winthrop DC.

While this may not sound like much, the old Support Debugging Tool, which was offered by Microsoft, was not supported at all (not even by Microsoft).

Change Rate Calculation Method To Divide

Microsoft Dynamics GPThis is a script I hope not to need in future, but as I have had to write it, I figured I might as well post it.

When creating an exchange rate table in Multicurrency Exchange Rate Table Setup (Administration >> Setup >> System >> Exchange Table)several fields need to be defined. One of them is the Rate Calculation Method which is set to either Divide or Multiply.

This field can be changed until there are rates entered. The reason this script was created was for a client who create several currencies, entered quite a few rates and then realised that the flag for Rate Calculation Method was set to Multiply instead of Divide.

The choices were either to delete all rates or to change the data behind the scenes; the script took five minutes to write and test, whereas doing the update manually would have taken near an hour.

So script it was. Before I ran the update, I double checked to make sure there were no transactions and also that there was a good backup of the system database.

UPDATE
	MC40300
SET
	RTCLCMTD = 1
WHERE
	EXGTBLID IN ('USD','EURO')
GO

The yellow highlighted section is the list of currencies to update.

This script should NOT be run when transactions for the currency being updated have been entered.

Hands On With Microsoft Dynamics GP 2015 R2: Integration Manager First Run

Microsoft Dynamics GPMicrosoft Dynamics GP 2015 R2 was released at the end of May. As I mentioned at the time, I was away from home for work and rather busy otherwise so this series of posts has been somewhat delayed.

However, I am now getting my hands on GP 2015 R2 and thought I would do my usual set of posts on the installation of the various components and also the usage of the new functionality. This is going to be quite a long series of posts, so keep checking back regularly.

After Integration Manager has been installed on a client machine, the license key needs to be input. Do this by locating the Integration Manager icon on the Start screen, right-click it and select Run as Administrator.

When Integration Manager starts you will be prompted to register now or later; click on Register Now:

Integration Manager: Register Now or Later

Continue reading

Hands On With Microsoft Dynamics GP 2015 R2: Install Integration Manager

Microsoft Dynamics GPMicrosoft Dynamics GP 2015 R2 was released at the end of May. As I mentioned at the time, I was away from home for work and rather busy otherwise so this series of posts has been somewhat delayed.

However, I am now getting my hands on GP 2015 R2 and thought I would do my usual set of posts on the installation of the various components and also the usage of the new functionality. This is going to be quite a long series of posts, so keep checking back regularly.

Integration Manager is a tool which is very useful during an implementation and is also on an ongoing basis for integrating files from other systems or third parties. It is also a very simple install.

To install Integration Manager, run the setup.exe from the downloaded installation media. Under Additional Products click on Integration Manager:

Microsoft Dynamics GP 2015 setup utility

Continue reading

Hands On With Microsoft Dynamics GP 2015 R2: Web Services Verification

Microsoft Dynamics GPMicrosoft Dynamics GP 2015 R2 was released at the end of May. As I mentioned at the time, I was away from home for work and rather busy otherwise so this series of posts has been somewhat delayed.

However, I am now getting my hands on GP 2015 R2 and thought I would do my usual set of posts on the installation of the various components and also the usage of the new functionality. This is going to be quite a long series of posts, so keep checking back regularly.

Once the Web Services have been installed and configured, it is recommend that they be verified to ensure everything is working as it should. There are four items which need to be checked.

Firstly, open the Services Control Panel applet (easiest to do by hitting Win+R and typing services.msc; scroll down and find Microsoft Dynamics GP Service Host. Ensure it is running and set to Automatic:

Services

Continue reading

Hands On With Microsoft Dynamics GP 2015 R2: Web Services Configuration

Microsoft Dynamics GPMicrosoft Dynamics GP 2015 R2 was released at the end of May. As I mentioned at the time, I was away from home for work and rather busy otherwise so this series of posts has been somewhat delayed.

However, I am now getting my hands on GP 2015 R2 and thought I would do my usual set of posts on the installation of the various components and also the usage of the new functionality. This is going to be quite a long series of posts, so keep checking back regularly.

With the web services installed, the next step is to configure them for the companies being used. Do this by launching the Web Services Configuration Wizard from the Start screen.

On the Welcome screen, click Next:

Web Services for Microsoft Dynamics GP Configuration Wizard: Welcome

Continue reading

Hands On With Microsoft Dynamics GP 2015 R2: Install Web Services

Microsoft Dynamics GPMicrosoft Dynamics GP 2015 R2 was released at the end of May. As I mentioned at the time, I was away from home for work and rather busy otherwise so this series of posts has been somewhat delayed.

However, I am now getting my hands on GP 2015 R2 and thought I would do my usual set of posts on the installation of the various components and also the usage of the new functionality. This is going to be quite a long series of posts, so keep checking back regularly.

In the past, we used the Web Services for Microsoft Dynamics GP mainly for integration, but since Microsoft Dynamics GP 2013 R2 introduced Workflow 2.0 we have been installing it for more and more clients.

In this, the fifteenth post of the Hands on with Microsoft Dynamics GP 2015 R2 series, I’m going to step through the installation process and following it up in the next couple of posts with the configuration and verification of the installation.

To install the Web Services for Microsoft Dynamics GP launch the setup.exe from the downloaded installation media and, under Additional Products click Web Services Runtime:

Microsoft Dynamics GP setup utility

Continue reading

Hands On With Microsoft Dynamics GP 2015 R2: Create Company Using GP PowerShell

Microsoft Dynamics GPMicrosoft Dynamics GP 2015 R2 was released at the end of May. As I mentioned at the time, I was away from home for work and rather busy otherwise so this series of posts has been somewhat delayed.

However, I am now getting my hands on GP 2015 R2 and thought I would do my usual set of posts on the installation of the various components and also the usage of the new functionality. This is going to be quite a long series of posts, so keep checking back regularly.

Microsoft Dynamics GP 2015 R2 saw the introduction of some additional PowerShell cmdlets. I thought it might be useful to select one of the new cmdlets and give a run through of using it.

One of the tasks I often do a lot of is creating new companies so I have selected the Add-CompanyDatabase cmdlet.

To run any of the cmdlets, launch GP PowerShell from the Start screen.

The easiest way of finding out the parameters to use is to enter the following command:

Get-Help Add-CompanyDatabase

Get-Help Add-CompanyDatabase

This will display the details of the cmdlet including the Synopsis, Syntax, Description, Related Links and Remarks.

Continue reading