Skip to main content
Solved

How to get the package count column to display the data on Shipments grid?


hayleehicks
Varsity I
Forum|alt.badge.img

Anyone run into the package count column on the Shipments grid not displaying the package count from the field in the Shipment header? Client reported the issue, and it appears to also be an issue in my local demo system. Field is SOShipment PackageCount on GI grid and is located in the header of the Shipment screen. See screenshot from demo system. 207 shown on the shipment. None show in the packages column in the shipments grid. Thanks!

 

Best answer by hayleehicks

Hi @etrojan28! Yes. You’ll want to add PX.Objects.SO.SOPackageDetailEx to the Tables tab. Then create a left join from SOShipment to SOPackageDetailEx by shipment nbr. Add a grouping by shipment nbr. On the Results tab, add SOPackageDetailEx and select the <Count> Data field. There was a little weirdness when there are multiple packages with the same box ID, and it seemed like it puts a minimum of qty 1 in the field on the inquiry, so some additional testing may be needed to fine tune it.

View original
Did this topic help you find an answer to your question?

4 replies

Forum|alt.badge.img
  • Varsity I
  • 47 replies
  • May 4, 2022

@hayleehicks18 Hey Haylee, did you every figure this one out? I’m having a similar issue. Thanks!


hayleehicks
Varsity I
Forum|alt.badge.img
  • Author
  • Varsity I
  • 109 replies
  • Answer
  • May 4, 2022

Hi @etrojan28! Yes. You’ll want to add PX.Objects.SO.SOPackageDetailEx to the Tables tab. Then create a left join from SOShipment to SOPackageDetailEx by shipment nbr. Add a grouping by shipment nbr. On the Results tab, add SOPackageDetailEx and select the <Count> Data field. There was a little weirdness when there are multiple packages with the same box ID, and it seemed like it puts a minimum of qty 1 in the field on the inquiry, so some additional testing may be needed to fine tune it.


Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • 2679 replies
  • May 4, 2022

Thank you for sharing your solution @hayleehicks18 !


Forum|alt.badge.img
  • Varsity I
  • 47 replies
  • May 4, 2022

@hayleehicks18 thanks for the detailed reply. I’m trying to get the package count to show up on a report using the report designer. The BoxID in this case would be the same, it’s for palletized orders shipping LTL. I’m going to test this out to see if that will work here.

 

Thanks for the info.

 

Regards,

 

Eric


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings