--- title: "Stock value" description: "How to print a stock value statement in Sapera: find the report, understand each criterion, build your groupings and understand the columns in the result." url: https://support.sapera.io/en/articles/19-stock-value collection: "Product printouts" updated: 2026-06-28 language: en alternates: [da] --- # Stock value How to print a stock value statement in Sapera: find the report, understand each criterion, build your groupings and understand the columns in the result. 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. ## How to find the printout 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. ## Parameters 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. ## Select grouping: how the result is broken down 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**. ## Select extra value columns 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). ## How to read the result 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. ## Where is it used 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. [How to search in lists](https://support.sapera.io/en/articles/545-sadan-soger-du-i-lister.md) ### Settings support can configure Beyond the many filters shown in the print dialog, the stock list has a few settings that control which values are included. They can be turned on/off or adjusted by support per company. If you want the printout customized, contact support and refer to the relevant setting below. The technical name is shown in parentheses. - Show booked stock value (showbookedstockvalue) - Show FIFO stock value (showfifostockvalue) - Age interval in months for the stock-age breakdown (ageintervalmonths) * * * **Want to know more?** Read more in these related articles: [ Stock value compared to posted Stock value compared to posted ](https://support.sapera.io/en/articles/213.md)[ 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. ](https://support.sapera.io/en/articles/116.md)