Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
Don’t miss your chance to meet our SuiteGurus—NetSuite Support professionals and subject matter experts with extensive experience in select product areas, including OneWorld, Advanced & Basic Accounting, Supply Chain Management, Receivables & Payables, CRM, Account Administration, and the SuiteCloud Platform. Full Conference attendees can prebook exclusive 30-minute one-on-one sessions for your product questions.
Spots are limited! Register through your Agenda Builder and find SuiteGuru under Agenda Enhancements.
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.