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!
How to Show Item Receipts on Vendor Bills through Saved Search/Custom Sublist?
Hi,
I would like to get corresponding Item Receipts on Vendor Bills. These vendor bills are generated from Purchase Order and this is done via UI.
I've a saved search and it is as follows -
Criteria -
- Type = is Bill
- Main Line = False
- Applied to Transaction:Type = is Item Receipt
Results -
- Date
- Formula (Text) =
case when {appliedtotransaction.type}='Item Receipt' then {appliedtotransaction.number} else 'NULL' end(Custom Label = IR Number)
Available Filters -
- Internal ID
The Saved Search is available as sublist view
I've added this sublist to my Vendor Bill and I do not see the corresponding IR number
What should I do/modify my saved search to have the item receipts?
Tagged:
0