If you want a consistent line reference to the SO details, use the invoice detail table's "OrderLineKey" value.  (Pass it through to the work table using a UDF).

The LineKey in the invoice detail table is the key for the invoice lines, not a reference to the SO detail LineKey.

If you want a consistent line reference to the SO details, use the invoice detail table's "OrderLineKey" value.  (Pass it through to the work table using a UDF).

The LineKey in the invoice detail table is the key for the invoice lines, not a reference to the SO detail LineKey.

Good point. I was only thinking about docs printed off sales order data but anything done from invoice data should indeed use the OrderLineKey for consistency with the sales order.

Hello Kevin,

Thank you for your help. The OrderLineKey pulls into the SO_InvoiceWrk table and prints as expected.

The issue I am still having is this only works the initial time an invoice is printed. if an invoice has to be reprinted more than once it goes through the AR_InvoiceHistory table and uses the same report but it does not seem to populate the report with field that had been applied in the report.

Any ideas or suggestions on how the issue could be resolved.

We have added the UDF to the following tables.

SO_InvoiceWrk

SO_PackingListWrk

SO_ShippingHistoryWrk

AR_InvoiceHistoryDetail

AR_InvoiceHistoryWrk

AR_InvoiceWrk

Thanks,

Brad

The invoice work table has multiple business objects, depending on where you are printing from.  You'll have to set up a UDF so the OrderLineKey flows to invoice history detail during posting, then configure the source for printing from history, on tab 3 for your work table UDF.