Rose Business Solutions Dynamics GP

Author Archive

Hello all, a few days ago, I was helping my friend Doug Pitcher covering support while he was spending the dollars, so I answered a call from one of our customers, she was not able to change her password used to access the server where Dynamics GP lives on her company.

It was a nice call so far, she was giving a thought on what her password should be and finally she says “I know which one I am going to use” and then I say “please do not use your home address” she replied with a laugh saying “how did you knew?” so I just said well it’s common on users to do that, then she kept thinking a bit more when I saw her enter her password, but again she was receiving errors, so I asked her “remember do not use a password that was previously used before, it should not contain parts of your name or last name it should include a Capital letter and at least one number” when I was frozen by the question “Should I enter uppercase or lowercase numbers?”.

What?…. wait a second did I heard it right? so I asked “can you repeat that?” and she said it again “uppercase or lowercase numbers?” at first I must say I was at the point to break in a laugh but I do respect our customers and try to understand them so for a few nanoseconds my mind went into a spiral when all of the sudden I had a revelation!!!!.

So I asked “Could you please tell me, are you using a laptop or a desktop?”

she replied “A desktop…” then my mind workflow was in the correct path then I asked

“How are your uppercase numbers organized"?” when she replied “They are above QWERTYUIOP” and then I asked “how are your lowercase numbers organized “ when she said “on the right part of my keyboard right next to the arrows….” so I said “use your lowercase numbers” after a few moments she replied “my lowercase numbers are not working…” this is an easy fix I said “press the Num Lock” on your lowercase number area and they will work”

 

Finally I was able to help her reset her password but I kept thinking on it as I have a laptop with regular keyboard not the extended version I saw that sometimes you have numbers on the letters M,J,K,L,U,I,O that are smaller than the key letter, so should that have been the case I know that I can find lowercase numbers on my laptop.

 

Now I have shared this true story behind the Customer Service Desk and I hope you like it, and I would like you to share one of your memories while working with users and Dynamics GP.

Have a great Day!!

Yes, you are reading correct, the long awaited R2 for Dynamics GP 2010 is now available for us to download.

Click this link to review the brand new “What’s New PDF” CLICK HERE

New customers will not be able to obtain registration keys until GA May 1st.

 

The DVD for Microsoft Dynamics GP 2010 R2 is now on the Product Release pages below.  The Word Template Generator is a NEW PRODUCT for Release R2 and has its own PARTNER ONLY download page below.

Service Pack 2 for each product is included on the DVD and has also been posted to each individual page.  The links to each page are below.

 

The Microsoft Dynamics GP Service Pack 2 version is 11.00.1752.

Product Release Downloads for Microsoft Dynamics GP 2010

https://mbs.microsoft.com/customersource/downloads/servicepacks/mdgp2010_release_download.htm?printpage=false

https://mbs.microsoft.com/partnersource/support/selfsupport/productreleases/mdgp2010_release_download.htm?printpage=false

Direct Link to the DVD – MDGP2010R2_DVD.zip – 2GB

https://mbs2.microsoft.com/fileexchange/?fileID=f9dc853c-2a19-4815-8e42-9c3713286d0b

Word Template Generator – PARTNERSOURCE ONLY

https://mbs.microsoft.com/partnersource/downloads/releases/MDGP2010R2_WordTemplateGenerator

Service Pack, Hotfix, and Compliance Update Patch Release for Microsoft Dynamics GP 2010

https://mbs.microsoft.com/customersource/downloads/servicepacks/mdgp2010_patchreleases.htm?printpage=false

https://mbs.microsoft.com/partnersource/downloads/servicepack/mdgp2010_patchreleases.htm?printpage=false

Direct Link to the patch – MicrosoftDynamicsGP11-KB2435566-ENU.msp – 257 MB

https://mbs2.microsoft.com/fileexchange/?fileID=7b88f40d-4082-46b0-bc96-d49360d100ea

Direct Link to SP2 Fix List and Install Guide – 11.0SP2_install_guide_ENUS.pdf

https://mbs2.microsoft.com/fileexchange/?fileID=534d2741-3dc3-4f49-9f92-849989a2c9ec

Software Development Kit for Web Services for Microsoft Dynamics GP 2010

https://mbs.microsoft.com/customersource/downloads/servicepacks/mdgp2010_webservicessdk.htm?printpage=false

https://mbs.microsoft.com/partnersource/downloads/releases/mdgp2010_webservicessdk.htm?printpage=false

Software Development Kit for Microsoft Dynamics GP 2010

https://mbs.microsoft.com/customersource/downloads/servicepacks/mdgp2010_gpsdk_rtm.htm?printpage=false

