Table type |
Standard = lists results by variation ID
Extended = lists results by item ID and in addition for each item the variations by variation ID
Matrix = similar to the extended result list, only variations that have attributes are displayed differently |
Search |
Triggers a search. The stock data found is listed in the results in the Stocks tab. |
Reset |
Completely resets the selected filters. |
Variation number |
Enter a variation number to search stock of this variation. The search may return more than one result. Let’s assume you enter 987 and because you have a lot of variations you also have a variation that has the ID 9871. In this case, both variations will be found. In addition, also variations of the same item that the variations belong to will be listed. |
Item ID |
Enter an item ID to list the stock of all variations of that item. |
Variation ID |
Enter a variation ID to search stock of this variation. |
Barcode |
Enter a barcode to search stock of this variation by barcode.
You can set up barcodes in the Setup » Item » Barcode menu and then you need to link the barcode with your variation. |
Item data |
Enter data in this field to browse through the item ID, variation ID, variation number, item name and variation name. The search will not browse through the preview text or the item text.
When searching with item data, it is sufficient to only enter the word stem into the field. Search terms can be shortened to almost any extent at the end of words. However, words cannot be shortened at the beginning. When searching for starter sets it would be enough to just enter starter or start. The same is true for all numbers such as IDs. |
Limitation |
Select an option from the drop-down list to only search for variations that have this stock limitation. |
Order |
Yes = Allows to create reorders within the stock search menu. The items need to be linked with suppliers to create reorders. The button Create reorder is displayed above the result list. The chapter Creating reorders explains all necessary steps in detail.
No = Disables the function to create reorders within the stock search menu. |
Sorting |
Choose whether to sort the stock entries by item ID (default) or by their item number.
Note: When you choose the standard table type the item number will not be displayed with the results. However, the sorting is still correct. |
Supplier |
Select a supplier to search stock of variations that you receive from this supplier. This makes it easier to create reorders for a supplier.
The supplier can also be selected from a drop-down list in the variation’s row. Despite the fact that you have filtered with a supplier, all suppliers of the variation will be listed here. In addition to the supplier, you will also see the purchase price for this variation from this suppler, the units contained, the discount and the minimum order quantity. |
Flag 1
Flag 2 |
Select a flag to only display stocks that have this flag. The two flags form a conjunction, i.e. if an option has been selected for both flags, only variations that have both of the flags will be listed. |
Bundle |
Choose between searching for variations only and including bundles into the search. |
Inactive |
All = All variations and stock are displayed. The option is set by default.
Yes = Only displays the stock of inactive variations.
No = Only displays the stock of active variations. |
Category 1
Category 2
Category 3 |
Select the category to only search for stock and variations that have this category. The categories are based on each other. You can only choose a third level category if you have selected a second and first level category before. This means you need to start with the first level category. However, you do not have to select a second or third level category. You will only see the stock of the lowest category that was selected. |
Warehouse |
Select a warehouse in order to only display stock from this warehouse. |
Net calculation |
Select a calculation variation to display the net stock. If you want to include listings, select the setting reserved orders + listings. |
Date of receipt |
Select a date in order to search stocks by the date that incoming items were booked. The entire stock of this variation that was registered or booked on that day will be listed. |
Net stock |
Select an operator and enter a quantity to search variations with net stock quantities above, below or equal to the entered quantity. You will search for all variations that have a net stock of more than 20 if you select (>) as operator and enter 20 as quantity. |