Add Tracking information to SO Invoice form
I've edited mine extensively, but let's assume you've included the SOOrder table in your joins on the invoice report and start from there, so we don't bloat this post:
Additional Table Join #1:
SOOrder LeftJoin SOOrderShipment
OrderType (prevents collisions should you have two types with identical numbering schemes)
Additional Table Join #2:
SOOrderShipment LeftJoin SOPackageDetail
From here, you should have access to all your line level items shown under: Shipments -> Packages. If this is not what you needed, let me know and I'll try to dig around a bit more for you. This unlocks fields such as: SOPackageDetail.TrackNumber and SOPackageDetail.CustomRefNbr1.
I ran these joins in a Generic Inquiry as a test (we don't use the packages tab in my company). If for some reason the report writer won't accept the logic above, I'll edit my invoices report directly and send you screen shots, just let me know if anything is amiss.
Data Analyst - SilkCraft