SO_AdditionalPackingListWrk doesn't have a LineSeqNo field but does have a LineNumber field. Both are 14 characters long according to the FLOR. I am not sure off the top of my head if the LineNumber is going to actually be the LineSeqNo from SO_InvoiceDetail or if it is a new number calculated on the fly when populating the work table. If it actually is the LineSeqNo, then technically, you should be able to use it for on the fly report to link to SO_InvoiceDetail to get the LineKey and then to SO_InvoiceTierDistribution on the LineKey to get the distribution info. What you would have to avoid is rely on cases where you would expect the LineSeqNo to remain the same, such as if you sourced it to the SO_InvoiceTierDistribution table into a UDF because the business object is not going to update the UDF in SO_InvoiceTierDistribution if a line is inserted/reordered. I suppose you could always use a pre-write event script on SO_InvoiceDetail to keep the UDF in SO_InvoiceTierDistribution in sync with its line and then you would only have to include SO_InvoiceTierDistribution in your sub-report vs having to include both SO_InvoiceDetail and SO_InvoiceTierDistribution in the sub-report. Although I can't imagine either table would ever get large enough to cause performance issues so it may not be worth concerning yourself over those two tables being joined in a sub-report.
EDIT: bad news, it appears the LineNumber field is calculated on the fly and does not equal the LineSeqNo.
To make matters worse, you can't even add a UDF to the SO_AdditionalPackingListWork table to source either LineKey or LineSeqNo from SO_InvoiceDetail.
I also tracked to see if a sourced UDF could be added to SO_PackageTrackingByItem and it doesn't even allow sourcing UDFs and since its primary key is InvoiceNo+PackageNo+ItemCode, it doesn't look like it was designed to be tracked at an individual line level but rather combines lines by item code.
------------------------------
David Speck II
Tennessee Software Solutions
------------------------------
Original Message:
Sent: 06-15-2022 17:50
From: Greg Stiles
Subject: Adding Serial Numbers to SO Additional Packing List
Yep, not going to work. Thanks @Kevin Moyes.
------------------------------
Greg Stiles
S & W Microsystems
------------------------------
Original Message:
Sent: 06-13-2022 19:49
From: Kevin Moyes
Subject: Adding Serial Numbers to SO Additional Packing List
LineSeqNo is the line sort order, and will be different than LineKey if you insert a line, or re-order the lines.
------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.