Discussions
Join us for complimentary one-day events around the world and step into a future fueled by AI and limitless potential. Explore new breakthroughs, sharpen your skills, and connect with experts who are shaping what’s next. Experience bold keynotes, interactive learning, and connections that span the global NetSuite community. Discover what's next at SuiteConnect Tour 2026.
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!