Hi Brett,
Firstly, the work type lives on the work order, so you'll be looking for WORKORDER.WORKTYPE. There is a couple of relationships from LABTRANS to WORKORDER... errr let's go for the one named WORKORDER.
So, in the attribute, you'll use WORKORDER.WORKTYPE.
As for the ROS, you cannot simply add the WORKTYPE to the object, but you can add the work order as a child object using the above relationship.
If you wish to actually have the WORKTYPE on the LABTRANS object, then you need to a) add a new field to capture the value, b) add a crossover domain from the work order to labtrans c) register the domain on the new field.
------------------------------
Craig Kokay
Principal Consultant
COSOL
email:
craig.kokay@cosol.global#IBMChampion
------------------------------
Original Message:
Sent: 02-09-2024 13:09
From: Brett Hawkins
Subject: Adding worktype to Labor reporting
Hello All,
I am looking for a solution to add the WORKTYPE field to labor reporting as I am often asked for labor hours by work type. I have attempted to add a WORKTYPE field using application designer, but I get the invalid binding error. I am assuming I am either using the wrong WORKTYPE attribute, or I need to create a relationship somewhere first. The Labor Reporting application already pulls the WO # so I figured I would be able to also pull in the WORKTYPE from the WO. Is this something that is possible?
I'd also like to be able to create a QBR report in the Labor Reporting application which can be filtered using WORKTYPE, but I can't seem to figure out how to access the WORKTYPE attribute when creating the report. Again I would assume that I need to build a relationship for this, but unsure of how to go about doing that.
Thanks in advance!
#Administration
#Reporting
------------------------------
Brett Hawkins
LVCVA
------------------------------