On the print confirmation the lines and qty duplicate.
lines nbrs 1 and 3.
Answer
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
Acumatica Functional Consultant & Customer Experience Supervisor
+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.
+10Did you create the sub report? You have to create the sub report then add that sub report to this form to display the tracking numbers and not cause duplication. You should have you partner assist as it’s not an easy task.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.