Solved

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

  • 20 December 2022
  • 2 replies
  • 156 views
Dharshan
Rank
Userlevel 1
Badge +4

Hi All,

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

Thanks,

Dharshan

icon

Best answer by AsankaGaru 3 January 2023, 11:08

View original

2 replies

A
Rank
Userlevel 6
Badge +11

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
Rank
Userlevel 1
Badge +4

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

Reply


Terms & ConditionsCookie settings