NetSuite has many standard reports that you can create. However, there are times when one report doesn’t give you everything you may need. That’s where saved searches can help you get the information.

One of my clients bills PO’s in advance of receipt and needed to manage the entire transaction. They needed a report which included the following:

  • POs currently billed
  • Status of the PO
  • Amount of the PO
  • Vendor bill
  • Vendor bill amount
  • Currency

Creating a Saved Search

There isn’t any one report in NetSuite that can pull in these related records, so I created a saved search. I started with creating the criteria for the saved search. By selecting the transaction type as PO, it brings in all the POs. By selecting mainline as false, I was able to get the line item detail for each PO and related records.

Picture 1-1

Next, go to Results tab to determine the columns to be included in the search results and sort order. You will need to include the billing transaction information you need – there are a number of options available. When adding billing transactions, be sure to use Absolute Value in the Function column so that the transactions don’t come into the report as a negative dollar amount.

Picture 2-2

I hope this is helpful. If you’re looking for a NetSuite implementation partner, please reach out to the team with any questions.

Additional NetSuite Resources

Avoid This Common NetSuite Mistake When Building a Transaction Saved Search

NetSuite Saved Search Magic with Dynamic Drill Through

How to Create an ‘After Field Edit’ Trigger on NetSuite Workflow Actions

Wait! Before You GoWould you like to talk to a business software expert to answer your questions?

When you schedule a free consultation with MIBAR, you will experience a one-on-one conversation with a business technology expert who is passionate about understanding your unique needs or issues. Schedule a free consultation today at the link below or give us a call at (212) 869-9300.

Learn More
NetSuite Offer: Save $15,000 With Our Limited-Time Discount

If you’ve been evaluating NetSuite, there is no better time to make the switch. With a NetSuite subscription through MIBAR by December 31, 2020, we will offer you 75 hours of professional consulting services for FREE.

Not only can a new ERP system like NetSuite help you reduce operating costs by automating manual processes, but this limited time offer can also help save you a substantial amount of money upfront.