Solved

Trying to sort by grouping Customer Locations

  • 29 January 2023
  • 2 replies
  • 47 views
G
Rank

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.

icon

Best answer by miguel80 30 January 2023, 19:16

View original
1 Attachment

2 replies

miguel80
Rank
Userlevel 5
Badge +1

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

 See if this works!

Miguel Q
G
Rank

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


Terms & ConditionsCookie settings
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved