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 create a workbook to show the latest Vendor Bill date for a Purchase Order?
SCENARIO
User wants to create a Workbook for their Purchase Orders (POs) and they wants to identify the latest Vendor Bill date for each PO as it may contain multiple Vendor Bills.
For example a Purchase Order dated April 1, 2024 may have the following Vendor Bills associated to it:
Vendor Bill #1 | Date: April 26, 2024
Vendor Bill #2 | Date: May 1, 2024
User wants to show May 1, 2024 only in the workbook results.
SOLUTION
Create a Dataset
1.) Click Analytics
2.) Go to Datasets > New Dataset
3.) Select Transaction
4.) Add the following Criteria:
Transaction (Record List) > Type (Fields List) = Purchase Order
Related Transactions - Next (Record List) > Transaction (Record sublist)
0