Announcement

Collapse
No announcement yet.

Link Shipment to Jobs

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Link Shipment to Jobs

    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?
    Chris Starks
    Deloitte Consulting

    [email protected]
    www.deloitte.com

  • #2
    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.
    James Foran
    Toll Global Information Services
    http://www.tollgroup.com

    Comment


    • #3
      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?
      Chris Starks
      Deloitte Consulting

      [email protected]
      www.deloitte.com

      Comment


      • #4
        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.
        James Foran
        Toll Global Information Services
        http://www.tollgroup.com

        Comment

        Working...
        X