How To: Create a Stock Value Report
Table Of Contents
Introduction
Stock Value Reports help you analyse the value of stock held within Khaos Control.
Reports can be produced from either:
The Stock List reports show stock values as they exist at the moment the report is generated.
The Accounts | Stock Value reports allow you to view historical stock valuations and analyse stock movements over a specific date or date range.
Available Stock Value reports include:
Stock Value Report
The Stock Value Report provides a detailed valuation of individual stock items.
Generate a Stock Value Report
- Open a Stock screen.
- Go to the [ Stock | List ] tab.
- Apply any filters required, for example:
- Supplier
- Stock Type
- Manufacturer
- Category
- Right-click within the grid and select:Print > Stock Value Report
- Choose the report options by clicking the blue button next to each setting.
Available Options
Just report on items IN STOCK?
When enabled, the report only includes items currently holding stock.
Include OVERHEAD figure?
Includes overhead values within the stock valuation calculations.
Include COS EXCLUDE items?
Includes stock-controlled items that are marked as COS Excluded and do not post into stock nominal accounts.
Include System Warehouse (Quarantine, Returns)?
Includes stock held within system warehouses such as:
- Quarantine
- Returns
- Click OK.
- The Stock Value Report is displayed and can be:
- Printed
- Saved to file
- Exported as required
Stock Type Value Report
The Stock Type Value Report summarises stock values by Level 2 Stock Type.
Generate a Stock Type Value Report
- Open a Stock screen.
- Go to the [ Stock | List ] tab.
- Apply any required filters.
- Right-click within the grid and select:Print > Stock Type Value Report...
- When prompted, choose one of the following options:
Yes
Report on all stock items.
No
Report on items currently in stock only.
- The report is generated and displayed.
- Print or save the report as required.
Accounts Stock Value Reports
The reports available within [ Accounts | Stock Value ] provide more detailed historical analysis than those available from the Stock screen.
Unlike the Stock List reports, these reports allow you to analyse stock values over specific dates and time periods.
Generate an Accounts Stock Value Report
- Open an Accounts screen.
- Select [ Accounts | Stock Value ].
- Open the required tab.
Historical Valuation
Displays stock valuation based on historical stock movements and values at a selected point in time.
Aged Analysis
Shows aged stock and net stock movements by ageing period.
Period Analysis
Displays stock movement activity during a selected period.
Site Stock
Displays stock movements and valuations across multiple sites or warehouses.
- Configure the required filters, such as:
- Date
- Date Range
- Site
- Warehouse
- Stock Type
- Click Go to populate the grid.
Printing or Exporting Results
Once the report grid has been populated, you can output the information using either of the following options.
Send to Notepad
Allows you to:
- Export all data.
- Export selected records.
- Save data to external files.
- Import data into spreadsheet applications such as Microsoft Excel.
Print Grid
Generates a printable report using the information currently displayed within the grid.
Choosing the Right Report
| Report | Best Used For |
|---|---|
| Stock Value Report | Current stock valuation by stock item |
| Stock Type Value Report | Stock valuation by stock type |
| Historical Valuation | Stock value at a specific point in time |
| Aged Analysis | Identifying old or slow-moving stock |
| Period Analysis | Reviewing stock movement activity |
| Site Stock | Comparing stock values between sites |
Additional Information
Stock Value Reports are useful for:
- Stock valuation reviews.
- Management reporting.
- Financial analysis.
- Audit preparation.
- Stock aging analysis.
- Warehouse and site comparisons.
- Period-end accounting procedures.
For the most accurate reporting, ensure stock transactions have been processed and updated before generating valuation reports.