Finance | Project Operations, Human Resources, ...

how to set datasource in entity not shared between companies?

(0) Share

Report

Posted on by BASMA

932

Hello,

I create extension of standard entity"EcoResProductLifecycleStateEntity"

the table "EcoResProductLifecycleState" is shared between companies

I add 2 datasources which has relations with this table "EcoResProductLifecycleState" :

so I want that these datasources are not shared between companies

have you any idea !!

I have the same question (0)

All responses (8)

Answers (0)

Suggested answer

GirishS 27,833 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi Basma,

I don't think you can set the shared between companies' behavior in data entities.

It will be set up at table level with the property named "Save Data Per Company" - If the Save data per company is set to No then data will be shared across all the companies. If it is yes, it will store data against each company.

Thanks,

Girish S.

Was this reply helpful? Yes No
BASMA 932 on at

Like (0)

Report
Copy link

Link copied!

thanks for reply ,

yes the tables has the property"save data per company'=yes

but when I try to export the entity I get the data of all companies

Was this reply helpful? Yes No
GirishS 27,833 Moderator on at

Like (0)

Report
Copy link

Link copied!

Check the below link and see if the Primary company context property is set with value instead of empty.

https://anithasantosh.wordpress.com/2021/06/11/export-data-from-all-legal-entities-using-dixf-d365-fo/

Thanks,

Girish S.

Was this reply helpful? Yes No
BASMA 932 on at

Like (0)

Report
Copy link

Link copied!

the property in the entity is empty :

Was this reply helpful? Yes No
Suggested answer

GirishS 27,833 Moderator on at

Like (0)

Report
Copy link

Link copied!

Type in DataAreadId in the Primary company context and check if it exports data against the current company where the export is triggered.

Thanks,

Girish S.

Was this reply helpful? Yes No
BASMA 932 on at

Like (0)

Report
Copy link

Link copied!

I have this error :

Was this reply helpful? Yes No
GirishS 27,833 Moderator on at

Like (0)

Report
Copy link

Link copied!

Sorry I never came across this error. EcoResProductLifeCycleState is global table (Save data per company - Set to No). Thats the reason why its throwing the error.

But I am not sure on this.

Wait for some other community members to have better look on this.

Thanks,

Girish S.

Was this reply helpful? Yes No
Suggested answer

Mohit Rampal 12,565 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi, Can you try adding DataAreaId field in the Data Entity Fields. Your primary datasource will not have it but add it from other datasource then set DataAreaId in Primary Company Context field. If you change the field name say from DataAreaId to CorollaryTableDataAreaId then set CorollaryTableDataAreaId in Primary Company Context.

Was this reply helpful? Yes No