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.
NSC | How to Use Formula Fields for Calculations
Imagine you need to calculate the total commission for each sales order based on a custom rate. Rather than exporting data or using manual calculations, you can create a formula field directly in NetSuite. This allows you to perform real-time calculations using existing field values—like multiplying the order total by the commission rate—helping you automate logic and streamline reporting right within the system.
Navigate to Customization > Lists, Records, & Fields > [Select Field Type] > New. Choose the appropriate field type: Entity Field, Transaction Body Field, Item Field, etc.
Under Validation & Defaulting check the Formula checkbox.
You can now enter basic arithmetic operations or formulas based on your needs ex. 5*5 or {fieldid}*{fieldid2}
@Red Velasco-Oracle | Suite Builder Guru |🦖T-Rex