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)

Sort by

Suggested answer

Gunjan Bhattachayya 35,423 on at

Like (0)

Report
Copy link

Link copied!

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,363 on at

Like (0)

Report
Copy link

Link copied!
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
Copy link

Link copied!

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