To get amount without tax in transaction saved search

1. Go to Reports > Saved Searches > All Saved Searches > New > Transactions

2. Under the Criteria tab > Standard subtab, add Filters:

• Select Type
• Main Line = is True

3. Under the Results tab > Columns subtab, add Fields:

• Formula (Currency) = nvl({totalamount},0)-nvl({discountamount},0)-nvl({taxtotal},0)-nvl({shippingamount},0)

4. Change the Search Title

5. Click Save & Run