Announcement

Collapse
No announcement yet.

Link Shipment to Jobs

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

  • james_foran
    replied
    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.

    Leave a comment:


  • cstarks
    replied
    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?

    Leave a comment:


  • james_foran
    replied
    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.

    Leave a comment:


  • cstarks
    started a topic Link Shipment to Jobs

    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?
Working...
X