Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
NSC | How to show Invoice lines that are taxable or with tax amounts in a Saved Search?
Scenario:
In some cases, users may need to generate an Transaction Saved Search to show the taxable lines in Invoices.
Solution:
1.) Navigate to Lists > Search > Saved Searches > New
2.) Select Transaction
3.) Under the Criteria tab of the Saved Search:
Type = Invoice
Main Line = False
Tax Line = False
Formula (Numeric)
Formula: CASE WHEN {taxamount} = 0 OR {taxamount} IS NULL THEN 0 ELSE 1 END
Formula (Numeric) = Not Equal to O
Note: You can add or remove the other filters, but make sure the Formula (Numeric) is there
3.) In the Results tab, you can add additional columns:
Amount (Tax)
Item
4.) Save and run your Saved Search
Tagged:
0