Skip to main content
Solved

How to find the shipment ID related to the OESHIP inventory transactions

  • Dec 20, 2022 12:54 PM UTC
  • 3 replies
  • 447 views
Dharshan
Sidekick (Employee)
Forum|alt.badge.img+4

Hi All,

How to find the shipment ID related to the OESHIP inventory transactions through the application (App10) or database?

Thanks,

Dharshan

Best answer by AsankaGaru

Hi,

Source_ref_5 in the inventory transaction history for an OESHIP is the delivery no. You should be able to locate the shipment applicable for the delivery, using the delivery no (Deliv_no) in the CUSTOMER_ORDER_DELIVERY_JOIN.

(standard function form, Undo customer order delivery uses this delivery no, and you can see the shipment too in this form. ) 

Hope this helps

Asanka

View original

    3 replies

    Hero (Partner)
    Forum|alt.badge.img+12
    • AsankaGaru
    • Hero (Partner)
    • Answer
    • Jan 3, 2023 10:08 AM UTC

    Hi,

    Source_ref_5 in the inventory transaction history for an OESHIP is the delivery no. You should be able to locate the shipment applicable for the delivery, using the delivery no (Deliv_no) in the CUSTOMER_ORDER_DELIVERY_JOIN.

    (standard function form, Undo customer order delivery uses this delivery no, and you can see the shipment too in this form. ) 

    Hope this helps

    Asanka

    Asanka Garusinghe - https://www.linkedin.com/in/asanka-garusinghe-61634a64/
      Dharshan
      Sidekick (Employee)
      Forum|alt.badge.img+4
      • Dharshan
      • Author
      • Sidekick (Employee)
      • Jan 4, 2023 11:04 AM UTC

      Thank you @AsankaGaru, can find the shipment related to the OESHIP in the CUSTOMER_ORDER_DELIVERY_JOIN view.

      hhy38
      Superhero (Customer)
      Forum|alt.badge.img+16
      • hhy38
      • Superhero (Customer)
      • Mar 12, 2025 7:27 PM UTC

      Hi,

      Source_ref_5 in the inventory transaction history for an OESHIP is the delivery no. You should be able to locate the shipment applicable for the delivery, using the delivery no (Deliv_no) in the CUSTOMER_ORDER_DELIVERY_JOIN.

      (standard function form, Undo customer order delivery uses this delivery no, and you can see the shipment too in this form. ) 

      Hope this helps

      Asanka

      ​@AsankaGaru Thank you. :)

      Linkedin Profile: https://www.linkedin.com/in/hhy34/
      Terms & ConditionsAccessibility statement