Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / GP 10 and adding a new...
Microsoft Dynamics GP (Archived)

GP 10 and adding a new company?

(0) ShareShare
ReportReport
Posted on by Cheryl L 145

I do not seem to be able to find any documentation that our former support techs may have created regarding this. We have a new company to add to GP and for the life of me, I don’t even know where to start. It would appear I begin in GP Utilities, is that correct? I am in there and am being prompted to upgrade or continue from a prior operation with the existing list of companies. Naturally, I do not want to bugger up anything….do I need to check any of these boxes or may I just hit next to go past this? (it does say at the bottom that company was updated successfully)

 

Thank you!!

*This post is locked for comments

  • Cheryl L Profile Picture
    Cheryl L 145 on at
    Re: GP 10 and adding a new company?

    Ok, cooking with gas now! The ODBC was already present, I just did not realize (after a couple of log in adjustments to it) that I only needed to put in the path from the drive on the other server, since it is in essence "mapped". I did not really understand the concept of an ODBC well enough to know that is all it required. Thanks again!

  • Cheryl L Profile Picture
    Cheryl L 145 on at
    Re: GP 10 and adding a new company?

    Sorry for the delay and thank you much for the help! The company needing updating turned out to be a test company environment, so I am past that. (we had trouble with space issues trying to get all of the others backed up before this entry) Now I am looking at the locations for the databases and though I know the network path and have access (sa as well), I am not sure of the syntax it wants to point there? Any clues?

  • Verified answer
    Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    Re: GP 10 and adding a new company?

    Is this an error messsage you are getting Normal 0 false false false EN-US X-NONE X-NONE or is it irrelevant to your quesiton?

    When it comes to creating a new company, IAN is correct, you start with GP Utilities. If all the companies were previous upgrading successfully you will see green checkmarks next to each one and you can click next. One of the options will be to create a new company. If you select that option you will asked to enter a 5 character ID and then the company and then a few other setup questions. If you on GP 2010 you will be asked to do a basic or custom installatation. I have no idea what the basic one does since I always choose custom. This will create the company in SQL and henceforth, be available when you log into GP. The SQL 'sa' account will be the only one who can see it until you grant access to the company to other users.

    If you see any other than green check marks update this case and we can proceed from there.

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: GP 10 and adding a new company?

    Hi - you are in the correct area to set up a new company.

    There seems to be an issue from the last time you upgraded. To be honest, this should not have been left as it is - as it will have to be sorted before you do the next upgrade. Having said that, its probably not a big issue - if you only found it by opening utilities, it means that the companies concerned are not in production use.

    Can you untick the companies that have are ticked? If so, do so, and click Next. Utilities will not try and upgrade these companies, and will continue on to the main Utilities window where you are presented with a drop down list of tasks. One of these is 'Create Company' - so select this and click 'Process'.

    You will be asked to supply a database name and a company name - and then you will have some options to choose from. Take note of the option that allows you to select another company to copy access from. This will set the user access of the new company to be the same as the one you select which can save you a lot of time later on.

    Be sure when asked to select the correct location to store the SQL database files in. If you are not sure, ask our system adminstrator, or open SQL Enterprise Manager and check where the other databases are stored (there are two types of files .Mdf and Ldf - and these can be stored in seperate locations) and use the same locations for your new company.

    Once you click Next, Utilities will go through the process of creating the company.

    When the company is set up, don't forget to include it in the SQL backup job...its something that gets missed a lot. People ceate companies, start processing live data, but forget that they may need to edit the SQL backup job to make sure the data for the new company is included.

    Hope this helps. If you encounter any more issues, post here. And get the databases that have errors on the cleaned up - its never a good idea to have stuff like this hanging around. If you need help with that let us know.

    Ian.

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,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans