You’re offline. This is a read only version of the page.
Hello,
I went through the process of creating a new company attached to the existing system database.
-I added the company in company maintenance
-Restored the live db to the test db
-Ran the update views in Database Maintenance
-Synchronize security in Database Maintenance
Now i am able to sign into the test company. I can see master records. But i cannot see any transactions.
Help!
*This post is locked for comments
It doesn't sound like you have any transactions in the new test database associated with the new test company id.
You may want to consider creating a separate test system & application database from the production databases. Users would then switch system databases when they use the test environment. The company ids would not have to be changed in this type of test database.
Hi Brian,
I ran the update scripts as seen below but the Domain script failed. I will re-check and advise.
UPDATE COMPANY SET DatabaseName = 'XXXXXX' where DatabaseName = 'YYYYYY'
UPDATE DOMAIN SET DatabaseName = 'XXXXXX' where DatabaseName = 'YYYYYY'
Each record in the application database contains the company id, whether using multi-company or not. The system database contains setup information for those companies. From your description of steps taken, it sounds like the company with transaction detail in the testing copy of the application database doesn't have a matching company setup in the testing copy of the system database - domain and company tables.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (