Scenario
User creates a Saved Item Search to pull out the location quantity available of its items, whether or not it is 0. However, no results are being pulled out for their new locations for which transactions are not yet created.
Under the Location Sublist of the item record, it is a standard behavior that the Quantity Available and Quantity Available (Base Unit) Columns of the new locations for which transactions are not yet created are set to Null.
Solution
To pull out results for these locations, user may perform the following:
- Navigate to Lists > Accounting > Items
- Click Edit of affected Item Record
- Click Save
After doing the above steps, the Null values set on Quantity Available and Quantity Available (Base Unit) Columns will be changed to 0 which will then allow users to pull out results for these locations on their saved Item Search.