In Touch with Dynamics GP

This blog is intended to be a useful resource for Microsoft Dynamics GP users and professionals in the UK and the wider Microsoft Dynamics GP community as a whole.

Monday, 21 December 2009

2010 EU Tax changes/update

As any of you who trade in Europe should know there are tax changes being brought in for 2010.

Simply put if you are trading/providing services in Europe (The EU) then you need to submit a sales listing along side your VAT100 report.

Microsoft have now released extra code to allow you to do this in the VAT daybook and Advanced intrastat modules.

You can use the below link to download the code for versions 9 and 10 :

If you have any questions please contact

Bug In FRx SP11 core code (Please do not install)

Service Pack 11 was recently pulled due to a core FRx bug found. The last update from Microsoft's Development is that it should be available for release in 4 weeks.
To roll back to SP9 you can follow KB 861724 "How to remove a Service Pack for FRx". The link is provided below. If you can not access the link please contact;en-us;861724

Wednesday, 16 December 2009

FRX and Windows 7

Hi Folks, a quick update to the whole windows 7 compatibility status. FRx 6.7 is now compatible with windows 7 as long as the recently released Service Pack 11 is installed.

for more information on SP11 for FRx 6.7 please contact the

Monday, 19 October 2009

Conference High Lights

As most of you are aware we had our client conference last week, a great chance to meet and greet some of our clients and catch up on the latest technologies and the Dynamics (GP) road map.

I think that most people would agree that one of the high lights was the sneak preview of some of the Dynamics (GP) version 11 features and the integrations with office 2010.
Our thanks to Tom and Will from Microsoft for these insights and especially to Will for the mind blowing insight into project Gemini.
Imagine being able to filter cut pivot millions of rows in excel full of GP data without any effect on performance, all achieved through a simple add in to excel. It will change the face of BI as we know it. As Will mentioned there are loads of demos of it out there on you tube so here is a link to a few.

Also the end would appear to be in sight for report writer, as we were shown the new word 2010 report templates allowing you to create professional looking reports in word linked to your dynamics Data and with unlimited numbers of templates per report type ( you could have 20 different invoice layouts if you wanted).

All the presentations from the day are available on request from the contact page of our web site

And I can not close off this blog without mentioning the lunch which was fantastic, a full on carvery with roast beef Yorkshire pudding , lamb , turkey all the trimmings and desserts to die for, fantastic.

Wednesday, 14 October 2009

Dynamics (GP) v8 is no more. Microsoft stopped support yesterday

For those of you still on Microsoft business solutions (Great Plains) version 8. Microsoft finished support for this version yesterday.

We however have not , if you are one of our clients and you are on version 8 or lower we will still support you. However you need to be aware that we will not be able to escalate issues to Microsoft for these versions or produce code fixes if required.

If you would like look into upgrading you to the latest release please contact

Tuesday, 13 October 2009

Integration Manager Dynamics (GP) V10 not pulling through fields

Hi folks , this one has cropped up in several support cases this week.

In version 10 Integration manager data is sometimes not being pulled through. This is usually when the destination field is down several sub levels in destination mapping.

A good example of this is the email field that is held under internet settings when integrating a debtor or creditor record.

We have found that although it is already mapped you just need to go into destination mapping and re add the source field. it will now bring through the data.

This is not immediately obvious when troubleshooting as the source field appears correctly mapped to start with.

If you have any questions please contact

Friday, 9 October 2009

Dynamics (GP) eConnect, web services and ISO Currency codes

When you set up econnect to use with web services you need to have all the ISO codes for your individual currencies in Dynamics (GP) populated.

These are setup on the currency maintenance window in Dynamics (GP).

There are two internationally recognised codes for each currency. An alphabetic and a numeric code. Please be aware you need to use the alphabetic code as the web services will not pass/recognise the numeric ones.

The below ISO website has the list of internationally recognised codes.

If you have any questions contact

Hurry Hurry hurry, Touchstone's Dynamics Client Conference is next week.

