Data Validation VendPart.BaseUnitPrice = Part.UnitPrice

Hello,

We are trying to add checks in place so that an item in VendPart has a corresponding Part in PartMaster and has the same Price in both tables. Right now, the tables have no link between the two. My first thought was to create a Data Directive for this, which works great for Making sure the part exists in Part Master when added, but I have not figured out how to bring over the corresponding UnitPrice.
image
image
Got this code from another thread, no errors, but doesn’t work when a new row is added.

As a note, I am new to Epicor and have just started tinkering with BPM’s so there could very well be something I’m missing.

Thank you!

Also, I have tried using Update Table by Query but mapping ttPartNum to Part.PartNum and ttBaseUnitPrice Part.UnitPrice did not do anything