Forum Stats

  • 3,686,738 Users
  • 61,106 Discussions
  • 206,428 Comments

Discussions

Check out Oracle NetSuite upcoming events and conferences here
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now!
RUN, DON’T WALK...Registration for #SuiteWorld 2022 is officially OPEN! This special early bird price won’t last long, so make sure you don’t miss out: https://lnkd.in/gGRN78A3
Virtual Event: Getting the Most Out of NetSuite Standard Costing Capabilities

You asked for it, you got it! Join the webinar Getting the Most out of NetSuite Standard Costing Capabilities on June 28, 2022 at 11AM PT. Register here!

Saved Search > Transactions of Non-Taxable Customers

edited May 26, 2022 7:53AM in Search / Reporting

Here's a sample Transaction Saved Search that will pull up sales transactions of your Non-Taxable Customers. This Saved Search will also identify transactions that have 0 tax and the total amount is not 0.

  1. Navigate to Lists > Search > Saved Searches > New
  2. Select Transaction
  3. Rename the Saved Search
  4. Under the Criteria tab, add the following filters:
    1. Type = is any of Cash Sale, Invoice
    2. Formula (Numeric) = is empty | Formula = {taxtotal}
    3. Main Line = is true
    4. Status = is not Invoice: Voided
    5. Formula (Text) = is 1 | Formula = case when {customermain.taxitem} = ‘-Not Taxable-‘ then 1 end
    6. Amount = is not 0.00
  5. Under the Results tab, add the following fields:
    1. Name
    2. Document Number

Let us know what contents you like to see in the Community! You can vote here.


Dominica Sevilla - Oracle | OTC / P2P / ASB Guru

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!

Leaderboard

This Week's Leaders

This Month's Leaders

All Time Leaders