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!
Filter transaction saved search
Hi,
I have transaction saved search with the criteria:
- Item : Type = is Inventory Item
- Type =is any of Inventory Adjustment, Purchase Order, Credit Memo
- Item Number : On Hand > 0
With the results :
- Item Number : Number - Group
- Item Number : Location - Group
- Inventory Detail : Bin Number - Group
- Internal ID - Max
- Item Number : On Hand
Since the serial number was in inventory in bin="M171" > Invoiced > returned to inventory to bin="no_bin" there are two rows for the serial# 142504 but the row with the max internal id is the row that reflects where the serial number is now.
Any Idea how can I filter it ?
0