Skip to main content
Solved

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

  • December 20, 2022
  • 3 replies
  • 377 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

3 replies

Forum|alt.badge.img+12
  • Hero (Partner)
  • 196 replies
  • Answer
  • January 3, 2023

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


Dharshan
Sidekick (Employee)
Forum|alt.badge.img+4
  • Author
  • Sidekick (Employee)
  • 9 replies
  • January 4, 2023

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
  • Superhero (Customer)
  • 326 replies
  • March 12, 2025

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. :)