Skip to content
  • Home
  • About Me
    • Disclosure
    • Consultant’s Toolbox
  • Solutions
    • Dynamics 365
    • Dynamics GP
      • GP 2018 Toolbox
    • Dexterity
    • Royalty Management System
    • Franchisee Portal
  • Contact Me

Microsoft Dynamics Discussions

A Technology Blog discusses Microsoft Dynamics Solutions
Menu
Facebook Twitter Google+ LinkedIn
  • Home
  • About Me
    • Disclosure
    • Consultant’s Toolbox
  • Solutions
    • Dynamics 365
    • Dynamics GP
      • GP 2018 Toolbox
    • Dexterity
    • Royalty Management System
    • Franchisee Portal
  • Contact Me
Home  /  Dynamics GP • General  /  Error : “The selected company is not configured as a company of the current Microsoft Dynamics GP system database. You must resolve the database configuration to log in to the company”
PostedinDynamics GP, General Posted on April 10, 2018

Error : “The selected company is not configured as a company of the current Microsoft Dynamics GP system database. You must resolve the database configuration to log in to the company”

Posted By Samuel Mathew

Problem:

Recently while I was working on merging two different GP instance as part of a company acquisition. Initially, I had to bring one company to match the other company GP installation such as GP release and service pack. Then I was able to create a shell company in “GP instance 1” and restored the backup from “GP Instance 2”. Then ran the GP Utilities to synchronize the account framework. But while launching GP application, I received the following error message:

“The selected company is not configured as a company of the current Microsoft Dynamics GP system database. You must resolve the database configuration to log in to the company”

Cause:

This is due to the fact that when I created a shell company in “GP Instance 1”, GP system assigned a “CMPANYID” in SY01500 table in the system database. But when I restored the backup of the company database from “GP Instance 2”, the company ID in the company database was not matching to the system database.

Solution:

Use the following SQL Queries

Select

Transact-SQL
1
2
3
4
5
6
7
8
--Repleace DYNAMCIS with correct System database name
USE <'Database ID of the COMPANY created'>
GO
 
--Script 1
select INTERID, CMPANYID, * from DYNAMICS..SY01500 where INTERID='Database ID of the COMPANY you created'
--Script 2
select * from SY00100

Compare the CMPANYID values from both results. CMPANYID in SY001000 (Script 2) table must match with the CMPANYID value in SY01500 (Script 1).

1
2
UPDATE SY00100
set CMPANYID = (select CMPANYID from DYNAMICS..SY01500 where INTERID='Database ID of company you created')

I hope this will be useful.

Tags: GP SQL Script
Previous Article
Microsoft Dynamics 365 Business Central – Pricing Announced

About Author

Samuel Mathew

Software developer acknowledged for talents conceptualizing and directing the development and continuous refinement of advanced technology solutions to meet clients’ needs. Sophisticated programming knowledge combines with well-honed problem-solving strengths to meet the challenges of business economics, client needs, and technical innovation.

Facebook Twitter LinkedIn

Related Posts

  • Complete List of Versions information of Dynamics GP 2018

    February 12, 2018
  • Microsoft Product Lifecycle Policy

    February 2, 2018
  • GP 2018 Toolbox

    December 2, 2017

1 Comment

  1. Pingback: Error : “The selected company is not configured as a company of the current Microsoft Dynamics GP system database. You must resolve the database configuration to log in to the company” - DynamicAccounting.net

Social Media

  • Facebook
  • Twitter
  • Google+
  • Pinterest
  • LinkedIn
  • GitHub

Samuel Mathew

Software developer acknowledged for talents conceptualizing and directing the development and continuous refinement of advanced technology solutions to meet clients’ needs. Sophisticated programming knowledge combines with well-honed problem-solving strengths to meet the challenges of business economics, client needs, and technical innovation.

Dynamics 101 – Top 20 Dynamics GP blogs

Categories

  • Dexterity
  • Dynamics 365
  • Dynamics GP
  • Featured
  • Franchisee Portal
  • General

Recent Posts

  • Error : “The selected company is not configured as a company of the current Microsoft Dynamics GP system database. You must resolve the database configuration to log in to the company” April 10, 2018
  • Microsoft Dynamics 365 Business Central – Pricing Announced March 20, 2018
  • Announcing Microsoft Dynamics 365 Business Central March 14, 2018
  • Complete List of Versions information of Dynamics GP 2018 February 12, 2018

Social Media

  • Facebook
  • Twitter
  • Google+
  • LinkedIn

Administration

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org

Tags

Development Dexterity Dynamics 365 Dynamics GP Environment Featured GP GP 2013 GP 2016 GP 2018 GP Web Client Installation Microsoft Dynamics Microsoft SQL Server Multi-tenant Product LifeCycle SmartList SmartList Designer SQL Reporting Services SQL Script

Category Posts

  • Exciting Announcement : New Blog Design November 1, 2017
  • Microsoft Dynamics Roadmap 2018-2019 April 5, 2017
  • Microsoft Dynamics GP 2016: Lifecycle and Upgrade Services June 17, 2016

Subscribe

© Copyright 2017 Samuel Mathew.  All rights reserved.