Application Studio: MES set co Part Current Value using data Rules

Kinetic ERP
1

hi Folks
I am Using application studio for MES customisation, and i am trying to update the current qty of the Co-parts (Grouped/nested jobs) to automatically be the ProdQty from the JobProd Table using a data rule.

i can add the data view ok, but i am struggling to see how to join this to the ReportQtyPart data view, where the Current Qty resides.

ReportQtyPart has no company/job details and seems to just join to the Data view ReportQty (which only has Jobnum and Company) using EmpID.

Does anyone have any ideas what is the most efficient way of doing this?

cheers

Mal

2

that’s a cool idea Mal! I wish I did know how to do this cause I’d do it to!