Link between shipment and invoice?

On receipt of goods there is a “Receipt Reference” field into which you can enter the consignment note ID of the delivery, If you can make the supplier enter the same consignment note ID on to the invoices then you can set the Invoice Matching parameter to match by Receipt Reference.

/Jonas

@bcardellini AFAIK, there is no standard relationship between these objects, customer order lines, shipments and invoices. Therefore unless you embed these details to your business process, there is no function from the system.

@bcardellini I have to agree with Buddihika!
I did a check on our BI solution which combines CIL (joined to COL), combined with shipments.
I don’t want to go too deep into details but state the following:
You can have ShipmentIDsConcat in the COL
 

We see in this example the corresponding 2 invoices:
 

In a “master” FACT_Sales we join CIL “back” to COL and you can see ShipmentIDs there as well.
 

So at least you will see the original CO and the corresponding ShipmentIDs on the ivoice side.

Hope that brings you to new ideas.

All the best

Michael

@bcardellini If you are in apps 10 there is a reference to the shipment id on the customer invoice screen. 

Hi @bcardellini , adding to @spetkus27‘s reply, even in IFS Cloud you can find a reference to the Shipment ID from the Customer Invoice, as shown below.

Regards,
Kethaka

Thanks to @spetkus27 we did some research in Views and tables.
Follow the white rabit! (upps sorry, wrong movie)
Follow   CUST_ORDER_INV_HEAD_UIV_ALL to

              CUST_INVOICE_PUB_UTIL_HEAD_ALL

Look for field N3 in the INVOICE_TAB.

You will find the shipment_id.

:-)

After more report development I realized I needed a way to identify the right shipment for a particular invoice line, not the other way around.  I was told an invoice can be for multiple shipments, so I guess I need to do this at the line level.  I believe I have a solution in place using customer order deliveries

invoice i
join invoice_item ii on ii.invoice_id = i.invoice_id
join cust_delivery_inv_ref cdir on cdir.invoice_id = i.invoice_id and cdir.item_id = ii.item_id
join customer_order_delivery cod on cod.deliv_no = cdir.deliv_no
join shipment s on s.shipment_id = cod.shipment_id
join customer_order_line col on col.order_no = cod.order_no and col.line_no = cod.line_no and col.rel_no = cod.rel_no and col.line_item_no = cod.line_item_no
join customer_order co ON co.order_no = col.order_no

Thanks all for the assistance! 

@bcardellini This will work in more situations actually. This picks up collective invoices(which will not populate the shipment field) as well as shipment invoice flow invoices.