Hi there,
I'm new to NS. I like to show single location inventory (our main Warehouse) in saved search.
When use "quantityonhand" it show total inventory of all WH.
When use "locationquantityonhand" it show each WH inventory in separately lines.
May I know how can I use formula to make the Saved Search show only single WH location instead use Formula (NVL({locationquantityonhand},'0')) then Sum up all lines (Grouping)?
Thanks in advance.
Regards,
kf