Skip to main content
Solved

Top Selling Items In a Generic Inquiry

  • Oct 28, 2024 6:23 PM UTC
  • 4 replies
  • 252 views
  • Translate All
Manikanta Dhulipudi
Captain II
Forum|alt.badge.img+16

Top Selling Items In a Generic Inquiry? Looking for your suggestions

Best answer by Manikanta Dhulipudi

@PatrickSchlenker90 Sorry to update here, I am able to figure out with the sales profitability analysis inquiries and adjusted the GI as per the business needs.

View original
Acumatica Functional Consultant & Customer Experience Supervisor

4 replies

josborn02
Varsity III
Forum|alt.badge.img+3
  • josborn02
  • Varsity III
  • Oct 28, 2024 6:33 PM UTC

You could start with the SOLine table, group by InventoryID and sorty by OrderQty.  Additional filters could be used as necessary - such as order date and order status.

 

 

Translate
If this answer is helpful, please consider liking it!
    PatrickSchlenker90
    Varsity III
    Forum|alt.badge.img+1

    @Manikanta Dhulipudi : You can use the “Sales Profitability for Last 12 Months” GI, in best Case in a Dashboard widget as Acumatica provide it already for a quarter (Sales Manager Dashboard). There you have all values you need to build an overview your are looking for. Also you can copy the GI and add some result column e.g. qty of the Transactions

     

     

    Translate
    Cheers, Patrick
      Manikanta Dhulipudi
      Captain II
      Forum|alt.badge.img+16

      @PatrickSchlenker90 Sorry to update here, I am able to figure out with the sales profitability analysis inquiries and adjusted the GI as per the business needs.

      Translate
      Acumatica Functional Consultant & Customer Experience Supervisor
        Freshman I
        • richard77
        • Freshman I
        • Mar 18, 2025 3:33 PM UTC

        ​@Manikanta Dhulipudi What did you update the Sales Profitability Analysis with to get quantity?

        Translate
        Terms & ConditionsAccessibility 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