Skip to main content
Solved

Top Selling Items In a Generic Inquiry


Manikanta Dhulipudi
Captain II
Forum|alt.badge.img+12

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
Did this topic help you find an answer to your question?

3 replies

josborn02
Jr Varsity I
Forum|alt.badge.img
  • Jr Varsity I
  • 38 replies
  • October 28, 2024

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.

 

 


PatrickSchlenker90
Jr Varsity I
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

 

 


Manikanta Dhulipudi
Captain II
Forum|alt.badge.img+12

@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.


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