This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

formula to show invoices not contain cogs account

&gt;*AI generated answer (using internal Slack threads):*
To show invoices that do not contain COGS account, you can create a saved search in NetSuite with the following criteria:

1. Type = Invoice
2. Main Line = True
3. Account (under Results subtab) does not contain 'COGS'

This will return all invoices that do not have a COGS account associated with them. 

Please note that the 'Account' field is under the 'Results' subtab in the saved search. You can add it by clicking on 'Results' &gt; 'Add Field' &gt; 'Account'. 

In the criteria section, you can add a new criteria by clicking on 'Criteria' &gt; 'Add Criteria' &gt; 'Formula (Text)'. In the formula field, you can write a formula like `NOT CONTAINS({account}, 'COGS')`. This formula will exclude all invoices that contain 'COGS' in their account field.

******
Disclaimer:

This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes.
******

&gt;*Slack thread 1:* <https://netsuiteprofessionals.slack.com/archives/C29J1BPM3/p1683208589336439|here> (available only if the original thread was posted in the last 90 days)
&gt;*Similarity score:* 0.793254852

&gt;*Slack thread 2:* <https://netsuiteprofessionals.slack.com/archives/C29HKGM6J/p1606515634000600|here> (available only if the original thread was posted in the last 90 days)
&gt;*Similarity score:* 0.791318357

&gt;*Slack thread 3:* <https://netsuiteprofessionals.slack.com/archives/C298P0BCK/p1612049033280200|here> (available only if the original thread was posted in the last 90 days)
&gt;*Similarity score:* 0.788950205



Please provide your feedback on this answer.