RE: 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.
UCN Beginner Asked on December 3, 2021 in Reports.
Add Comment
3 Answers

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

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.