Finance | Project Operations, Human Resources, ...

data couldn't update while update record set for crosscompany

(0) Share

Report

Posted on by Siddy Mujumdar

I want to update crosscompany data using update record set . I tried this below code, but it doesn't work.

TempTable.skipDataMethods(true);

TempTable.skipDatabaseLog(true)

;
TempTable.skipEvents(true);

update_recordSet crossCompany
TempTable
setting vendPackingSlipJour = vendPackingSlipJour.RecId,
vendPackingSlipTrans = vendPackingSlipTrans.RecId

join recId from vendPackingSlipJour
where vendPackingSlipJour.PackingSlipId == TempTable.PackingSlipId
&& vendPackingSlipJour.DeliveryDate == TempTable.DatePhysical
join recId from vendPackingSlipTrans
where vendPackingSlipTrans.VendPackingSlipJour == vendPackingSlipJour.RecId
exists join inventTransOrigin;
where inventTransOrigin.InventTransId == vendPackingSlipTrans.InventTransId
&& inventTransOrigin.RecId == TempTable.InventTransOrigin

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

Gunjan Bhattachayya 35,423 on at

Like (0)

Report

Hi Siddy,

Cross company does not work with update_recordset. Please check this thread -

community.dynamics.com/.../using-crosscompany-with-update_recordset

Was this reply helpful? Yes No
WillWU 22,361 on at

Like (0)

Report
Hi Siddy Mujumdar,

As mentioned above, you cannot use the crossCompany keyword in X SQL statements that modify data.

I rewrote your code, please try it.

while select crossCompany TempTable join vendPackingSlipJour where vendPackingSlipJour.PackingSlipId == TempTable.PackingSlipId && vendPackingSlipJour.DeliveryDate == TempTable.DatePhysical join vendPackingSlipTrans where vendPackingSlipTrans.VendPackingSlipJour == vendPackingSlipJour.RecId exists join inventTransOrigin where inventTransOrigin.InventTransId == vendPackingSlipTrans.InventTransId && inventTransOrigin.RecId == TempTable.InventTransOrigin if(TempTable) { TempTable.selectForUpdate(true); ttsbegin; TempTable.yourfield="yourfield"; TempTable.update(); ttscommit }

Refer to :https://docs.microsoft.com/en-us/dynamicsax-2012/developer/cross-company-data-modification-using-x

Was this reply helpful? Yes No
Suggested answer

mhdshb1 1,250 on at

Like (0)

Report

Hi Siddy,

In addition to what is mentioned, you can refer to this link

docs.microsoft.com/.../cross-company-data-modification-using-x

Regards,

M

Was this reply helpful? Yes No

Join the conversation

Community site session details

data couldn't update while update record set for crosscompany

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

data couldn't update while update record set for crosscompany

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