+6
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.
Best answer by Tomas Ruderfelt
View originalHi,
What kind of inventory transaction (i.e. Transaction code) are you referring to?.
Regards,
Pilar
+6
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?
+6
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 '%'
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
