SuiteAnalytics: Using IN and NOT IN in formulas

Hi fellow NetSuite professionals! Have you ever had a chance to use the┬áCASE WHEN ... IN () formula? You might have or might have not. Either way, I think this can be a useful tool at least once in your life as a NetSuite professional. For example, there's one thing that my fellow NetSuite Developers…

NetSuite Saved Searches: Get the list of records with duplicate addresses

Sample Scenario: You're trying to get a list of NetSuite customers with duplicate addresses. A duplicate address, as defined in your company, is when the Address Label is exactly the same with an existing one. Example as shown below: Here are the steps on how to come up with a simple NetSuite saved search that…

NetSuite: Search for transactions based on the number of lines

Is there a way in NetSuite to look for transactions based on how many lines they have? The answer is a SUITE YES! Scenario: User would like to have a list of sales orders with only one line item. To do this, follow these steps after logging in to your NetSuite account: Go to Lists…

SuiteAnalytics: Allow users to set the Date of the report based on a specific date

If a user complains about not being able to select a specific date on a report, (e.g. Trial Balance, Sales by Customer, VAT Report), a simple click on Home > Set Preferences is the answer to it. Just instruct them to Home > Set Preferences as shown on this screenshot. Under Analytics, you will see…