How To: Create a Stock Printout for a Stock Take when using Warehouse Control

Two suggestions for printing out sheets to use while stock taking are:

1. Printing the stock sheet from Khaos Control.
2. Exporting the stock information and importing it into Excel where you can configure it for example to match the areas in your warehouse.

Printing the stock sheet from Khaos Control

To create a stock take sheet that you can mark up when manually counting the stock items:

1. Open a Stock screen (show me how)..
2. Go to the [ Adjustments | Adjust (Warehouse) ] tab.
3. Display the stock items and locations by either:
   1. By Stock Item:
      1. In the Stock Code text box add the stock code along with a wildcard for the group of items you wish to stock take, for example 70% will load all stock items with a stock code starting 70.
      2. Click on the button to load the stock items into the grid.
   2. By Location:
      1. In the Location text box enter the location code along with a wildcard for the group of locations containing the items you wish to stock take.
      2. Click on the button to load the items into the grid.
4. Click on the Location column heading to sort it, or focus in the Location column and press Ctrl+D.
5. Open the grid menu (the green down facing arrow to the left of the column headings).
6. Select Print Grid from the options.
   1. Enter a title for the print out and click on OK.
   2. In the Print popup you can select the columns to hide, if you want to include a total column for a numerical column or if you want to send the report directly to the printer without previewing it. This is done for each column by selecting the column name in the Columns area and checking or un-checking the appropriate checkbox to the right.
   3. Set the other options as you require (column spacing, line spacing, font etc)
7. Click on OK to either print or preview the report.
   

Note: once you have decided on the settings you want for your stock take you can save these settings by clicking on the Save Column Setting button on the right. You can then use these settings when printing further stock take reports at step 7 above by clicking on Load Column Settings and selecting the appropriate saved column settings.

Exporting the Stock Information

1. Open a Stock screen (show me how)..
2. Go to the [ Adjustments | Adjust (Warehouse) ] tab.
3. Display the stock items and locations by either:
   1. By Stock Item:
      1. In the Stock Code text box add the stock code along with a wildcard for the group of items you wish to stock take, for example 70% will load all stock items with a stock code starting 70.
      2. Click on the button to load the stock items into the grid.
   2. By Location:
      1. In the Location text box enter the location code along with a wildcard for the group of locations containing the items you wish to stock take.
      2. Click on the button to load the items into the grid.
4. Click on the Location column heading to sort it, or focus in the Location column and press Ctrl+D.
5. Follow the steps for copying the information from a grid to Excel

After the Stock Take

Once the stock take has been carried out then the appropriate adjustments can be made to the stock levels in the [ Adjustments ] tab, see How To: Adjust Stock when using Warehouse Control.

Note: there is no method of carrying out a full stock take without stopping production. The stock take will need to be done manually.

See Also

• Stock screen
• Warehouse Location Control