Our annual Dynamics Customer conference is next Thursday, its a great opportunity to catch up on the Dynamics product range and see what extra value you can get out of your Dynamics (GP) system.

Use the below link to sign up.

Dynamics (GP) v10, unsupported printers and small fonts.

We have had a couple of cases recently where after an upgrade to Dynamics (GP) v10 , the standard reports all print out in very small fonts.
This usually happens if you are using an unsupported printer. You can request a list of supported printers from .

There are a couple of workarounds you can use for this.

The first is to try different printer drivers for a supported printer from the same range. For example HP printer drivers a pretty well interchangeable. Select the nearest model number off of the supported printer list and down load the driver from the manufacturer’s website and try these.
Nine times out of ten this will work.

We have recently discovered there is a second option you can try. In the Dex.ini file on each workstation add in the following printer commands.

FontCourier New=Lucida Console

This forces the printer to take on the above font settings, however a quick word of warning, it does not work with all printers and print drivers as they don’t all support these settings and it may not alter the output of the report (In which case you will need to experiment with drivers).

If you have any questions contact

Report writer, calculations, functions and those pesky global fields in Dynamics (GP)

Anyone who has tried to add a global field (such as company name or companyID) into a function used in a calculated field within report writer for Dynamics (GP), has probably become very frustrated.
For some reason Report writer handles global fields differently. To make matters worse several of these fields are non string values and have integer data types so can not be used within concatenation functions.

Well there is a way round this and it is in essence very simple.

If we take the global field of CompanyID for example. This has a data type of INT5 (integer) and so can not be used in a concatenation in a calculated field. Therefore you need to use the INT_STR function in the calculated field to change its data type to string. However because it is a global field it won’t let you do this.

So to get round this simply create a calculated field with a result type of Integer and insert the global field of companyID. This has effectively created a calculated field with the same value as the global field.

Now because it is a Calculated field Report writer will treat it normally. This means you can now use the INT_STR function but instead of using the global field you use your new calculated field.

This technique will work for all those global fields and will allow you to include them in functions within report writer and with this technique you can add global fields into functions such as STRIP, CAT and INT_STR within Dynamics (GP).

Thanks to Jon Eastman (Touchstone Consultant) who came up with this handy hint.

If you have any questions please contact

Tuesday, 6 October 2009

Requested registry access is not allowed Error installing on Vista or Windows server 2008

As I am sure most of you are aware Security on the Vista and server 2008 operating systems is fundamentality different from xp and others that have gone before. This can cause issues when installing Dynamics (GP) products and code onto these environments.

Usually you will get an error message along the lines of “Requested registry access is not allowed” or permission denied error. When this happens you have two options.

The First option is to disable the User Account Control (UAC) feature for the duration of the install on the machine.

1.Click Start, type accounts in the Start Search box, and then click User Accounts in the Programs list.

2. Click Turn User Account Control on or off. If you are prompted for an administrator password or for confirmation, type the password, or provide confirmation.

3. Click to clear the Use User Account Control (UAC) to help protect your computer check box, and then click OK.

4. Restart the computer.

You can now install the code on the machine. Make sure that once you have installed the code , reset the UAC options and restart the machine again.

The Second option (and my preferred one) is to do it from the command line.

1. Open the command prompt (The command prompt is located in the Accessories group) as a user who has administrative permissions on the local computer. To do this, click Start, click All Programs, click Accessories, right-click Command Prompt, and then click Run as administrator.

2. Type the directory of the location where you copied the .msp or install file for the service pack, and then press ENTER.

3. To run the installation, type the following command, and then press ENTER:
Msiexec /p /l*v C:\MSPErrorlog.txt

Note In the command in step 3, is a placeholder for the name of the .msp or install file.

If you have any questions please contact

Friday, 2 October 2009

FRx Forecaster 7 , Roaming Profiles and Amazing Disappearing Database connections