https://mbs.microsoft.com/partnersource/downloads/releases/mdgp2010_gpsdk_rtm.htm?printpage=false

Software Development Kit for Visual Studio Tools for Microsoft Dynamics GP 2010

https://mbs.microsoft.com/customersource/downloads/servicepacks/mdgp2010_vstoolssdk.htm?printpage=false

https://mbs.microsoft.com/partnersource/downloads/releases/mdgp2010_vstoolssdk.htm?printpage=false

Software Development Kit for Workflow for Microsoft Dynamics GP 2010

https://mbs.microsoft.com/customersource/downloads/servicepacks/mdgp2010_workflowsdk.htm?printpage=false

https://mbs.microsoft.com/partnersource/downloads/releases/mdgp2010_workflowsdk.htm?printpage=false

Service Packs and Hotfixes for Personal Data Keeper for Microsoft Dynamics GP 2010

https://mbs.microsoft.com/customersource/downloads/servicepacks/mdgp2010_pdk_servicepackshotfixes.htm?printpage=false

https://mbs.microsoft.com/partnersource/downloads/servicepack/mdgp2010_pdk_servicepackshotfixes.htm?printpage=false

Service Packs and Hotfixes for Web Services for Microsoft Dynamics GP 2010

https://mbs.microsoft.com/customersource/downloads/servicepacks/mdgp2010_webservices_servicepackshotfixes.htm?printpage=false

https://mbs.microsoft.com/partnersource/downloads/servicepack/mdgp2010_webservices_servicepackshotfixes.htm?printpage=false

Service Packs and Hotfixes for Workflow for Microsoft Dynamics GP 2010

https://mbs.microsoft.com/customersource/downloads/servicepacks/mdgp2010_workflowservicepackshotfixes.htm?printpage=false

https://mbs.microsoft.com/partnersource/downloads/servicepack/mdgp2010_workflowservicepackshotfixes.htm?printpage=false

Service Packs and Hotfixes for Integration Manager for Microsoft Dynamics GP 2010

https://mbs.microsoft.com/customersource/support/downloads/servicepacks/mdgp2010_integrationmanager.htm?printpage=false

https://mbs.microsoft.com/partnersource/downloads/servicepack/mdgp2010_integrationmanager.htm?printpage=false

Service Packs and Hotfixes for eConnect for Microsoft Dynamics GP 2010

https://mbs.microsoft.com/customersource/downloads/servicepacks/mdgp2010_econnectservicepackshotfixes.htm?printpage=false

https://mbs.microsoft.com/partnersource/downloads/servicepack/mdgp2010_econnectservicepackshotfixes.htm?printpage=false

Dexterity Development Releases for Microsoft Dynamics GP 2010 (Available Soon!)

https://mbs.microsoft.com/customersource/downloads/servicepacks/mdgp2010_dexterityreleases.htm?printpage=false

https://mbs.microsoft.com/partnersource/downloads/releases/mdgp2010_dexterityreleases.htm?printpage=false

A few days ago I was browsing GP when I noticed a section in GP that I was not familiar with.

I used to provide multicurrency support in LATAM as well for a company I sued to work but this time I was left with a question mark.

If you go to Tools > Setup > Financial > Multicurrency

you will see Multicurrency Setup window that now includes a section named “Currency Translation Default Exchange Table IDs”

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

I searched all over the internet and GP help files but with no luck, then I asked on Microsoft Communities when a friend from Fargo provided such information.

After installing GP 2010 SP1 you can translate GL amounts in a specified currency. Management Reportes can use translated amounts directly from Dynamics GP.

A currency translation allows you to report GL in different currencies that are not either the functional currency or the originating currency.

That’s why they (MS) added this table to setup exchange rate to be used for translation.

 

Translation Types:

Average uses a single exchange rate for each GL period, the values are converted to the reporting currency using an average exchange rate for the individual period as entered in the exchange table.

Current uses a single exchange rate based on the report date, the values are converted to the reporting currency using the exchange rate on the “as of date” for the report.

Historical uses a single exchange rate based on the transaction date, when an account is converted to the reporting currency individual transactions for the account are converted to the reporting currency using the exchange rate that was valid on the transaction date, then all summary information will be recreated for the account, based on the translated amounts.

 

In all three types if an exchange rate couldn’t be found then functional currency amounts are used.

 

There are more features that came along with this new characteristic, and obviously you need FP1 for Management Reporter.

 

Have a great day!!

Francisco Hillyer

David Musgrave has compiled a list of statements that have fallen into Fact or Fiction area he has now enlightened us unveiling the truth behind Support Debugging Tool.

The myths around this tool are the following:

The SDT is hard to install?,  hard to setup?

can only capture logs?, SDT creates tables at the SQL Server level?

The SDT causes performance problems

The SDT has features that are dangerous

The SDT is Microsoft’s most guarded secret

The SDT will make you more attractive to the opposite sex

The SDT will regrow hair

The SDT was created by advanced aliens, David just stole their technology

 

And a lot more if you want to be on the ring of power

Click on the following link to know the truth

http://blogs.msdn.com/b/developingfordynamicsgp/archive/2011/04/20/common-support-debugging-tool-myths-fact-or-fiction.aspx

Hello all

Its my pleasure to inform you first hand that FRx 6.7 Service Pack 12 (6.7.12008) is out there the certification of FRx SP 12 is complete for Dynamics GP 2010 and Dynamics GP 10 for existing FRx customers. New customers to GP 2010 must use Management Reporter. If you really need FRx then you need to contact Microsoft Dynamics Business Desk.

 

FRx 12 does NOT include the following Dynamics GP 2010 features:

• Filtering on Reporting Ledgers
• Budget Transactions and Unposted Budgets

If your customers need these features, they are available in Management Reporter.

The link for the FRx 12 page is the following:

https://mbs.microsoft.com/customersource/downloads/servicepacks/frx67sp12

 

The download links are here:

FRx SP 12 GP

If using Analytical Accounting then use this (Do not use the previous link) FRx SP 12 GP AA

 

 

Have a great day!!!

Francisco G. Hillyer

A few months ago a customer called saying that whenever he tried to post cash receipts he was getting the following error: A get/change last operation on table doCreditCardAuthorizationActivity cannot find the table.

He said that this was the first time they got the error and they could not continue working.

I did my research and found no mention on the tables at all.

Then I asked if any third party products were installed he said “No the only change is that we updated to SP5” ….. that’s were I got the clue.

I reviewed the Dynamics.set file and saw an unusual product 6499 Dynamics Online Services.

I went to “Microsoft Dynamics GP > Tools > Customization > Customization Maintenance”

and disabled Dynamics Online Services and asked the user to reproduce the steps that gave him the error and it did not appeared.

So I used the following approach to solve the issue:

click on Start > Programs > Microsoft Dynamics > GP 10 > Database Maintenance

I followed the wizard and when I got to the step to select the products I selected Dynamics Online Services and I choose to recreate Stored Procedures, Views and Triggers.

After processing it my understanding was that the error would disappear but instead we got the following error: A get/change last operation on table doCreditCardAuthorizationActivity failed accessing SQL data.

So when I read “Failed Accessing SQL Data” immediately went to SQL server and ran the Grant.sql script and after that no more errors.

On the Dynamics GP online community a recent post regarding this issue was asked and Ian Stewart posted a similar solution as well

Have all users log out from GP and login as SA

go to Microsoft Dynamics GP > Maintenance > SQL select DYNAMICS as DB click on the tables DO Setup, and the options Create Table and Create Auto Procedures.

then select each company and for each company recreate tables and auto procedures for the following tables: DO Cash Receipts (History Open and Work), DO Credit Card Services Activity, DO Credit Card Setup, DO Sales Payment Work and History.

Click process and that’s it.

Good Luck

Francisco G. Hillyer

Its finally here, the long waited update from Dynamics GP team for payroll has been released.

 

Here is the link to the direct download:

https://mbs2.microsoft.com/fileexchange/?fileID=2bbdbe6a-9214-4a59-9ff6-62b128ac26a3

U.S. Payroll Tax Update for Microsoft Dynamics GP 2010 (Round 4)
This page contains the latest U.S. Payroll Tax Update for Microsoft Dynamics GP 2010.

https://mbs.microsoft.com/customersource/downloads/taxupdates/tugp2010.htm?printpage=false

 

Here are the updated version numbers

Microsoft Dynamics GP	11.0.1708
Project Accounting	11.0.1699
Manufacturing	11.0.1700
Human Resources	11.0.1697
Field Service	11.0.1696
Grant Management	11.0.1693
Dynamics Online Services	11.0.1694

The automatic tax update site is available.

 

If you have employees paid in the state of Oregon, you need to install the tax update and the code update…major changes in their tax structure…there is also a new filing status for Oregon, so read the instructions if you are in Oregon carefully, please.

Thanks THeley…

Hello all Francisco here again with payroll updates,

Last week the IRS released the updated 941 report and the Dynamics GP Team has been working on the update non-stop so here it is what’s coming.

 

This update is a code and tax table update (Oregon) to receive all the changes.  This update is all inclusive of prior updates.

It will be noted on Microsoft’s tax update pages a target release date week of 3/28/2011, as it gets closer, we will have more details.

Items included in this update (NO table changes)

I must add that this update will need to be installed on each machine so you receive the “new” 941 form.

-941 form changes (941 form, prep report and cross company reports, this is in the code)

-Oregon state tax table and code changes

-Bug fixes 10 and GP 2010 around HRP.

              New Employer Manual check amount does not distribute to GL correctly

              US Payroll edit tax liability report the 941 amount incorrect

              Electronic W2 file is incorrect for 2010 when you have HIRE Act employees and 2 or more companies

 

GP 2010 only Payroll cannot process manual checks with AA active Error Distributions do not match transaction amounts – still a problem after you apply fix in US payroll year end

GP 2010 only issue Company Payroll Summary Inquiry displays incorrectly

Other modules fixed in this update: Project Accounting, Dexterity, eConnect, Field Service, Analytical Accounting, Grant Management, and Manufacturing

***Supported version GP 10 and GP 2010 only***

Thanks to our friend theley

We are happy to announce that the always working Microsoft Dynamics Team has released the GP 9.0 Round 2 for U.S. Payroll Hotfix.

Please take note that the issues found on the reports after the release of the GP 10 US Payroll hotfix were fixed in this version and for GP 2010 which will be released hopefully in a few hours from this post.

 

Also Microsoft team has informed that there will be another release for GP 10 that will address a fix for the reports found on the earlier release, also will include the release of the Canadian Payroll (round 2) and some changes for the new T4A functionality as well some additional CSST functionality/change.

 

The round 2 2011 tax update (table) is already on the automatic server for all versions.  This is the last tax update supported for 9.0 and 9.0 SBF.

The Microsoft team has announced that they hope to release the 941 form change in March once IRS has the final form published.

 

I have to tell you that there is a slight change on the download process for this hotfix here are the Steps to Download Microsoft Dynamics GP 9.0 US Payroll Round 2 Tax Update

1. Click on the link below:

Microsoft Dynamics GP 9.0 US Payroll Round 2 Tax Update KB 2477913 – ** Once you install your Dynamics version is 9.0.388**

http://support.microsoft.com/hotfix/KBHotfix.aspx?kbnum=2477913&kbln=en-us

2. Under Step #1, click to select the checkbox under the "Select hotfix" area.

3. Under Step #2, enter a valid e-mail address and confirm the e-mail address in the "Provide us with your e-mail" area. An e-mail will be sent to

this e-mail address with the link to download. Type the characters visible in the Picture box.

4. Click Request Hotfix.

5. The following message will appear:  "Hotfix Confirmation. We will send these hotfixes to the following e-mail address:"

6. Go to your e-mail and find the e-mail from hotfix@microsoft.com with the subject "Hotfix download link you requested".  Towards the bottom of the e-mail, find the section titled "Package". Click the link from the e-mail to download the file. Save the file to a location on your machine.

7. Once downloaded, double-click the .EXE file and click Continue. It’s a 102MB file.

8. Enter a location to a folder to extract the contents of the file. Click OK.

9. Enter the password from the e-mail you received.  Click OK.

10. Double-click the .MSP file to install the US Payroll Round 2 Tax Update

 

Soon it will be available on the following link, but at the time I was writing this post it was not there: https://mbs.microsoft.com/customersource/downloads/taxupdates/usgptu9.htm?printpage=false

Issues list from 10 site- all fixed on 9 and GP 2010
Check Register
When you have Direct Deposit employees the Direct Deposit Check Register will still show the incorrect amount for Employer FICA Owed.  You will need to print the Reprint Check Register (Reports | Payroll | Reprint Journals) in order to show the correct Employer FICA Owed amount.

941 changes
941 Preparation Report will be correct through 6e.  The rest will be understated.
941 Schedule B Preparation Report will be understated.  Report is taking Employee total times 2 instead of taking Employer amount.
Form 941 Schedule B will be understated.  Report is taking Employee total times 2 instead of taking Employer amount.
Federal Tax Liabilities List 941 amount will be understated. 
Form 941 change – we will release update when form changes are finalized by the IRS.

 

Thank you Theley

I often get asked about which version of SQL server to use on a particular Dynamics GP  installation, sometimes I have seen odd configurations work with GP but the fact is that it’s not supported by Microsoft.

So this post goal is to show you the compatibility between SQL server versions and Dynamics GP that are supported.

 

Sources:

System Requirements for Dynamics GP 2010: GP 2010 Requirements

System Requirements for Dynamics GP 10: GP 10 Requirements

 

See original post in spanish by Bertrand Desmarest: http://blogs.msdn.com/b/dynamics_latam/archive/2010/10/22/sql-server-dynamics-gp-compatibilidad-entre-versiones.aspx