Hi Experts,
There is a customer order invoice which was created as a collective invoice.
One order with single line and 2 separate shipments were made. One invoice was created for both the shipments using the ‘Collective invoice’ functionality.
The customer invoice has only one line for both the shipments and my question is whether there is a way to find out the connected shipments for this invoice line. Or is it possible to find out the Invoices created from the given shipments.
Thanks.
I think the table you are looking for is cust_delivery_inv_ref_tab (reference between delivery and invoice), shipments are in customer_order_delivery_tab (and this table is referenced in inventory_transaction_history)
I have used these two tables to connect transaction history record (with costs of goods sold) to invoice line with sale value, creating margin report.
Thanks a lot Adam. I will check this. Really appreciate your time on this.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.