This is a strange one and is not documented anywhere , in fact when we talked to Microsoft about this they had only seen it once before , so we thought it deserving of a blog post as this may save someone else a lot of time and effort.
This issue happens when you have Forecaster 7 installed in an environment using roaming profiles , in the case of our client they were also on terminal services but the same could be said for citrix.

The problem is, if you create connections to forecaster databases on a machine using roaming profiles, then when you log out and log back in to the machine they are gone and need to be recreated again.

The reason for this is that Forecaster 7 stores the connections on a user basis in an ini file by default in c:\Users\%username%\AppData\Local\Microsoft\Forecaster\ . This as you can see from the file path, is the users local folder not their roaming profile folder. So when the user logs back on, because roaming profiles are used the system checks the roaming profile folder and low and behold the connection details are not there.
There is no official resolution for this from Microsoft. The only option would appear to be to update the roaming profile from the local one. Our clients IT team came up with their own resolution and have set at bat file to run on login copying the details from the local folder to the roaming profile.

So in summary this is a fairly unique set of circumstances and will not affect the majority of clients however if you are using roaming profiles with forecaster you will need to consider this. Our thanks to Daniel Merchant (IT at our client’s site) who pin pointed this issue.

If you have any questions please send them to

Wednesday, 30 September 2009

Quick Lookup Ctrl L

I have just got out of a WEBEX session with one of our clients. For those of you who have not had the pleasure of WEBEX yet this is a desktop streaming technology we use to take over your workstation to assist with support call resolution.
Any way whilst looking up a debtor I used the quick look up short cut key stroke and the end user had never seen this before and was impressed with the speed and ease of use. It occurred to me that this is something that no one tells you about, every one uses the smartlist functionality but not the hot keys etc.

So here it is. In any of the look up fields start typing the first couple of characters of the ID then press Ctrl L and it will take you to the first match in Alphabetical order.

Its a simple as that, some times its the little things that make a difference.

I have published a whole list of hot key , keystroke short cuts on our online knowledge base which can be accessed by Touchstone clients.

any questions please contact

Monday, 28 September 2009

A quick reminder V8 support is about to run out 13th October 2009

This is a Quick reminder for those of you still on version 8.

Mainstream support for Microsoft Business Solutions – Great Plains 8.0 will end October 13, 2009 per the Microsoft Support Lifecycle Policy. This means that any GP 8.0 issues logged after Oct 13 will not be supported by Microsoft.

You can still log these issues with the Touchstone as we will support our clients on whatever version of Dynamics (GP) they are on. However you do need to be aware that should we need to escalate an issue to microsoft or the code requires a bug fix for a previously undiscovered bug, then the only option will be to upgrade to a supported version.

If you are tinking of upgrading then there is an audit document available on our online knowledge base or you can ask the or your Account Manager.

The Audit document contains sizing information about database sizes , numbers of modified reports and server specifications, all of which are needed to give an acurate quote on an upgrade.

If you would like some help filling it in then the will be happy to assist.

Once it is completed send it tous and we can provide you with a quote for the upgrade.

If you have any questions please feel free to contact

Monday, 21 September 2009

All Change on 15% Tax Again January 2010

Tax Changes in Dynamics (GP)

This is a quick re working of the advice we put together last time the VAT changed from 17.5 to 15%. This change is being reversed in January 2010 so now would be a good time to start thinking about how this might effect your systems. The changes in VAT where originally set out in the Chancellors PBR on the 24th November 2008. Because of the nature of Tax calculations in Dynamics (GP) this article is intended purely as a Guide and you will need to choose the appropriate actions for your circumstances.

Note: We have kept these notes fairly generic as we have clients on several different versions, however in version 10 where we give a path to Setup>company etc these are found under Tools> setup > Company

Tax Details

Originally we advised that everyone will need to set up a new set of tax details to replace the 17.5% details currently used. We recommended that you did not simply change the rate on your existing detail as this could cause you reporting problems and issues when trying to post back.

To set up a new Tax detail you need to go to Setup>Company>Tax details
You needed to set up a minimum of two details, one for sales and one for purchasing. This needed to be done in each of your companies.

If you followed this advice you should now still have your original 17.5% tax codes to which you can now revert in January.

Tax Schedule

Here you have Two choices.

Option 1: We advised that you could retain the existing Tax schedule and simply remove the 17.5% detail from this schedule. Then add the new 15% detail to the schedule and to the ALL Sales and ALL purchasing schedules that you have setup on the company. Schedules can be accessed from setup>Company>Tax Schedules. This has the advantage of not then needing to change any setup on classes , debtors, creditors , items or projects. Simply put where ever the old 17.5% detail appears in a schedule on its own (No other details)you will need to replace it with the 15% detail and wherever it appears with other details you will need to add in the 15% detail. If you took this option then it is simply a matter of swapping the details back.

Option 2: is to setup two new Tax schedule (one sales one purchasing). Again this is done through setup>company>Tax schedules. Once these have been crested you will also need to add the 15% Tax detail to the existing All sales and All Purchasing tax schedules. However if you create a new schedule you will need to change all the card records within dynamics that have a schedule attached. These are Debtor maintenance, Creditor Maintenance, Item maintenance, Cards project categories, SOP setup options default tax schedules , and the appropriate Classes for all of the above , this will also need to be done in each company. If you took this option then you will need re allocate the ols schedules to classes etc and role down the changes.

VAT Reporting and Vat input and Output codes

Originally we advised, If you are using the standard Vat reporting within Dynamics (GP) this all works off of Tax detail ID so if you have created a new detail there should be no issues. However some of our clients are reporting directly off of the GL account code. If this is the case you will need to setup two new GL accounts for the new tax rate (input and output accounts)and add these accounts into the new details you have created.
Setup new accounts under cards >Financial>Accounts remember it will need to be a balance sheet account.
The Account can be associated with the Tax detail Setup>Company>Tax detail id.
You may wish to do this even if not reporting directly of the GL. If you followed these instructions you will need to change the account code back.

Sales Order Processing

SOP will cause some issues as any outstanding transactions created this week will retain their 15% tax detail when transferred to invoice (This is not a problem for POP as this recalculates). The Tax setup options for SOP are on the options Tab of the Sales Order setup window found under Setup>Sales> Sales order processing. To get round this issue you will need to go back and change the tax on the order to the new rate before transferring to invoice.

Nolan’s Advanced VAT

We have spoken to Nolan’s and they are issuing no specific advise however like us they are advising to create new details rather than update existing ones. These are found in the same place as the standard Tax details as these are alternate windows.
Note: if using Nolan’s advanced VAT you can set an account to be Taxable, in which case a tax schedule is held against the account as well as an individual Tax ID , these will need to be changed as well where they are using the 15% tax detail. These are accessed under cards>financial>Account .

Project Accounting

Depending on how your projects are setup , you may need to change the tax schedules on Cards> Projects> cost category.

Further Advice from the Government

For further detailed information and HMRC guidance about the original change, please visit the HMRC Website at

Advice has yet to be issued on the upcoming change in January 2010

No advice has been issued by Microsoft at this time , but when they do we will update you.

If you have any questions please contact the

Friday, 18 September 2009

No 1 Cause of year end issues

Its been a funny old day on the helpdesk today , every other call seemed to be about year end. So this is probably the opportune time to post a little reminder that the No 1 cause of year end issues is incorrectly marked posting types on accounts.

When you run year end all your P&L accounts are closed to retained earnings and your Balance sheet accounts produce a BBF (Balance brought forward) entry. If the accounts are incorrectly marked under cards>financial>accounts with the wrong posting type , then they will produce the wrong type of entry.

So Top tip for the day is make sure these are correct , this is easily done using smartlists.

If you have any questions please contact the

Wednesday, 16 September 2009

How to Reconcile RM to GL when you have multiple RM control accounts

