Discussions
Join the NetSuite community to innovate, connect, and discover what’s next.
SuiteWorld brings thousands of innovators, builders, and leaders together to learn, connect, and shape what’s next. This October, explore how to build a stronger foundation for growth through inspiring keynotes, major product reveals, hands-on sessions, and unforgettable moments—all in one place for our biggest event of the year. Register now
NSC | How to create a Vendor Bill Saved Search created from Purchase Orders?
Scenario
User wants to create a Saved Search for their Vendor Bills with Purchase Order as its source.
Solution
1.) Navigate to Lists > Search > Saved Searches > New
2.) Select Transaction
3.) Under Criteria tab, set the following:
Type = Bill
Main Line = True
Created From fields… > Select Type = Purchase Order
4.) Under the Results tab, add the following:
Created From | Summary Type: Group | Custom Label: Purchase Order
Created From…fields > Amount | Summary Type: Maximum | Custom Label: Purchase Order Amount
Transaction Number | Summary Type: Group
Type | Summary Type: Group
Amount | Summary Type: Maximum
5.) Rename search
6.) Save and Run
User should be able to have a list of Vendor Bills with Purchase Orders.
Patrick Fresnosa | Advanced Accounting | SRP | Ask a Guru
