Testscrap.baq (36.8 KB)
Trying to produce a single column that would represent either the part and Co-part, I have tried adding a calulated field
case when laborpart.partnum = ‘ ‘ then jobhead.partnum else laborpart.partnum
But that did not do what I expected.
Basically, trying to get one column for the following:
Employee
Date
Shift
Parts
Reason code
Standard cost
Scrap Qty
Name
Customer – This will need to pull from part master since we have a UDF field for customer statics group.