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
Click on this link for the poll.
Please note that on Saturday, July 9, 2022, at 6:00 AM Pacific time, our Case Management System will undergo a scheduled maintenance for approximately 60 minutes. During this time, case creation via SuiteAnswers will be unavailable and inbound calls will be routed to Customer Service.

Saved Search > Non-Taxable Customers' Last Transaction

Here's a sample Customer Saved Search that will display the last transaction of Customers which Tax Item is -Not Taxable-.

  1. Navigate to Lists > Search > Saved Searches > New
  2. Select Customer
  3. Rename the Saved Search
  4. Under the Criteria tab, add the following filters:
    1. Formula (Text) | Formula = {taxitem} | Description = is -Not Taxable-
    2. Transaction Fields… > Type = is any of Cash Sale, Credit Memo, Invoice, Sales Order
    3. Transaction Fields… > Main Line = is true
  5. Under the Results tab, add the following fields:
    1. Name | Summary Type = Group
    2. Tax Item | Summary Type = Group
    3. Transaction Fields… > Document Number | Summary Type = Maximum | When Ordered by Field = Transaction Fields… > Date | Summary Label =

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

Vote on the next webinar's topic. Check this poll now.

Dominica Sevilla - Oracle | OTC / P2P / ASB Guru

Howdy, Stranger!

Log In

To view full details, sign in.


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


This Week's Leaders

This Month's Leaders

All Time Leaders