Skip to main content
Solved

Trying to sort by grouping Customer Locations


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!

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

2 replies

miguel80
Semi-Pro II
Forum|alt.badge.img+1
  • Semi-Pro II
  • 71 replies
  • Answer
  • January 30, 2023

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

 See if this works!


  • Author
  • Freshman I
  • 2 replies
  • February 2, 2023
miguel80 wrote:

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.


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