Skip to main content

Notifications

Microsoft Dynamics NAV (Archived)

Sharing contacts between companies

Posted on by Microsoft Employee

Hi there.

I've created a new company inside the same database as other companies. As this company needs to have the same contacts I looked for a solution in google. Many people say that they solve this using "DataPercompany" = no, but other ones say that it's better synchronize tables using programming with CHANGECOMPANY method.

What do you think about?

*This post is locked for comments

  • MS Dynamics NAV Profile Picture
    MS Dynamics NAV 55 on at
    RE: Sharing contacts between companies

    You can share in your new company by using make some code for insert or modify  contact in new company when you perform activity in old company.

    Do not use DataPerCompany option.

  • Verified answer
    Miguel Llorca Profile Picture
    Miguel Llorca User Group Leader on at
    RE: Sharing contacts between companies

    Hi Victor! Avoid using "datapercomany" = no, use this method as your last option. You'll solve your problem today, but you'll have tons of new problems in the future (upgrades, etc.). (En resumen...yo no lo haría ni de coña :-))

    Good luck!

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Sharing contacts between companies

    Thank you. In those cases I though to copy records cause it's not data that usually change like "Salutation Code" or "Post Code"...or "Territory Code".

    My main problem is to know if it's neccesary to change "DataPerCompany" to "No" in Vendor, Customer, etc and other related tables to Contact table, because there are other companies in database which have the same "No. serie" field and they would overlap with each others.

    Other question is about what will happen when we migrate NAV 5.1 to NAV 2013 R2?. Will this be (sharing tables) a problem?

    Cheers.

  • Suggested answer
    Mohana Yadav Profile Picture
    Mohana Yadav 59,135 Super User 2024 Season 2 on at
    RE: Sharing contacts between companies

    If you have to set "DataPercompany" = no for contact table then make sure that you have to set DataPercompany to all related tables which are used in Contacts.

    ex: There is a field Territory Code in Contact table which has TableRelation to Territory table.

    If you don't set DataperCompany to No for Territory table then you wont see data when lookup on Territory Code.

    similarly, you can get errors while doing some process.

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!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,240 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans