In Touch with Dynamics GP

This blog is intended to be a useful resource for m-hance Dynamics (GP) clients and the wider Dynamics (GP) community.


For more information on m-hance and the solutions and services we provide, please call us on 0844 254 0933, email us at
support@m-hance.com or visit us at www.m-hance.com


Thursday, 25 August 2011

Management reporter not warning me to save.

Hi Folks

Quick tip for MR, unlike FRX it will not always warn you to save changes when logining out, there is a Tick box under tools options which alows you to set  MR to warn you.

The tick box is " Display confirmation before exiting Management reporter"

Wednesday, 24 August 2011

Emailing POs using new GP2010 word templates

Hi Folks

Below are a few things to keep in mind when upgrading reports to Dynamics GP 2010 if you want them to work with the templates and email functionality (Also check out previous posts for required fields).

To ensure that Purchase Orders can be emailed out of GP2010 using the new word templates, the GP report in report writer must contain the following:


  1. The purchase order number from the PO Document list table
  2. Section additional header 1 based on the above field
  3. Section additional footer 1 based on the above field

The word template will work OK without the above, but it will not email.

Most likely to be a problem In old upgraded reports from versions prior to Dynamics GP 2010

Andy Hall

Monday, 8 August 2011

Management reporter migration wizard (FRx)

Hi folks, another quick Management reporter tip.



We have now done a fair few Management reporter upgrades/migrations from FRx. originally we had a few issues with the migration tool. However in the latest release (sp2) this now functions a lot better. However it will not bring across account sets or security. these will need to be re added manually.

any questions andrew.hall@touchstone.co.uk

Management reporter and segment names

Hi folks its been very busy here of late and so the blog has taken a back seat ( if you want to know why we have been so busy type "Calyx touchstone" into bing and see what you get).




Anyway there are a few tips and discoveries to catch up on,



If the account segments in Dynamics GP aren’t named (so called segment1, 2, 3, etc) and you write your reports in MR with this format, if and when at a later date you decide to name your segments to something else (location, division etc), the reports will come back with no data.



To get round this you can do an edit/ replace on segment1 (2,3) with whatever your new segment descriptions are and your Management reporter reports will then function again, these do not update dynamically in MR when you change them in GP.

any questions please contact andrew.hall@touchstone.co.uk


Tuesday, 26 April 2011

How to create 32 bit ODBC data sources for Dynamics GP from a 64 bit server.

Hi folks , this is a real quick handy hint. As you are probably no doubt aware Dynamics GP can not see 64 bit ODBC although it is compatable with  64 bit operating systems (versions 10 and 2010 only, service pack specific).

The 32 bit drivers are still on the server however if you create a datasource through ODBC settings it will create a 64 bit one by default.

To access the 32 bit drivers:

1. Browse out to %systemdrive%\Windows\SysWoW64\odbcad32.exe

2. Created short cut on desk top to odbcad32.exe

3. Created 32 bit odbc using odbcad32.exe

You will then have 32 bit ODBC datasources.

if you have any questions please contact helpdesk@touchstone.co.uk or myself andrew.hall@touchstone.co.uk

Dynamics GP Bank Management - Checkbook [checkbook id] is already in user by user [username].

Hi folks I have been quiet for a while as we have been exceptionally busy here a Touchstone and something had to give somewhere and that was the blog I am afraid.


Anyway I have just spent a rather frustrating half an hour trying to resolve a support case, where I could find no mention of the fix under partnersource or elsewhere on line despite this being a standard error message. Therefore I thought I would post this out there to save everyone else the frustration.

The error message is “Checkbook [checkbook id] is already in user by user [username]” or if you’re in the UK “Chequebook [chequebook id] is already in user by user [username]”.

This message was occurring when the user had crashed out of a reconcile and then tried to re access the reconcile window Transactions>Financial>Bank Management>Reconcile.

We had tried Clearing the Bank Management ACTIVITY under routines>financial>Bank Management but we still got the message.

We also tried clearing the DEX_LOCK and DEX_SESSIONS from the tempdb by running delete statements against both, but we still got the message.

We had checked the Contents of the CB100006 as suggested in an article by VAIDY however there was nothing here either.

http://community.dynamics.com/product/gp/gptechnical/b/gplearn/archive/2010/04/12/cbm-checkbook-91-checkbook-id-93-is-already-in-user-by-user-91-username-93.aspx

In the end though we needed to remove a record from the CBEU1020 CE ACTIVITY table.

select * CBEU1020 returned the locked record.

