Skip to main content
Answer

Top Selling Item

  • January 17, 2022
  • 4 replies
  • 215 views
N
Jr Varsity III
Forum|alt.badge.img

Hello,

Is there a report to check to see the top selling items by month?

Best answer by vkumar

Hi @Nelson Yip 

There is no out of the box report which gives the output you are expecting. But altering following report can give you the details you are looking for. 

-You can remove the item class grouping and sort the report based on margin% or Net Sales value.

Hope this helps, 

Regards,

    4 replies

    Naveen Boga
    Captain II
    Forum|alt.badge.img+19
    • Naveen Boga
    • Captain II
    • January 17, 2022

    Hi @Nelson Yip  Not sure but hoping that the below report may help you. If NOT, we can come up with a new Generic Inquiry to fetch the details from Sales Orders.

     

     

    Naveen B - Acumatica MVP 🏆 | Independent Developer for Hire 🚀 ⏩ https://www.linkedin.com/in/boga-naveen-kumar-54079a66/
    Chris Hackett
    V
    Acumatica Employee
    Forum|alt.badge.img+12
    • vkumar
    • Acumatica Support Team
    • Answer
    • January 18, 2022

    Hi @Nelson Yip 

    There is no out of the box report which gives the output you are expecting. But altering following report can give you the details you are looking for. 

    -You can remove the item class grouping and sort the report based on margin% or Net Sales value.

    Hope this helps, 

    Regards,

    VijayKumarU
    Chris Hackett
    N
    Jr Varsity III
    Forum|alt.badge.img
    • Nelson Yip
    • Author
    • Jr Varsity III
    • January 18, 2022

    Thanks, I used that report and exported out to Excel to sort it.

     

    Would be easier to just do everything inside Acumatica.

    Chris Hackett
    V
    Acumatica Employee
    Forum|alt.badge.img+12
    • vkumar
    • Acumatica Support Team
    • January 19, 2022

    Hi @Nelson Yip 

    Noted your comment. Please post a request on our ‘Ideas’ page as well. Our Product management team can review the requirement and evaluate if it could be added on future product roadmap.

    https://community.acumatica.com/ideas

    Regards,

    VijayKumarU
    Chris Hackett
    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