By using this website, you agree to our Terms of Use (click here)
I have added the display of the Tracking Number in the footer of the Shipment Notice. The problem is that only 1 tracking number is displaying and we have shipments where we have multiple tracking numbers.
* In report designer, I added SOPackageDetail as a table, and in Relationships
* I added the link from the SOShipLine to the SOPackageDetail ... linking on ShipmentNbr and LineNbr.
* In the footer of this report, I am displaying the TrackNumber from SOPackageDetail
I have a shipment with 2 tracking numbers, but only 1 displays on the modified Shipment Notice. What changes do I need to make to allow for the display of multiple tracking numbers?
What do I need to change to allow f
Hi Ron,
You'll need to create a separate report that shows the multiple tracking numbers. Then you can drop that report onto your Shipment Notice as a Subreport.
Thanks for the quick response. In the separate report, where I will be listing the tracking numbers associated to a shipment, I suspect I will need the following tables: SOShipment and SOPackageDetail ... with my relationships entry ... joining these 2 tables on ShipmentNbr. Is that correct or will I need to use the SOSHipLine table, linked to SOPackageDetail? I'm uncertain on the primary table and the fields to join on.
That's correct. Start with SOPackageDetail and join to SOShipment on SOPackageDetail.ShipmentNbr=SOShipment.ShipmentNbr.
This had some great information, but was still having an issue with the Sub Report actually pulling the data on the Main report. The Sub Report works correctly. Attached are my two reports.
I was able to fix it. Below are the reports that work correctly. The Tracking Numbers are shown at the bottom of the Shipment Confirmation.
Shipment Confirmation:
Sub Report:
Thanks so much Jeff for sharing your reports.
Hi Jeff and Tim,
I have copied downloaded the report and subreport and put it into my client's Acumatica system. However, the results of the tracking number is not appearing. Is there something different that may have changed in 2020 R2 that would not allow for that tracking number to display?
Appreciate the help in advance.