Skip to main content

Hello everyone.

Does anyone know? What is the key between the inventory transaction history table and the sales invoice lines. The customer's order_no alone is not enough, because many invoices can be issued to it.

Hi,

What kind of inventory transaction (i.e. Transaction code) are you referring to?. 

Regards,

Pilar

Not a transaction code. How to find inventory transactions (transaction_id) with sales invoice number?

There is no direct connection.

You can go via OUTSTANDING_SALES to CUSTOMER_ORDER_DELIVERY.

But to explain more in detail, what is the purpose for doing this? What are you trying to achieve?

There is no direct connection.

You can go via OUTSTANDING_SALES to CUSTOMER_ORDER_DELIVERY.

But to explain more in detail, what is the purpose for doing this? What are you trying to achieve?

Thank you, that was it. I didn't notice the source_ref5 = deliv_no binding. Goal achieved, having the invoice number I can identify warehouse transactions.

 

select * 
from INVENTORY_TRANSACTION_HIST2 ith
left join CUSTOMER_ORDER_DELIVERY cod on source_ref5=cod.deliv_no
left join OUTSTANDING_SALES os on os.deliv_no=cod.deliv_no
left join CUST_ORDER_INV_ITEM_UIV_ALL coi on os.invoice_id=coi.invoice_id and os.item_id=coi.item_id
where coi.invoice_id='358073' and coi.item_id like '%'

Reply


Terms & ConditionsCookie settings