Accounts Stock Value Historical Valuation Tab

The [ Accounts | Stock Value | Historical Valuation ] tab displays stock valuation and history based on past stock movements. The Historical Valuation tab comprises of three areas, Top Filter, Grid and Bottom Action Pane.

There may be differences between the Stock Value Report and the Stock Nominal.

The reasons for stock value differences when comparing the Stock Value report and the Stock Nominal include:
  1. Stock Received not Invoiced - stock has been booked in on delivery note, but not invoiced to accounts yet.
  2. Non stock controlled items show in nominal but not in the stock value report.
  3. Items marked as Stock COS Exclude are in stock value report but not in the nominal.
  4. Journals are on the stock nominal and not in stock value report.
  5. Changes in the stock items' stock value over time.
  6. Customer returns - stock has been booked back in but the credit note has not been issued yet.
  7. Adjusting stock in without a value and then adding a value later.
  8. Not posting Purchase Invoices.

For more detailed information on Stock Value Differences please follow this link

See How To: Create a Stock Value Report for information about creating stock value reports using the sub-tabs in the Stock Value screen.

Historical Valuation Top Filters

Accounts Stock Value Historical Valuation Tab top filters

The filter area contains:

  • Site (Red Traffic Light Filter /Green Traffic Light Filter traffic light filter): view items from all sites or just one.
  • Date Range: view data in a specific date range, this will allow you to see the stock levels at a given point in time, or stock movements within a period.
    Note: the date range needs to start at the year 2000 as it shows the shows the stock movements (ins and outs) over the period. The quantity displayed is the balance of the number of items in stock at that point in time.
  • Pricing Type: this drop-down has the following options:
    • Current Stock Value: the system calculates value based on the current Stock Value for each item. The "Current Stock Value" could be an average Stock Value for that item over time, depending on how the system is configured to calculate the Stock Value in [ System Values | Options | Stock], for more information on average pricing please go to the Average Price page.
      Note: for the following Pricing Type options currencies will vary and will show a mixture of currency information where applicable.
    • Last used (historical) price [POrder](Gross): the value is calculated based on the last buy price used in the selected period. For example, if you were viewing a valuation for 20/05/2005, the value would be based on the last price paid prior to this date, if any.
      Note: If the stock items only movement was a stock adjustment then the stock value will be zero (0.00).
    • Avg. (historical) price [POrder](Gross): the value is calculated from an average of all purchase orders within the date range selected.
    • Last used (historical) price [PInvoice] and Avg (historical) price [PInvoice]: these two options work the same as the two historical buy price options, but take the price from the purchase invoice rather than the purchase order, and they use the Net price, not the Gross.
  • Overheads: this drop-down has the following options:
    • Not included: overheads are not included in the calculations.
    • Included: overheads are included in the calculations and total, but are not added to the stock value as displayed within the grid e.g. (£10 x 1 item = £11 (because there was a £1 overhead).
    • Overheads Only: only the overheads are shown.
  • Warehouse Locations: these are the system warehouse locations of:
    • Stock Holding: including Active Stock, Quarantine, Returns but not written off.
    • Active Stock: not in a system warehouse location.
    • Quarantine: stock items in quarantine.
    • Returns: the Returns Bay.
    • Written Off: written off stock.
    • All Movements: will display all stock movements throughout Khaos Control.
  • Supplier (Red Traffic Light Filter /Green Traffic Light Filter traffic light filter): use the the green opening folder icon is normally linked to the opening of a dialog box that allows the user to browse and select a value or range of values button to select a supplier to filter the grid by. The grid will display all stock that the selected supplier can supply regardless whether the supplier is the preferred of not for that item.
  • COS Excluded Items: include items marked as COS Excluded Item in their [ Stock | Detail | Options ] tab.
  • Exclude 0 valuation: don't include stock items with zero valuation.
  • Show Discontinued: selects whether to include discontinued items.
  • By Stock:
    • Item: view the results by individual stock item.
    • Type: view the results by level 2 stock types.
  • button: displays the UDA dialog enabling the user to filter the grid by Stock User Defined Attributes (Stock UDAs).

Historical Valuation Grid

When an option is selected the system populates the grid with a list of all stock items, and This stock level is

  • Stock:
    • Code: stock code.
    • Description: short description of the stock item.
    • Stock Value: the value generated based on the price option chosen and the level of stock at the historical date.
      Note: if filtering by Stock Type, this column is the average stock value across that stock type.
  • Total Stock:
    • Qty Stocked: based on the movements held against each item; so, if the stock movements have been removed (e.g. by taking an item off stock control) the system is unable to generate a level for that item.
    • Valuation: the value of stock items. This is Stock Value x Qty Stocked = Valuation unless the Overheads are included where are included but not visually added to the Stock Value.
      Note: the caveats above the stock value calculations.

Historical Valuation Context Menu

  • Goto Stock Item: opens the stock screen for the selected item.
  • Clear Selection: deselects the currently selected line(s).

See Also

Did you find this article helpful?