East Reports Question

I need to generate a list of the top 50 items purchased by our largest five customers, by quantity and revenue. I can’t seem to get it. Any assistance would be appreciated.
Beginner Asked on December 3, 2021 in Reports.
Add Comment
3 Answer(s)

Are you open to SuiteQL using suitescript or just saved searches?

Largest 5 by revenue and quantity may be two separate queries. You could then throw the N/Query results to a advanced pdf or html.

Top by revenue for revenue may be a SQL group with sum of amount of invoices then  sub query on items for them.

 

Rookie Answered on December 5, 2021.
Add Comment

I was just hoping to do a saved search or use a standard report.

Beginner Answered on December 6, 2021.
Add Comment

I am not sure how to accomplish with saved search or canned reports.

Always you could dump a saved search to excel for a one time report and use pivot tables.

I would look into analytics and the pivot table function. I would start at a sales order data set with customer and line items in the data set.

Then make a picot table with customer as the rows. You can have one for revenue and one for item quantity for easier sorting.

 

 

 

Rookie Answered on December 6, 2021.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.
  • This site made possible by our sponsors:   Tipalti   Celigo   Limebox   Become a Sponsor