In order to allow me to focus on Consulting (click here) and Courses (click here), I continue to review all posts here in the Forums, but, in general, I'm only personally responding to posts that I mark as #AcumaticaTnT (click here). For Questions (click here), others may respond, or you can post over at Community.Acumatica.com (click here).
Questions Add Tracking information to SO Invoice form
Has anyone been successful in adding the tracking information from the boxes tab of a shipment to the SO invoice form and if so how did you map the fields?
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.
Just make sure you do it as a Subreport since there could easily be more than one Package for a given Shipment.
You have to wonder why Acumatica has not included this in the main form . With a check mark in Sales Preference area to allow users to use the feature out of the box.
One to many relationship.