Discussions
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. Join us
Subtracting Specific Discount Items in NetSuite Saved Search Formula
Hello! I have a transaction saved search built that gives me every Sales Order with our company margin and revenue information.
I need to have a column for Revenue that shows Revenue for each Sales Order. This should be equal to the {amount} minus a specific Discount when it is present. The item's custom name is 'Discount Item' and internal id is 14001. The discount is variable and is set on the Sales Order Line item level.
I need to have a column for Margin that shows Margin for each Sales Order. I need for our margin to be equal to {amount}-{item.cost} and also minus a specific Discount when it is present. That item's custom name is 'Trade-in Discount' and internal id is 14059. The discount is variable and is set on the Sales Order Line item level.