This situation presents us with a unique set of circumstances as you can not restrict the Receivables aged trial balance by account. It can be restricted by payment priority and class so with some forethought and planning you could have debtor classes set up that use a specific control account or something similar along the lines of payment priority. If you have not done this or you think some transactions may have been miss posted then using smartlists would be your next best thing.

In Smartlists you can create a report for the receivables transactions based on the system date range and then create a report for GL (account transactions) for the system date range. This way, you can compare when the information was physically entered in the system (even with a different document date between modules). If one of the modules has the transaction posted and the other is missing, you can determine if the transactions were posted with a different date in GL than in receivables.

Within smartlists, open up the receivables transaction option. Add the column Posted Date. This column stores the date from your computer of when the document was physically entered in receivables. Even if the document date was for the previous year, the posted date stores the date of when you physically entered it. You can compare the posted date to the posting date (holds the document date) or the document date as well. You can narrow your search by entering the posted date since you were last in balance. This will tell you all of the transactions that were entered in receivables since then and you can compare your GL report to that and see if one module is missing the transaction, has a different document date, or a wrong amount as well(possibly the batch was edited in GL before it was posted). To restrict this report to just one of your multiple control accounts you will need to add in the Account receivable Account Number field and then restrict your report by this in the search option. This is where you would put in the value of the Control account you wish to reconcile.

Next, you will want to open the account transaction option within smartlists. Add the columns Originating Posted Date and Originating Document Number. This stores the posted date (system date) from the originating module. Even if you change the batch date, this stores the date of when it was entered. You can compare the originating posted date to the trx date (document date) in account transactions as well to see if they vary from what your receivables transaction report returns. You may also want to add the Originating Document Number and Originating Master ID (debtor id) to this report, that way you can tick transactions off by using the document number instead of looking for amounts. This time to restrict the report to the specific control account you will need to add in the Account Number field to the search criteria and add your Control account number here.

