How To Create A Company In Microsoft Dynamics GP 2010

Microsoft Dynamics GPIn the last post, I showed how to configure the server of Microsoft Dynamics GP by creating the System database. In this post I’m going to run through the company creation process.

To create the company, open GP Utilities (Windows Start menu » All Programs » Microsoft Dynamics » GP Utilities) by right clicking and select Run as Administrator. Log in as the SQL System Administrator (sa);

Welcome to Microsoft Dynamics GP Utilities

The first page of GP Utilities is just a welcome blurb explaining that GP Utilities is used to set up or upgrade Microsoft Dynamics GP;

Welcome to Microsoft Dynamics GP Utilities

GP Utilities will check that the system database version matches the version of GP Utilities;

Upgrade Microsoft Dynamics GP

If there are companies already in the system they will also be checked. If the companies match the version or if there is no companies currently created, GP Utilities will progress to the Additional Tasks page where you can select to create a company in the combo. Once you’ve selected this option, click the Process button;

Additional Tasks

Enter a database/Company ID and Name. The Company ID is restricted to five characters which can include letters and numbers. The Company Name can be longer and should be set to the companies legal name (as it can be used on report and form outputs from the system).

If you’re creating a test system enter <TEST> at the end of the company name which will cause a warning to be displayed to the users when they log into the test company.

You can also choose to load the shipping methods and payment terms as well as a default chart of accounts.

The final option is the ability to copy access from an existing company which will reduce the amount of work needed to give users access to the new company;

Create Company

Accept or alter the default entries for the location of the data and log files of the company database;

Database Setup

Check the creation options and confirm the company should be created;


Choose whether the Microsoft SQL Server Reporting Services reports and the Excel reports should be deployed;

Business Integlligence Reports Setup

If you selected to deploy the SQL Server Reporting Services Reports you’ll be prompted to pick the Report Server Mode and the report server and manager URLs. These will be defaulted in from the settings defined when the System was configured but can be changed as required.

Before deploying the SQL Reporting Services reports make sure the maxRequestLength has been corrected;

SQL Server Reporting Services Reports Setup

Enter the location and Network Share to be used for deploying the Excel Reports. The share location should be entered using a UNC path to a shared network location rather than a mapped drive;

Excel Reports Setup

Confirm the selections are accurate, but before deploying the SQL Reporting Services reports make sure the maxRequestLength has been corrected (as described mid-way down the linked post);

Verify SQL Server

The report deployment will take a short time to run through but will display progress bars to show progress;

Business Intelligence Deployment Progress

Choose whether to set up the company later, to set it up using the configuration wizard or to migrate existing data using the migration wizard.

I’ve selected the set up company later option as I always do the configuration manually to make sure it is as required;

Company Setup Options

After selecting the previous option, I was returned to the Additional Tasks window where I can either create another company or alternatively click Launch Microsoft Dynamics GP to start GP;

Additional Tasks

Can ISC Software help?

ISC Software Solutions are UK and Ireland based experts on Microsoft Dynamics GP. If you would like to speak to someone about support, consultancy, upgrades, implementation, development, GP Elementz add-ons or portals, or anything else Dynamics GP related, you can use the form below.

Your Name

Your Email


Your Enquiry

What should we write about next?

Your Name

Your Email

Suggested Topic

Suggestion Details

2 thoughts on “How To Create A Company In Microsoft Dynamics GP 2010

  1. Pingback: Comment
  2. Pingback: Comment

Leave a Reply

Your email address will not be published. Required fields are marked *