Finance | Project Operations, Human Resources, ...

Cannot locate data source record of type TableB with RecId 5637146077. Entity name: XXX, RecId: 5637234576, Database operation: Update.

(0) Share

Report

Posted on by devgirlX

100

Hi,

I have the Data entity with two datasources related.

Main entity datasource (TableA) is actually a table related to multiple tables (e.g. TableD, TableB, TableC) with refRecId and refTableId.

I created a data entity for exporting data from TableA but only records related to TableB.

The thing is that TableA is multicompany (save data per company = no) and TableB is company specific (save data per company = yes).

I want this data entity to be multicompany, so I can export and import data from one legal entity to all legal entities.

Exporting data is not a problem, it exports all records from multiple legal entities. Also, when I am importing new records, it is also ok.

But when it comes to update, I am getting error:

Cannot locate data source record of type TableB with RecId 5637146077. Entity name: XXX, RecId: 5637234576, Database operation: Update.

Any help?

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

Ziyao on at

Like (0)

Report

Hi,

As you mentioned Table A is actually shared data table, but Table B is company specific. When you try to update a record in Legal entity B, but currently you are in legal entity A, then system will only query this record in legal entity A for table B. Which will give you an error that record can not be found. In such case, you need to considering "Cross Company" behavior.

For detail information, please refer to below link:

docs.microsoft.com/.../cross-company-behavior

Was this reply helpful? Yes No
devgirlX 100 on at

Like (0)

Report

[quote user="Ziyao"]
Hi,

As you mentioned Table A is actually shared data table, but Table B is company specific. When you try to update a record in Legal entity B, but currently you are in legal entity A, then system will only query this record in legal entity A for table B. Which will give you an error that record can not be found. In such case, you need to considering "Cross Company" behavior.

For detail information, please refer to below link:

docs.microsoft.com/.../cross-company-behavior
[/quote]
Hi Ziyao,

Yes, ofcourse, I agree, I just forgot to say that I have overriden methods: mapEntityTODataSource, findEntityDataSource, updateEntityDatasource where I am using crosscompany query to find specific record and it finds it for update, but sometimes later in some data entity's methods it is searching again for that record and not using cross company ofcourse, so it overwrites my record which I found using cross company query.

I tried this now (from the link you provided):

But now update works and for insert I am getting the error that matching record does not exist.

Was this reply helpful? Yes No
Ziyao on at

Like (0)

Report

Could you please describe a little more about the error "matching record does not exist" for inserting?

Was this reply helpful? Yes No

Join the conversation

Community site session details

Cannot locate data source record of type TableB with RecId 5637146077. Entity name: XXX, RecId: 5637234576, Database operation: Update.

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

Cannot locate data source record of type TableB with RecId 5637146077. Entity name: XXX, RecId: 5637234576, Database operation: Update.

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates