Link between Shipment and Invoice

Angele

Dear all,

I have a number of Shipments that were combine - invoiced using the "Get Shipment Lines" functionality in the Invoice.

From the Shipment document, is there an easy way to find the corresponding Invoice No?

Should customization be unavoidable, which is the field in the Sales Shipment Lines table that can serve me as a link for filtering the Sales Invoice Lines? ](*,)

Regards,

kriki

I am afraid there isn't an easy way.
The wat to folow is:

In the shipment line, you have field 39:"Item Shpt. Entry No.". This is the Item ledger entry no. of the shipment.
Now you have to search in table 5802:"Value Entry" with that "Item Ledger Entry" to find it's value entries. Take the record where "Expected Cost"=FALSE. This should be the invoice no.

ngebhard

How do you post? Out of an order or out of invoices? If using the order should actually be able to use the field order no. in the sales shipment and sales invoice header. But this only works fine if there isn't any partial shipment. Otherwise try krikis way ...

Angele

Thank you for the reply. Alain's suggested solution was the answer to my question.

ara3n

The modification we did for our client, because they were using get shipment all the time was to get the shipmen no to the sales invoice line and then post it to posted sales invoice line.