I am trying to set a User Defined Checkbox in the JobProd table to True if a User Defined Checkbox in OrderDtl is set to True. I am thinking that the JobProd table is the right place to do this beings that it contains the order number, order line and job number. Is it correct to assume that this is the right place?
Details: Sales Team wants to be able to flag a job as Post Production Inspection Required. In my head this means that the sales team will flag an order line as “Post Production Inspection Required” and as a result of the flag being set to true, I can set the flag of the a user defined checkbox of the corresponding order, order line in the Job Prod table to True. If the condition of the user defined checkbox is true then when the product is complete Quality will be notified and will inspect the part prior to shipping. I haven’t worked out the end of this yet because I am unable to get the JobProd checkbox to change based on the condition of the OrderDtl checkbox.
I have accomplished something similar in the past for checking a user defined checkbox on the Part table to flag Inspection Required on the PODetail table using a Data Directive BPM Query. The query is as follows:
“Number of rows in the query is not less than 1”
‘’’’<for each ttPODetail no-lock , each Part no-lock where (Part.Company = ttPODetail.Company and Part.PartNum = ttPODetail.PartNum and Part.Checkbox10 = ‘True’)>’’’’
“Set the PoDetail.RcvInspectionReq field of the changed row to “True” expression”
I am trying to use the above method to accomplish the same thing but it is not working. Any ideas?
Thanks for any help