The Stock value printout gives you a statement of how many products you have in stock, what they are worth, and how the value is distributed across the groupings you choose yourself (e.g. category, supplier or stock location). You can print it, save it as a PDF and export it to Excel.
1. In Financial you open Product and then Products.
2. In the top right corner of the Products page, click the printer icon.
3. Select the Stock value printout (it is located in the Stock group).
4. Fill in the criteria (they are explained below).
5. Click the print format you want — e.g. screen/PDF or Excel.
The printout can also be opened from the top print menu (the same printer button) elsewhere in the system, where it is located under the Stock group.
If you cannot see the menu item or the printer icon, you are most likely missing permissions — contact support.
These criteria limit which products the report includes. If you leave a field blank, everything within that criterion is included.
Org. units: Limit the statement to one or more stores/warehouses (organizational units). If you leave the field blank, all the units you have access to are included.
Stock date: The date the statement should follow. The stock value is calculated as it looked on the selected date.
Keyword: Limit to products with a specific keyword.
From product category / To product category: Specify a category range that the statement should stay within.
From product / To product: Specify a product range (from-to) that the statement should stay within.
Supplier: Show only products from the specified supplier.
Stock location: Show only products located at the specified stock location.
Number search (%): Search product numbers using the percent sign (%) as a wildcard. Example: if you enter 12%, all products whose number starts with 12 are included.
Name search (%): Search product names using the percent sign (%) as a wildcard. Example: if you enter cyk%, all products whose name starts with cyk are included.
Stock balance: Determines which products are included based on balance and value. You can choose between With balance or value (products that either have a quantity in stock or a stock value), Without balance, All products, Negative balance only, Positive balance only and Stock value without balance (products that have a value but no quantity in stock).
Which products: Determines how serial number items are handled. You can choose between All products, Serial number items only, No serial number items, Serial number items covered by the used-goods VAT scheme only and Used serial number items only.
Exclude reservations: Note that the field is called *Exclude* reservations. If you choose Yes, reserved products are kept out of the stock value. If you choose No, reserved products are included in the statement.
The report can break the figures down into up to five levels, so you can see the stock value distributed exactly as you need. You fill them in from the top down:
Show: The top grouping level — the primary breakdown of the report.
- then show: The fields below Show add further sub-levels (level 2 to 5). If you only want to group on one level, leave the remaining fields set to Empty.
On each level you can group by: Org. unit, Category, Stock account, Primary supplier, Stock location, Product, EAN, Variant, Serial number item, Serial number, Latest stock receipt (the product's age — see *Age interval* below) or a Dynamic field.
Dynamic field (for grouping): If you select Dynamic field as a grouping level, you specify here the name of the dynamic product attribute field to group by.
Age interval (months): Used when you group by Latest stock receipt. Here you specify how many months each age interval should cover.
Sort by: Determines the order of the result. You can choose By show grouping (follows your grouping choices), Largest stock quantity, Smallest stock quantity, Largest stock value or Smallest stock value.
In addition to the standard columns, you can enable two extra value columns:
Show posted stock value: Choose Yes to get a column with the posted stock value alongside the ordinary stock value.
Show FIFO stock value: Choose Yes to get a column with the FIFO stock value (the value calculated using first-in-first-out).
For each group and line, the report shows, among other things:
Stock quantity: The available quantity in stock.
Avg. cost price: The average cost price per unit (the stock value divided by the quantity).
Stock value: The total stock value of the products.
Reserved quantity: How much of the balance is reserved.
Latest stock receipt: The date of the latest receipt into stock.
If you have enabled them, Posted stock value and FIFO stock value are also shown as separate columns. Each grouping level is summarized, so you see both totals per group and an overall sum for the entire statement.
If you want to work further with the figures, you can choose the Excel format instead of printing when you generate the report.
The stock value is calculated from the product data you maintain elsewhere in the system: the products' cost prices and stock balances, their association with category, stock account, primary supplier and stock location, as well as any dynamic fields and serial numbers. The report retrieves this information and calculates the stock value as of the selected Stock date and within the stores/warehouses you have access to. The printout itself does not change anything in the data — it is purely a statement that you can print, save as a PDF or export to Excel.
Want to know more?
Read more in these related articles:
Stock value compared to posted
Stock value compared to posted
Stock archive
Complete walkthrough of the Stock archive screen in Financial: columns, filters, actions, the posting operation dialog with tabs, aggregated/detailed view, context menu, popups and permissions.
