I’m trying to create a Dashboard to know all jobs created using Job Split, i found this field in JobHead table, but this is just a flag that indicates that this is a job split, my question is, Is there a way to know which job a split job came from?
The table JobAudit stores a record of the job number that was split to, and on the split job, the job number it was split from. Unfortunately, the split job number is held in at the end of a text field (Change Description). Fortunately, you can snag it with a text string expression. take the right number of characters from the description. You might have to use the colon as a delimiter to split out your job number.
This is not ideal. You could always write a BPM to store the split job number at the JobHead table in a custom field.
Good luck!
Nate
1 Like
What is the reason behind doing this or caring about what job a job was split from? Interested in learning about what other businesses are dealing with.
1 Like
We just add a letter at the end to the job number when splitting a job. so the number will always be the same with an “A” at the end for the split job. if you need to split it again its “B”. Its a simple way to always know what was the original.
3 Likes
It might be needed if you are chasing a job on the shop floor or if you have job travelers out on the shop floor you need to go get and replace with 2 new ones.
1 Like
Very nice, practical way of doing this Craig!
1 Like
We do this too.
1 Like