Then we ran a delete statement (as there was only one record in there)

Delete CBEU1020

And the issue was resolved.

If you have any questions please direct them towards the helpdesk@touchstone.co.uk  or myself andrew.hall@touchstone.co.uk

Tuesday, 15 March 2011

Making the best of what you have got with Dynamics GP

In the current financial environment we are seeing a lot of cost cutting, amalgamation of roles and other physical signs that people are trying to do more with less. However most people seem to pass over their Dynamics GP finance system and continue using it the way they have always used it since it was implemented (In some cases this is over 10 years ago and version 5.5).

On the whole people seem to worry about change especially in something as business critical as your finance system however Dynamics GP has come a long way in a short time and there is undoubtedly functionality within your system that you’re not using. This unused functionality may be the key to further cost savings.

Lets take a look at some of these types of functionality that are generally over looked, are they in your current version of Dynamic GP at present not being used or would a simple and cheap upgrade or third party add on provide this functionality with a quick ROI and attached cost savings.

eMail

Top of my list is email, does your Dynamics GP have the ability to email out documents?

The ability to email out statements has been in Dynamics GP for some time, however in Dynamics GP 2010 there are 39 other reports that can be emailed out using word templates including remittance advice and POs. Prior to Dynamics GP 2010 you would need a small add on called email Pro from Professional Advantage to email out Remittance advice and Pos and Sales orders.

There are several savings associated with this:

1. No Paper (you don’t need to purchase as much)

2. No postage

3. No envelope

4. Staff time stuffing and sealing envelopes

Its quite common to send out large billing runs by post or remittance advice for BACS payment runs, Think of the amount of time and money that could be saved if these paper based processes could be transferred to email.

BACS/EFT

Closely akin to the email option again time and money could be saved with electronic payment runs rather than printing cheques and stuffing envelopes.

Document Formats and templates

If you still need to send out paper communications, Dynamics GP has always allowed you to setup headers and templates for your documents which can include Logos and other images, however prior to Dynamics GP2010 there have been restrictions on bit map size for logo’s in report writer. In Dynamics GP2010 the new word templates allow for much larger and complex logo’s. These could be utilised and no more expensive headed paper with your company logo is required.

Procurement

Take a look at your procurement practises; are you using multiple supplies for the same items?

Are you purchasing them at wildly varying prices?

Look at your Dynamics GP what kind of reporting can you get on these purchases to help you make informed decisions? Smartlists and the new excel based reporting is ideal for tracking top 10 suppliers and items.

Tighter controls in place would allow you to make deals with specific suppliers. Dynamics GP deals effectively with these however you may want to put an authorisation process in place against budgets etc. and have an online requisition process. To do this you may want to look at a procurement system. ROI on these is generally very good. And they come in several sizes such as entry level systems like Nolan’s eRequest and Mid range solutions such as Complete right up to large solutions such as Proactis. All of these will integrate and work with Dynamics GP.

Mapping

Dynamics GP these days will utilise online mapping software like Bing maps. These can be used to help you group and assign client/customers geographically; this could help with travelling or shipping expenses.

Stream line processes

There maybe other processes within your Dynamics GP systems that you are doing the way you have always done, talk to your solution provider there may well be quicker and better ways of doing them now. A prime example is the Edit cheques batch window added in version 9 which allows you to see all your outstanding creditors and transactions in one window making it a lot easier to add transactions to a payment run. We still see a lot of people using edit cheques simply because that’s the way they have always done it. Another prime example is renaming columns in smartlists , most people don’t realise you can do it and it saves you a lot of fiddling after you have exported to excel.

Reporting

Better reporting will help you make more informed decisions and spot trends etc, as already mentioned this may be of particular help with procurement however also think about how you deliver those reports. A lot of finance departments I know are constantly inundated for requests for this report or that report placing a large drain on time and resources (that could be used elsewhere). If you have a company intranet can these reports be published on the intranet in a portal or dashboard and thus providing a self service reporting area freeing the finance team as well as providing instant access to relevant data. Frx has an HTML output option ideal for publishing on the web or you could deploy the out of the box SQL reporting services reports accessible of an IIS web site or sharepoint.



So in summary there are a fair few things you could look at with your existing Dynamics GP system that may well provide some measure of cost saving and allow you to do more with less. My advice would be talk to your system provider about the functionality in the Dynamics GP system and how you currently process; you may be pleasantly surprised by the results.

Andy Hall Helpdesk Manager  TouchstoneGP   andrew.hall@touchstone.co.uk