Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics SL (Archived)

PJCONTRL - Can I replicate the between master companies in different databases?

Posted on by Microsoft Employee

We recently created a new app database, will call that database B.  We also are creating a separate master company in Database B.  It is basically a clone of the master company in database A.  We have about 65 items that are different in the Control Parameter Maint.  Can we simply update PJCONTRL table with the difference from one company to another?

As always, any help is much appreciated!

Thanks

*This post is locked for comments

  • RE: PJCONTRL - Can I replicate the between master companies in different databases?

    Dear Nathan,

    The control parameters are usually setup records. It is best to change anything that updates the control from the originating screen that writes the record to the table. There are some that are user created, but there are entries that are specific to a particular position in the grid on the screen, most of the time a Y in line one position 1 is not an issue..it's when there is a Y in position 15 and an N in position 18 (for example) that can cause a problem, so updating them in the table might not get the results you want, you may end up going into the screen and re-entering the control anyway. I'd go with changing the controls directly in the maintenance screen or from the originating setup screen.

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans