Troubleshooting
Problem
PMDUEDATE from parent work order is not copied to the child work orders.
Symptom
I have a PM record with a Route. The route is set to generate Child work orders. Each entry on the route has its own Job Plan.
When the PM generates, it creates a parent work order with the PMNUM from the PM record however PMDUEDATE is not being copied to the child work orders.
Is there a way to copy the PMDUEDATE from the Parent work order to the Child work orders?
Resolving The Problem
It is possible to use an escalation to bring data from the PM generated parent work order.
During PM work order generation, a route stop id is displayed in the child work order. You can setup an escalation to poll those child work orders with routestopid populated and set the pmduedate to be the parent's pmduedate.
1. Create a new escalation:
applies to = WORKORDER
condition: parent is not null and routestopid is not null and pmnum is not null
schedule: 1m,*,*,*,*,*,*,*,*,*
NOTE: Any schedule can be set by clicking on the "Set Schedule" icon on the far right.
2. Click the "New Row" button to create an escalation point. There is no need to populate anything in this section:
3. Click on the "New Row" button to create an action.
Click the arrow next to the field to hyper-link to the Actions application:
4. Create a new action:
Object = WORKORDER
Type = Set Value
Value: :parent.pmduedate
Parameter/Attribute: pmduedate
Accessible From: ALL
Save the record.
Click "Return" at the top right hand corner to return to the escalation:
5. From the "Select Action" menu choose "Validate":
Click OK on system message: BMXAA1151I - Validation successful.
6. From the "Select Action" menu choose "Activate / Deactivate escalation".
The active check-box will be selected:
Testing:
Create a PM record with a Route. The route is set to generate Child
work orders. Each entry on the route has its own Job Plan.
Generate PM work orders:
BMXAA3208I - PM 1021 created work order 1227.
BMXAA4581I - Work order 1228 created for PM 1021 with a target start of 10/9/14 12:00 AM in apply route.
BMXAA4581I - Work order 1229 created for PM 1021 with a target start of 10/9/14 12:00 AM in apply route.
BMXAA4581I - Work order 1230 created for PM 1021 with a target start of 10/9/14 12:00 AM in apply route.
After the escalation has been run, all the child work orders will be populated with the parent's pmduedate
SELECT WONUM,parent,PMDUEDATE,REPORTDATE, ROUTESTOPID, ROUTE,PMNUM
FROM WORKORDER WHERE wonum in ('1227','1228','1229','1230')
Was this topic helpful?
Document Information
Modified date:
17 June 2018
UID
swg21686733