# Stocks

The Stocks window can be used for a number of different operations - entering stocks, purchases, credits, transfers etc., changing cost and selling prices, changing product descriptions and sizes. However, those operations should normally be done in the forms tailored specifically for them and the Products window is generally used as a viewer/checker to see that all is OK - stock wise. The majority of the columns on this form are described in Setup/Products. The column of ticks, headed ‘L’, indicates whether a product is Live. You should set the Live box so that products are output to the handheld computer or count sheet. When using a count sheet, it will ensure that the order of products on the count sheet matches precisely the order of the products on this screen. Entry of deliveries and closing stocks will then be quick and reliable. By default, the Stocks window opens displaying only the live products. To show all products, click on the Press to Display All button. Irrespective of the tick status, a product's stock levels will always be calculated and included in the stock result. To change the live status of a product, click on the box with the mouse and this will toggle the tick. If you want to change a lot of products at the same time, click the box for the first product, press the down arrow key and then you can use 'Y' to set the tick and 'N' to unset the tick. You can set all products live from the Options list or by pressing Control-F11 and you can unset them by pressing Control-F12. The Down after Enter button makes for easy use of a numeric keypad. Whilst you can use the down-arrow key to move down to the next product, it is often easier to press Enter. Click on the button to change mode and click on it again to change back to move across after pressing the Enter key.
The Select Column option list allows you to enable/disable the various columns on the screen. This is useful to avoid changing data inadvertently. So, for example, if you are entering deliveries on the deliveries screen, there is no need for that column to be enabled here.
All stock values are shown in decimal, e.g. Bells (1.5L) has an opening stock of 3.7 bottles. For those products which are measured in dozens, the number shown is a decimal of a dozen, e.g. Becks could have an opening stock of 2 dozen and 4 bottles and this would be shown as "2.33". When you enter new stock values, move to the relevant box and type in the number. All values are shown to two decimal places but you need only type as many as are necessary, e.g. type 2 and 2.00 will be shown. If you are entering data for a dozens-type product, you do not need to worry about the exact decimal conversion. A new window will be displayed which allows you to type in the number of dozens (items) followed by the number of bottles (units) and the decimal number of dozens will be calculated automatically. You should type 6, then Enter, then 5, then Enter to achieve the example shown on the right. Alternatively, you can simply type 6.5 to achieve the same result. If the quantity is less than a dozen, e.g. 4 bottles, you can type either "0.4" or simply ".4" If your outlet is multi-bar, at the top of the screen there will be a list of bars to choose from. The columns will change to show the relevant figures for the selected bar. Also, if the cellar is selected, there will be a breakages column.

The New Product button allows you to create a new product.

The Import Product button allows you to copy a product from another outlet.

Additional Closing Stocks allows you to enter stock for a product which will be added to the stock that has already been entered.

There are a number of functions available on the Select Option List and most of them can also be started using the keyboard, e.g. Control-F8, press and hold the control key and then press the function key F8. Zero Cost Prices This will set the cost prices for all products to zero. It can typically be used after creating a new outlet and the cost prices are still set to those used by the old outlet. You will be prompted to confirm before continuing. Zero Selling Prices This will set the selling prices for all products to zero. It can typically be used after creating a new outlet and the cost prices are still set to those used by the old outlet. You will be prompted to confirm before continuing.

Cellar Report This report lists all products in the Cellar which have an expected closing stock of zero, i.e. it is likely that more stock should be ordered. |

Suppliers by Product Report Click on the product you wish to examine and then select the option. A notepad window will be displayed as shown on the right. It shows a list of the suppliers which provide the product and at what cost price. |

Quick Result You will be warned if there are any products with zero cost or selling prices. A notepad window will be displayed as shown on the right. |

Product Activity report Click on the product you want a report for and then select the option. A notepad window will be displayed showing relevant information about the product. |

Section Hash Count report This can be used to verify that the quantities of purchases and closing stocks that have been typed in matches the manually added totals on the count sheet. A notepad window will be displayed as shown on the right. |

Find a Product You will be prompted to type in the characters or numbers you wish to find. You will be able to find product code, description, cost, etc. Type them in and press Enter. If the product found is not the one you want, you can find the next occurrence of the characters by selecting Find Next or pressing Control-F9. You will not be prompted for the characters and the next product found will be highlighted. |

Set All Products Live You will be warned and prompted to confirm that this is what you want to do.

Set All Products Not Live You will be warned and prompted to confirm that this is what you want to do.

Set Active Products Live This option will look at each product and check whether it has an opening stock, purchases, credits, transfers or closing stock. If so, it will be set as live. You will be warned and prompted to confirm that this is what you want to do.

Set Inactive Products Not Live This option will look at each product and check whether it has an opening stock, purchases, credits, transfers or closing stock. If none, it will be un-ticked. You will be warned and prompted to confirm that this is what you want to do.

Check with Last Audit This option compares the products in this audit with those in the last audit and highlights inconsistencies. A notepad window will be displayed as shown on the right. |

Display External Products You will need to select the outlet whose products you want to display. A search-screen window will be displayed as shown on the right. |

Closing Stocks Report A window will be displayed showing a list of products, together with the closing stock quantity.

Period Product Activity This is similar to the Product Activity Report, as described above. You will be prompted to enter the number of audits that you would like the report to cover.

Zero Selling Prices of inactive products This will change the selling price to zero for all of the products in the current audit which have no activity, i.e. opening stock, deliveries, etc.

Back to Contents