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!
Item search to return transaction column field?
I am trying to create an item search that, among other things, returns a transaction column field (date) value when the quantity available of that item is less than X units.
The custom transaction column field to be returned is a date field we put on POs where we enter the Confirmed Receipt Date for that line item after we get confirmation from our vendor.
I want the item search to return only the next Confirmed Receipt Date--taken from its POs--of the item when the quantity available of the item is less than 100.
Anyone have an idea how it could be done?
0