Creating Saved Searches for Bin Numbers
You can return bin number data for transaction and item searches. The following fields are available as criteria and results:
-
For transaction searches: Transaction Bin Number, Transaction Bin Quantity
-
For item searches: Bin Number, Bin on Hand Count, Bin on Hand Available, Preferred Bin (whether the bin is the preferred bin for the location)
-
Other Bin Number record fields are available as join fields for both transaction and item searches.
Creating a Transaction Bin Numbers Search
The following search returns all transactions that use bins, and indicate the quantities moved between bins.
To create a transaction saved search with bin number data:
-
Start a transaction saved search.
-
On the Criteria subtab, select Transaction Bin Number in the Filter field.
-
In the popup window, select “is not empty” in the dropdown list and click Set.
-
On the Results subtab, select the following fields in the Field column, clicking Add after each one: Date, Type, Transaction Number, Amount, Transaction Bin Number, and Transaction Bin Quantity. (You can remove other selected fields as necessary.)
-
Click Preview or Save & Run to view your search results.
Creating an Item Bin Numbers Search
The following search returns all items that use bins and includes all bin information, including bin numbers, quantity on hand, quantity available, whether bin is preferred, and if multi-location inventory is in use, location.
To create an item saved search with bin number data:
-
Start a transaction saved search.
-
On the Criteria subtab, select Bin Number in the Filter field.
-
In the popup window, select “is not empty” in the dropdown list and click Set.
-
On the Results subtab, select the following fields in the Field column, clicking Add after each one: Name, Type, Base Price, Bin Number, Bin On Hand Count, Bin On Hand Available, and Preferred Bin. (You can remove other selected fields as necessary.)
-
In the Field column, scroll down through all fields and click Bin Number fields. In the popup, click Add Multiple, select Location and Memo, and click Add.
-
Click Preview or Save & Run to view your search results.