
Hi All,
I'm trying to find a relation between the WMSShippment Table and the CustinvoiceJour Table to find what shipmentID is related to which invoiceID.
I have check CustinvoicePacking but cant find any relation between the 2.
Any idea how to get this info?
*This post is locked for comments
I have the same question (0)Hi
You don't have a direct relation to CustInvoiceJour. You can try to related it through WMSShipment >> WMSOrderTrans >> InventTrans >> Here you can get the Invoice Id, I believe and find the CustInvoiceJour record.
Let me know if this works