Solved

How to find the relevant shipment IDs for a given invoice. (One Customer order line - Multiple shipments)

  • 19 July 2023
  • 2 replies
  • 121 views
K
Rank
Badge +4

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. 

icon

Best answer by Adam Bereda 19 July 2023, 16:21

View original

2 replies

A
Rank
Userlevel 7
Badge +16

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.

Regards, Adam
K
Rank
Badge +4

Thanks a lot Adam. I will check this. Really appreciate your time on this. 

Reply


Terms & ConditionsCookie settings