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 | Resolve Error: "There is a divide by zero error in this search..."
Scenario
A user is attempting to display the item rate field in a sales invoice saved search in NetSuite but is encountering issues due to the absence of a direct 'Rate' field and encounters error when attempting to derive this using a formula instead. The user encounters the error, "There is a divide by zero error in this search. It may be an error with a formula you have used. Please retry without the formula(s)…"
Solution
To display the item rate in a saved search, use a formula to calculate the rate by dividing the amount by the quantity. However, to avoid errors caused by division by zero, use the following approach:
Shiela Marie Villaluz | Ask a Guru
Earn Community badges now! Refer a Member | Answer Accepter |