Best Of
Re: Custom role - restrict check box
Hello,
In order to restrict a permission of one specific check box. you can use workflow to do so.
Thanks and Regards!!
Re: Could not delete workflow field due to dependencies
Hi Gia My "Mei" Luc,
Since we cannot reproduce this in our testing environment, we will not be able to find the root cause of this error. I highly suggest that you file a Support Case with our Support team since they can access your replica account for testing which in this case is needed.
Thank you for your understanding.
-Lyka
Re: [Ask a Guru]: menu bar not showing on safari browser
Thank you for your insights,
@
Tafara! 👏
Hello User_ILOPF! were you able to check the comment above? :)
SQL Essentials: NULLIF Function Explained
Overview
In NetSuite Saved Searches, data inconsistencies can disrupt accurate analysis. Enter the NULLIF function, a powerful SQL tool designed to address such issues by comparing two expressions and returning null if they are equal. This article explores how the NULLIF function can be utilized to handle specific data discrepancies and ensure more reliable analysis results.
Understanding the Syntax
NULLIF(expression1, expression2)
The NULLIF function compares 'expression1' with 'expression2'. If they are equal, NULLIF returns null; otherwise, it returns the value of 'expression1'.
This function is most commonly used when users encounter the "Possible Divide By Zero" error when creating a formula for a Saved Search. This error occurs when a formula on the Saved Search has a denominator of zero, resulting in an invalid result.
To resolve this error, enclose the formula denominator with the NULLIF function:
Formula: NULLIF({denominator},0)
In this formula, NULLIF ensures that if the result of the denominator is null, it is treated as zero in the calculation.
-----
If you find this information useful, let us know by reacting or commenting on this post!
Re: REST API 401 Unauthorized Error on record collection filtering but simple searches work
Once the support identify the root cause, I would appreciate if you can share your results here in our community. Thank you!
Re: REST API 401 Unauthorized Error on record collection filtering but simple searches work
Thanks Richard. I will contact NetSuite Customer Support. I appreciate the help.
Re: Company Bank Details
Hi @User_ECQOX,
Kindly confirm if you have the Japan Localization bundle installed in your Account.
Thank you! 😊
Re: What are best ways to check performance of customer NetSuite account
Hey @Naresh_-Oracle,
The APM is the best tool for analyzing the performance of NetSuite workflows and scripts and their impact on various records.
Re: What are best ways to check performance of customer NetSuite account
Double click on the 'NetSuite Logo' on the users dashboard. This will show the page load times similar to this:
There you go!
~angela
Re: SCA|How do we arrange the fields in a specific order on the PDP page?
Hi Guys,
I am able to resolve the issue. Thank you so much for your help and support.
Best regards,
Shubham Singh.
