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.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
NSC | How to show the Amount Spent for each Vendor?
In cases where Users want to know the Total Amount they are spending for each Vendor, they can create a Transaction Saved Search for Vendor Bills.
Here are the steps to take to create the Saved Search:
1. Navigate to Reports > Saved Search> All Saved Searches > New
2. Select Transaction
3. Enter the Search Title
4. Under the Criteria Tab, add the following filters:
- Type = Bill
- Mainline = True
5. Under the Results Tab, add the following fields:
Field | Summary Type
- Name | Group
- Document Number | Group
- Amount | Sum
- Account | Group
6. Under the Available Filters, add the following:
- Name | Show in Filter Region = T | Show as Multi-Select = T
Tagged:
0
