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