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
NSC | Saved Search Cost Column Incorrectly Matching Total Cost Due to Summary Type Setting
Scenario:
In your Saved Search, the Cost column is showing the same value as the Total Cost column. This raises concern because these fields are meant to represent different metrics:
- Cost should reflect the average cost per item.
- Total Cost should represent the average cost multiplied by quantity.
Solution:
After reviewing the Saved Search configuration, we determined that the issue was caused by the summary type applied to the Cost field.
The Item: Average Cost field was set to use the Sum summary type. This caused the saved search to aggregate costs in a way that made the Cost column reflect a total value, not the intended per-unit average.
Trixie Amora-Oracle|Ask A Guru?️
Learn how to Refer A Member|Earn the Answer Accepter Badge|Be the Content Creator of the Quarter|Vote for the content you want to see!
Expand your NetSuite knowledge by joining this month's Ask A Guru Live aboutSuiteBuilder. RSVP on this event now!