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 | Understanding Estimated Gross Profit Calculation on Sales Order Line Items
Scenario:
The user noticed that the Estimated Gross Profit field on Sales Order line items was using an outdated item cost even after the purchase price increased significantly. Although new inventory had already been received at the higher cost, the estimated gross profit calculation continued using a lower cost value.
Solution:
The Estimated Gross Profit field on Sales Orders is calculated using:
Estimated Gross Profit = Amount - Estimated Extended Cost
Where:
- Amount = Rate × Quantity
- Estimated Extended Cost = Quantity × Estimated Item Cost
For inventory items, the estimated cost is typically based on the item’s current Average Cost rather than the most recent purchase price.
Niks Blando-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'sAsk A Guru Live about Advanced Accounting.RSVPon this event now!