web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested answer

SHARING ITEM LIST IN DIFFERENT COMPANIES

(0) ShareShare
ReportReport
Posted on by 5

Hello,

I am having a client who wants to have  his list of items shared between two companies such that the item list is synchronized between the two companies.

I have tried using the DataPerCompany field option but am getting an error as  shown below:

Anyone whohas a workaround on this? Kindly help.

pastedimage1670903411368v2.png

I have the same question (0)
  • Suggested answer
    Manan_Shah Profile Picture
    1,459 on at
    RE: SHARING ITEM LIST IN DIFFERENT COMPANIES

    Hi Dan,

    Please try to debug it. Possible this error comes due to custom object.

    Many Thanks,
    Manan

  • Suggested answer
    Steven Renders Profile Picture
    5,672 Moderator on at
    RE: SHARING ITEM LIST IN DIFFERENT COMPANIES

    Do not use DataPerCompany, it is not supported in BC Saas, and Universal Code...

    I suggest to look for a third party solution that can sync data between companies, there are some good ones in appSource.

    Otherwise, I suggest to investigate the PowerPlatform, to develop a sync mechanism.

  • Suggested answer
    DAnny3211 Profile Picture
    11,382 on at
    RE: SHARING ITEM LIST IN DIFFERENT COMPANIES

    hello

    but you are working with nav

    did you create a custom table? or are you trying to put the DataPerCompany on the standard item table? this is not recommended

    if you create a YourItem table then in NAV you can set it as DataPerCompany=yes so that you have data common to all companies

    but the solution I recommend is to make or have made a development in which you simply synchronise items from one company to another

    an idea would be to bind to the OnAfterInsertREcord event of the item table and at that moment with a changecompany transfer it also to the other company

    pastedimage1670934377770v1.png

    remember that validates, however, do not click with the changecompany

    check my answer if it helped you, thanks

    DANiele

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
Rishabh Kanaskar Profile Picture

Rishabh Kanaskar 2,828

#2
Sumit Singh Profile Picture

Sumit Singh 2,617

#3
YUN ZHU Profile Picture

YUN ZHU 1,861 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans