Case formula for items based on if a box is checked

AI generated answer (using internal Slack threads):

Based on the conversations, it seems like you are trying to create a formula field on an Item record that displays 'true' based on two checkbox conditions. You are using a CASE statement to check the conditions of two custom fields,

custitem27

and

custitem_field_remove_preorder

. The formula you are using is:

CASE WHEN {custitem27} = 'T' AND {custitem_field_remove_preorder} = 'F' 
THEN 'true' 
ELSE null
END

However, you are encountering issues with this formula. It seems that the formula is not working as expected when

custitem27

is checked (i.e., 'T') and

custitem_field_remove_preorder

is unchecked (i.e., 'F' or null). One of the suggestions from the conversation is to use the

NVL()

function to handle null values. The

NVL()

function in NetSuite returns the first non-null expression among its arguments. It can be used in this context to handle cases where the checkbox fields might be null. Another suggestion is to ensure that the 'Store Value' option is checked for your custom fields. If 'Store Value' is not checked, the field's value is not stored and cannot be searched or reported on. Lastly, it was suggested to try using different checkboxes to see if the issue persists. If the formula works with different checkboxes, the issue might be with the specific checkboxes you are using. Please note that these are suggestions based on the conversations and might not solve your issue directly. You might need to adjust the formula or the configuration of your custom fields based on your specific requirements and the behavior of your NetSuite instance. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******