Link Shipment to Jobs

[james_foran]

Re: Link Shipment to Jobs

I think the JOB_GID in the SHIPMENT table is a legacy item. I think it is now possible to have multiple JOBS against a single shipment. As a result, OTM cannot populate this automatically.

[cstarks]

Re: Link Shipment to Jobs

James... I was kind of afraid you were going to say that. After I posted my original message, I updated the shipment table via sql and populated the Job Gid field with the necessary ID. This worked, and the search for shipments brought back the Job.

Don't you think it's kind of strange that this doesn't occur automatically?

[james_foran]

Re: Link Shipment to Jobs

I think your issues is that there is a JOB_GID in the SHIPMENT Table, but this is not being used. Rather, OTM is linking shipments to a JOB via the ORDER_RELEASE or ORDER_MOVEMENT.

If you want to allow searchability, perhaps look at creating an agent that populates the JOB_GID in the SHIPMENT from the JOB_ORDER_RELEASE_JOIN table.

[cstarks]

You can build jobs using the shipment actions button. You can also add Job ID to the shipment screen set and search field.

However, when you search on a shipment that has a job attached to it, nothing appears in the Job ID field. You can also enter a Job value into the Job field on the shipment search screen, and no shipments will be returned.

Looking in the database, I don't see any fields that link the shipment and the job. Any idea of how you could do this?