Small and medium business | Business Central, N...

SHARING ITEM LIST IN DIFFERENT COMPANIES

(0) Share

Report

Posted on by Dan_

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.

All responses (3)

Answers (0)

Suggested answer

DAnny3211 9,276 Moderator on at

Like (1)

Report

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

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

check my answer if it helped you, thanks

DANiele
Suggested answer

Steven Renders 5,500 Moderator on at

Like (1)

Report

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

Manan_Shah 1,459 on at

Like (1)

Report

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