Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / US based company, has ...
Microsoft Dynamics GP (Archived)

US based company, has UK office that needs to convert to GP-- all seemed fine until I got to Bank receipts

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

I have a customer that has the US version of Dynamics GP and they have acquired a UK office. We are converting their UK Sage accounting system to the US Dynamics GP.  the UK office woudl be a seperate database/company.  We can solve the date format issue by having a dedicated citrix server set to European date format. All seemed good with the world until I came to post bank receipts.  In the UK every transaction has a vat tax associated with it.  You can deal with that in PM and GL ; however the bank reconciliation module does not allow you to track vat taxes!   UGH  I woudl appreciate any recommendations.

So, I have 2 thoughts/questions

1- can I install the UK version on a citrix box, (assuming a seperate sql install)?

2-- is there any way to solve the vat tax transaction entry requirement with another tool?

If you use the gl to enter the transaction, half of the problem is solved, but then you cannot use bank reconciliation.

HELP!

Thanks

Carolyn

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: US based company, has UK office that needs to convert to GP-- all seemed fine until I got to Bank receipts

    Howard,

    Thank you so much for taking time to respond.  I did find the issue. I was suspicious, but could not confirm it; however Microsoft support felt it was the cause of the issue.     the UK installs were originally working, the citirx person felt it necessary to copy over the dynamics set file from a US workstation; which then caused all kinds of version conflicts on the UK modules and of course it deactivates the UK modules, but not being an application person they didn't understand the impact of their decision.

    We ended up editing the db upgrade table to the correct version as the du000010 and 20 had the correct version it was only the upgrade table that was throwing the wrong version.  

    another issue to be aware of , if you need UK companies make sure you are in using the UK utilities-- one of those things you really know, but could have been another issue that contributed to the mix up in versions-- Unfortunately I do not have access to the citrix install so I cannot control what happened, but I can document again so no other technician inadvertantly wipes out our UK install again.

    Thank you again for all your assistance, I know it is time consuming.  Its these little strange things that increase the knowledge base though!

    have a great weekend !

    Carolyn

  • Suggested answer
    Howard Swerdloff Profile Picture
    Howard Swerdloff 845 on at
    RE: US based company, has UK office that needs to convert to GP-- all seemed fine until I got to Bank receipts

    Check the Dynamics.set file on the Citrix server. If GP was reinstalled on Citrix, it is possible something was installed that was not installed everywhere else. That could have created tables in your database that are causing problems loading from your workstation. If that is the case, the easiest solution is to install the workstation to match the server. Ideally though, you would want to see what got created and remove it. You can do this by looking at the product ids that do not belong.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: US based company, has UK office that needs to convert to GP-- all seemed fine until I got to Bank receipts

    I ran the latest service pack for version 2010 and that did not fix the issue.  

    I looked at the db_Upgrade and it showed 2 companies with the version 8 reference; however these two companies were a direct copy of the company that did the set up for 1058 and 3096, so doesn't make sense.

    I also checked DU000010 and there are no references to version 8.

    I opened a case with Microsoft support, but it may take quite awhile before they can respond, so I was hoping to see if anyone had any other ideas.

    if I drop the tables in the companies that say it is version 8, then I will actually be dropping the tables that contain 2010(11) setup information.

    UGH!

    any assitance will be appreciated.

    thanks

    Carolyn

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: US based company, has UK office that needs to convert to GP-- all seemed fine until I got to Bank receipts

    Yes, I had 2 dev machines, one a server with the US install and one an app machine with the UK install.  they worked fine until the citrix guy got involved.  He woudl not tell me what exactly happened but I know he had the sa user stuck in 2 different companies and the UK install on my workstation  was not functional any longer.  

    the product did get reinstalled on a new citrix box. the message that you receive is that the company has not finished set up and go through utilities.  When you go through utilities you get  bet the error that the version cannot be determined.  If you look at the duinstall log it shows that a version 8 of 2 modules 1058 and 3096 have been installed evengthough the databases have the version 11 in use.

    My feeling is that we need to do a more current service pack.  the company has been resisting doing an upgrade to 2013 for a couple of reasons, one being the challenging working environment with IT, and the large number of databases; but I am going to try adding a service pack and see if that corrects the issue in my environment and then explain why we have to have the service pack on all workstations.   You cannot do an automated push to the workstations as no user has the ability to finish any kind of install, so it will require IT to go around and install the service pack on the workstations.   That's fine, it is just more work for IT.  I do have admin rights on my machine, but can't log into anyone else's and do the install.  Ultra control here.

    I am working on a dev server with a handful of databases--they are still on version 2010 and service pack 1,

    I am going to move up to a service pack and see if that works, but if you have a solution that is better please let me know.  

    I had scheduled to have the IT department here tomorrow, Saturday to drop the tables on the production databases, but if the reinstall of the citirix later will cause additional issues I dont' want to have them do this exercise for nothing.

    any suggestions would be great.

    thanks

  • Suggested answer
    Howard Swerdloff Profile Picture
    Howard Swerdloff 845 on at
    RE: US based company, has UK office that needs to convert to GP-- all seemed fine until I got to Bank receipts

    Hi Carolyn,

    Am I understanding correctly that you had it working until the Citrix install was done? If so, did GP get reinstalled after Citrix or did they just do an upgrade? What is the exact error message you are getting?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: US based company, has UK office that needs to convert to GP-- all seemed fine until I got to Bank receipts

    Hi Howard,

    I wanted to touch base with you on this old issue.   I did find that 2 companies had the ttables related to the vat datbook, 3096, cashbook mgmt, 1058 and scheduled instalmnets, 1150,  I dropped the tables in sql after viewing the dbUpgrade table, but I am still receiving an error when I attemp to load my UK product

    I actually had a Uk application working fine, but then the citrix guys did an install and now I can't use my UK workstation.  Unfortunately, the person who did the install, says they didn't change anything, so I dont' really know what happened.  

    do I need to delete the tables , then run a repair install?  

    any suggestions would help.

    I had to do the UK training on the US install and that was not effective enough, but it got us through the basic training.  

    thanks for your assistance.

    Carolyn

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: US based company, has UK office that needs to convert to GP-- all seemed fine until I got to Bank receipts

    I deleted the rows that has reference to the 2 products, version 8 but once you run thorugh utilities again, the rows are recreated, so I guess the next step is actually dropping the individual tables for the 2 products?

    thanks for your assistance

    Carolyn

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: US based company, has UK office that needs to convert to GP-- all seemed fine until I got to Bank receipts

    I am not sure who loaded the original install years ago, but I do see a lot of version 8 listed on products they neer used. I'll let you know.

    thank you

    Carolyn

  • Suggested answer
    Howard Swerdloff Profile Picture
    Howard Swerdloff 845 on at
    RE: US based company, has UK office that needs to convert to GP-- all seemed fine until I got to Bank receipts

    The first question is do these tables exist in the database. If so, do they have any data in them. If GP thinks they are on version 8, my guess is there is not any data in them. The 2nd step is to look at 3 tables in the Dynamics database (DB_Upgrade, DU000010 and DU000020. They contain information on the versions installed and upgraded to for those products. I would recommend making a backup of the Dynamics database and then reviewing these tables for the product ids referenced in the error log. Do a select statement for those product ids and copy them to Excel so you have a reference. If you see any records with those product ids and version 8 as the major version, I would delete them. That may get you through utilities. If not, you may need to drop the sql objects first (from the list in Excel) and run a repair installation.

    Let me know if this works.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: US based company, has UK office that needs to convert to GP-- all seemed fine until I got to Bank receipts

    I think I found som eof my issues

    I did a clean install for the UK and installed bank managment which = cash book and I installed Vat Daybook

    the error log shows the each of these products cannot be upgraded from version 8?  THey did not have either of these products before.  

    any suggestions?

    Thanks

    Carolyn

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans