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 | Saved Search > Purchase Order > Quantity Unbilled
Here's a sample Saved Search with a formula to determine the Quantity Unbilled of a Purchase Order.
- Navigate to Lists > Search > Saved Searches > New
- Select Transaction
- Rename the Saved Search
- Under the Criteria tab, add the following filters:
- Type is Purchase Order
- Main Line is false
- Under the Results tab, add the following fields:
- Field: Document Number | Summary Type: Group
- Field: Applying Transaction : Amount | Summary Type: Sum | Function: Absolute Value
- Field: Formula (Numeric) | Summary Type: Sum | Formula: {quantity}-{quantitybilled}
- Note: Add other fields as necessary.
- Click Save & Run
I hope this helps! ❤ Feel free to share your own tips and tricks under
Dominica Sevilla - Oracle | OTC / P2P / SCM Guru
Tagged:
0