Many companies that sell products want to store images of these products on their NetSuite item record. When these images are used to feed other market places, such as eBay, Amazon, or others, it can be critical to ensure that no items have empty image fields.
If you’ve used NetSuite saved searches in the past you may be saying “sounds like a simple task using the criteria tab.” Well, hold on.
I just attempted to add a criteria line to test if a field called “Image 1” is empty or NULL and ran into the following issue.
When clicking the “Set Description” icon next to the field I was presented with the following screens.
As you can see, there is no option to select based on a value of “- None -” or “is empty” like you can with some fields. Instead, all you can do is select an image that is already in the File Cabinet.
Here are the options given when adding a regular text field as a Criteria line.
To get around this limitation with Image type fields, I used a Formula (Numeric) field on the Criteria tab as opposed to the actual image field name.
The formula used is a very simple Case statement as shown below.
If the “Image 1” field is empty then the Case statement resolves to 1, resulting in the criteria line resolving to True.
My search will now show me all items with an “Image 1” field that is empty/NULL, as shown below.
If you have any NetSuite customization or consulting needs, including the creation of saved searches as shown above, the NetSuite professionals at RSM can help. We are a NetSuite Solution Provider and a NetSuite Systems Integrator partner, and have more than 30 years experience implementing ERP solutions. We’ll provide you with industry insight, project management and the technical resources you need to make your project a success. Contact RSM at firstname.lastname@example.org or by phone at 855.437.7202 .
By: Gary Leitner – Colorado NetSuite Solution Provider