Skip to main content
Answer

Trying to sort by grouping Customer Locations

  • January 29, 2023
  • 2 replies
  • 77 views

I’m currently trying to set up a generic inquiry which lists me all shipments for which a confirmation or pick list haven’t been printed yet.

The hard part is that I want to keep all customer locations grouped together, while sorting by the weight of the shipment.

That means that the two shipments at the end of the inquiry are supposed to be right after the first shipment with the location description “100”.

In general all shipments of a location are supposed to stay “together”, but the location with the highest weight should be the top of the list. 

Is there any way to do this in a list like that? I attached my xml as a reference.

Best answer by miguel80

Hi! Just add the LocationCD field to the order fields before the Weight:

 See if this works!

2 replies

miguel80
Semi-Pro III
Forum|alt.badge.img+3
  • Semi-Pro III
  • Answer
  • January 30, 2023

Hi! Just add the LocationCD field to the order fields before the Weight:

 See if this works!


  • Author
  • Freshman I
  • February 2, 2023

Hi! Just add the LocationCD field to the order fields before the Weight:

 See if this works!

 

Thank you for your reply Miguel!

This worked so that the Locations are grouped together, but now the location with the highest weight isn’t displayed at the top anymore.