Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
NetSuite Admin Tip | Calculate Average Unbilled Sales Order Amount by Sales Rep Using SuiteQL
Understanding the relationship between Customers and their assigned Sales Representatives is crucial when analyzing unbilled revenue. By accurately linking each Sales Order to the Customer record, you ensure that your reporting reflects true sales ownership and provides meaningful insights for decision-making.
With SuiteQL, you can easily achieve this through proper JOIN logic—allowing you to calculate each Sales Rep’s average unbilled Sales Order amount based on real customer-transaction associations, rather than relying on incomplete or isolated fields.
SuiteQL Sample:
SELECT c.salesrep, AVG(t.amountunbilled) AS avg_order_value FROM transaction t JOIN customer c ON t.entity = c.id
Richard James Uri - SuiteCloud | WMS Tech | SuiteCommerce Advanced
----
- NetSuite Admin Corner | New to NetSuite
- Explore the NSC Webinars Category
- Join our poll and share your ideas! We want to know what you think. Don't forget to comment and make your voice heard!
- Expand your NetSuite knowledge by joining this month's Ask A Guru Live about Advanced Accounting. RSVP on this event now!
Tagged:
0