These reports will give you a good guideline on trying to narrow down when something was entered, but there could be other possibilities that could be a cause such as a posting interruption (but this may have updated one module and not the other so you can compare what's missing), receivables history was removed (which only effects receivables and not GL).

The reporting can be automated further by using excel functionality. Both reports can be out put to excel from smartlists. If they are put into the same workbook on different sheets , you can then use the V lookup functionality to compare the Document number on the RM report to the originating document number on the GL report thus highlighting differences and giving you a place to start.

If you are interested in a certain sub set of transactions on the RM such as the unapplied/outstanding transactions then the RM side of the report can be restricted further by adding in the Current Trx Amount field to Columns. If the value of this field is greater than 0.00000 then there is an amount outstanding on the document and so this can be added to the search criteria.

If you have any questions then please contact the

Friday, 11 September 2009

How to split out One RMA to multiple RTV with multiple vendors

This functionality is easy to find in version 10 of Dynamics (GP). Ordinarily if you create multiple RTVs (Return to vendors) from a single RMA (Return material Authorisation) then the system will try and create one RTV for just one of the vendors.

However if you go to Tools > Setup > Project > service setup and go to the Returns button. On the RTV side you will find a consolidated check box. Un Check this box and the system will then allow multiple RTV's to separate Vendors.

In Version 9 however the check box is not there in the setup options. Instead it is on the window that appears when you create the RTV from the RMA. When you click process this box appears at the bottom of the screen and is very easily missed. Un check this to allow multiple RTVs to multiple Vendors.

It seems simple but that check box is easily missed (Rhonda at Microsoft pointed it out to me, thank you).

If you have any questions, please contact the

Wednesday, 9 September 2009

Touchstone Group's Microsoft Dynamics Client Conference 2009 - 15th October - Registration is now open!

Yes its that time of year again where you actually get to meet some of our helpdesk staff. If you ever wondered what we look like when your talking to us on the phone now is your chance to find out. There will be several of us at the conference.

Also it is an excellent opportunity to meet with some of your peers in the industry and get up to date on the latest software releases and version 11. We will also be looking at modules etc that can save you money during these tough economic times, such as spend control and several electronic document solutions (yes if those Royal mail strikes affected your business then emailing your remittance advices may be the way to go).

For more information and to sign up, follow the below link to the Conference micro site.

Integration Manager and Windows 7

For those of you who like to keep up with the latest releases of Microsoft operating systems , you may be contemplating a move to Windows 7.

As Mentioned in earlier posts this is compatible with version 10 of Dynamics (GP) however not all third parties and other modules have been tested at this time. One of the most notable of these is Integration Manager. Currently this has not been tested with version 10 and is unsupported on the windows 7 platform.

If the Situation changes we will let you know.

If in doubt about supported operating systems please log a call with our helpdesk

Monday, 7 September 2009

Stuck Batches

Well its Monday morning, the summer holidays are over and we have had to sit on London’s orbital car park (other wise known as the M25) to get to work.
One of the first things we do on a Monday morning is to go through those emails and support cases that have been logged outside of office hours over the weekend. This morning there were three cases all to do with batches being stuck. Therefore I thought a blog on the subject might be of some use.

Since the batch recovery tool was introduced back in version 6 the instances of stuck batches have dramatically reduced , however we still get those annoying loops once in a while where you pick up your batch from batch recovery and it sends you straight back to batch recovery. When this happens your only option is to reset the batch in SQL.
Below is an extract from an article on our online knowledge base that tells you how to deal with this.

If you are one of our clients, you can sign yourself up to our customer portal to access this via the support section of our website ( or simply ask the helpdesk and they will set you up.

Batches should be freed through batch recovery, these steps should only be taken if this is not possible.

1. Make sure you have a current backup of your company database.

2. Go to the SQL Query tool located in your Microsoft SQL Server Program Group.

3. Under DB select the company database you are working with, i.e., TWO is the lesson company.

4. Enter the following query in the query window;UPDATE SY00500 SET MKDTOPST=0, BCHSTTUS=0 WHERE BACHNUMB='XXX'(where XXX is the batch number of the batch you are trying to post).

5. Under DB select the DYNAMICS database and enter the following query;DELETE SY00800 WHERE BACHNUMB='XXX'(where XXX is the batch number of the batch you are trying to post).

6. Verify the accuracy of the transactions.

7. Verify that you can edit and post the batches.

Wednesday, 2 September 2009

What should I back up?

This is not as obvious a question as it would seem.
We are all aware that you will need to backup your Dynamics and Company databases however there are other files which store unique set-up information required to run your dynamics system. Below I have listed these areas:

Sysdata This is the file/folder that stores all your FRx rows, columns and trees along with the FRx registration information.

IM.mdb If you are using Integration Manager, this is the access database that will store all the queries etc. that you set-up within Integration Manager.

Reports.dic This is where any reports that you modify will be stored; you should have an up-to-date copy of this somewhere accessible. In the event that this becomes corrupted you can then replace it.

Forms.dic This is the same as the reports.dic but contains modified windows.

Any files with.dic or .vba extensions These are the dictionaries for any modifications to the third party products and any VBA modifications

Letters folder, if you are using the letter writing wizard then all your templates are held here. This could be local or on the server.

OLE notes. This folder should be on the server and will contain any attachments that you have added to notes in Dynamics.

For further advice please contact the Touchstone helpdesk.

Dynamics (GP) 10 Service Pack 4

Service Pack 4 for version 10 has now been released and is available for download from Microsoft’s customersource web site. Please do not install this service pack yet as we have not completed in house testing on it at this time. Salim Umerji (our Product Manager for Dynamics (GP)) has scheduled time for this testing and will be updating this blog once testing has been completed.

If you have any questions regarding this service pack please contact the helpdesk

Windows 7 and Dynamics (GP)

Well there is good news and there is bad news .

The good news is Windows 7 is compatible with version 10 of Dynamics (GP).

The bad news is that there are no plans to make it backwards compatible with earlier versions and no testing has been done at this point with FRX or any 3rd party add ons .

Please contact the helpdesk before upgrading to windows 7