Update Table by Query

[rppmorris (ROBERTO MORRIS)]

I want to update the Part.UnitPrice either when transaction of type ADJ-CST occurs or when a purchase receipt occurs.
I have tried the following so far but cannot get it to work:

Can anyone assist?

[Aaron_Moreng]

The trick with Update Table by Query is that you need to think of it as a tool to assist in populating a tableset with a BAQ, but you don’t need to use all of the BAQ values to do so. You could use variable values or hard coded values too when setting the tableset.
In your case, you are hydrating the PartTableset with this but you aren’t setting the key fields for it make a valid record. Additionally, you’d need to set the RowMod typically to “U” (for an update) for it to take.

[rppmorris (ROBERTO MORRIS)]

AARON:

Thank you - this is now working.

[JPoston (John Poston)]

I was missing RowMod for similar issue. That was the key. Thank you @Aaron_Moreng.