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.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
NSC | Saved Search > Purchase Order > Billed Before Received
To know your Purchase Orders that were billed first before received, you can create a Saved Search by following these steps:
1. Navigate to Lists > Search > Saved Searches > New
2. Select Transaction
3. Under the Criteria tab, add the following filters:
- Type = Purchase Order
- Formula Numeric = CASE WHEN ({billingtransaction.datecreated} < {fulfillingtransaction.datecreated}) THEN 1 END
4. Under the Results tab, add necessary fields
5. Click Save & Run
I hope this helps! ❤ Feel free to share your own tips and tricks under NetSuite Admin Corner to help other members as well. Thank you very much! 😊
Dominica Sevilla - Oracle | OTC / P2P / SCM Guru
Tagged:
0