On the print confirmation the lines and qty duplicate.
lines nbrs 1 and 3.
Solved
Shipment Confirmation Duplication of Lines
Best answer by bwhite49
You could add a condition in that join where SOPackageDetailex.LineNbr = 1. This would exist right below SOShipment.ShipmentNbr = SOPackageDetailex.ShipmentNbr
This should show the first tracking number in the list but it’s messy because I think it’s possible that line nbr 1 could not exist in some cases.
You best bet is to create a sub report to display all tracking numbers. Basically, you will embed the tracking number list inside the form, but it will not affect the behavior of the form (no more duplicates).
Creating a sub report can be tricky though. I’m not sure if I can point you to the best resource to create one.
+10Hi Sunny,
This is caused by an issue with a join in the report form. If you share the data relations in the report form, we likely can help you identify what is causing the duplication.
If you are not comfortable with report designer, you may need to get your Acumatica partner to assist.
+2Hi
I’m wondering if the report has been customized or if there are any customizations in place because when i printed the out-of-box Shipment Confirmation, i didn’t have duplicated lines.
-Dana
As bwhite49 stated, it is likely a join issue. We put our customer part number on a handful of reports and if a user has two customer part numbers populated for a single internal stock item, it will duplicate the lines. Maybe check something like that?
+15
+10
Probably SOPackageDetailEx is your issue. That will split by the number of packages on the shipment.
+10You could add a condition in that join where SOPackageDetailex.LineNbr = 1. This would exist right below SOShipment.ShipmentNbr = SOPackageDetailex.ShipmentNbr
This should show the first tracking number in the list but it’s messy because I think it’s possible that line nbr 1 could not exist in some cases.
You best bet is to create a sub report to display all tracking numbers. Basically, you will embed the tracking number list inside the form, but it will not affect the behavior of the form (no more duplicates).
Creating a sub report can be tricky though. I’m not sure if I can point you to the best resource to create one.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.