Discussions
Join the NetSuite community to innovate, connect, and discover what’s next.
SuiteWorld brings thousands of innovators, builders, and leaders together to learn, connect, and shape what’s next. This October, explore how to build a stronger foundation for growth through inspiring keynotes, major product reveals, hands-on sessions, and unforgettable moments—all in one place for our biggest event of the year. Register now
TIP: Avg Days to Pay
In case anybody else needs it, here are a couple of saved searches to get the average days for customers to pay...
Summary (averages by customer)
Criteria tab:
Type: is Invoice
Account: is Accounts Receivable
Results tab:
-- Customer fields.... then select Name, Summary = Group
-- Days Open, Summary = Average, Function = Round, Label = Avg Days Open
Notes:
Selecting "Customer fields..." and then selecting Name is different than just selecting Name, with the result that it doesn't show the customer ID.
If you only want to show the average for some customers based on criteria of some kind, add it to the criteria tab. For example, to show only customers on credit hold, select "Customer fields...." then select On Credit Hold = Yes.