Skip to main content
Question

Top 10 Sales By Quantity does not sort (descending) correctly

  • July 1, 2025
  • 4 replies
  • 63 views
M
Freshman I

Hi,

I am trying to create a GI for the Top 10 products sold by quantity based on a successful and similar one being Top 10 products sold by amount.

The sum of the quantity is not being sorted correctly. Refer attached screenshots of the scope and the result. I have also attached the GI xml file.

The total quantity column is not arranged in exact descending order, which needs to be corrected.

Any help would be appreciated.

Thanks

3 Attachments

4 replies

hkabiri
Acumatica Moderator
Forum|alt.badge.img+8
  • hkabiri
  • Acumatica Support Team
  • July 1, 2025

​@ManishPatel132008 I tested on my 2024R2 with Sales Demo data and I cannot reproduce it. The sorting is as expected:

 

SAM KABIRI | L2 Support Engineer | hkabiri@acumatica.com | www.acumatica.com
Chris Hackett
DipakNilkanth
Pro III
Forum|alt.badge.img+13

Hi ​@ManishPatel132008,

I also tried it, and it’s working fine for me as well.

The only thing I noticed is that the UOMs are different — I’m not sure if that’s related, but it might be affecting the sorting.

Hope, it helps!

Dipak Nilkanth || MVP @2025 || https://www.linkedin.com/in/dipak-nilkanth-293591102 || Acumatica Developer
Chris Hackett
M
Freshman I

Thanks for the prompt responses. Acumatica version in use is 2023 R2 Build 23.207.0025.

​@Nilkanth Dipak - The grouping is on the InventoryID and the corresponding quantity is the sum in question here. The UOM is only for display only and is not influencing the scope. On further investigation, I realized that the negative amount is not being calculated correctly using IIf( expr, truePart, falsePart ). The attached screenshot may explain better. For all transactions with D as the quantity should be negated, which is not happening.

2 Attachments
Chris Hackett
Chris Hackett
Community Manager
Forum|alt.badge.img
  • Chris Hackett
  • Acumatica Community Manager
  • September 24, 2025

Hi ​@ManishPatel132008 were you able to find a solution? Thank you!

Chris ~ Let us know how we're doing: https://forms.office.com/r/xmJUdZ1QE5 - A member helped you, please *Like* their post. A member provided an answer to your question, please mark it as *Best Answer*.
Terms & ConditionsCookie settingsAccessibility statement
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