Warehouse value development shows how the stored total monetary values of warehouses change over time. You can compare warehouses in a time chart or display the combined total of their latest values. The report does not show quantities, sales prices or the net change from warehouse transactions.
Opening the report and prerequisites
In the browser's main menu, open Dashboard → Report pages and select a report page from the name selector at the top of the view. The warehouse feature must be enabled, and you need permission to view the warehouses you want to examine. User permissions limit the report data, so different users may see different results with the same settings.
The reporting and saving of settings described in this guide take place in the browser. Refreshing a warehouse's product list on Android or iOS fetches the products again; it does not start the warehouse value calculation used by this report.
If the report is not on the page, an administrator can select Add new report at the top of the page, find the Warehouse value development report and drag it onto the page. A new panel is initially an unsaved draft. Creating a new page is described in the guide to creating a report page, and adding and arranging reports in the guide to adding a report.
The data includes warehouses that have not been deleted and have at least one stored value within the requested period. The warehouse named Projektilla is excluded. A warehouse does not need to contain products: a stored zero value qualifies it for inclusion. A value stored only before the period is not enough for a warehouse to be included.
Clearing Warehouse in use on the warehouse editing form does not exclude the warehouse from this report or from automatic value calculations. Deleting a warehouse is a separate action: a deleted warehouse is excluded from the report even when viewing past periods. If needed, see the guide to deleting a warehouse.
Selecting the period and warehouses
Open Settings in the report panel's title bar, next to the settings icon. In Time filters, Tme period for the data determines the period to retrieve, and Time grouping for data determines how the chart points are grouped. The options are day, week, month and year. Days are interpreted using the service's time zone.
A new report defaults to monthly grouping and a Bar chart. The default period runs from the beginning of the month three months ago to the end of the current month, covering four calendar months. For example, in October the default period is 1 July–31 October. All combined is off by default.
You can use a custom date range or a relative period. In the relative period's Time period specification setting, Based on calendar periods uses the boundaries of calendar weeks, months or years. Starting from today uses a rolling period based on today's date. More detailed time selections are described in the guide to report periods and filters.
In All filters, select the warehouses you want in the Warehouse field. If no warehouses are selected, the report uses all warehouses that meet the conditions described above and that you have permission to view. This report does not offer filtering by product or product category.
What does a value in the time chart mean?
Each warehouse's point is the latest stored total value in that time group. For example, values of €100 and then €120 stored in the same month produce a monthly point of €120. The values are not added together or averaged over time.
If a group has no stored value, the report uses the latest value stored before it. That value may also be from outside the requested period. However, carrying values forward does not bring a warehouse into the report if it has no stored values anywhere within the requested period.
If there is no value in the group or before it, the point may appear as zero. A zero therefore does not always prove that the warehouse had no value at that time. For example, the beginning of the chart for a warehouse created later may contain such zeros. Check the warehouse's daily value history to confirm.
Monthly and yearly grouping use complete calendar months and years. If a custom date range ends partway through a month, the monthly point may also use a value stored later in that month, after the selected end date. Use daily grouping when you need a value for a precise date. Weekly grouping collects the days in the selected period into ISO weeks.
The current group shows the latest available stored value, not a forecast for the end of the group. No warehouse value is returned for groups entirely in the future. The chart also does not update in response to goods movements until a new warehouse value has been calculated and stored.
All combined uses the latest values
Select All combined in All filters if you want a single combined total instead of a time chart. This disables the controls for the period, time grouping and warehouse selection. Clear the selection to use them again.
The total consists of the latest stored values of the warehouses included. The Warehouse selection is not used. View permissions and the exclusion of deleted warehouses and the Projektilla warehouse still apply.
The previously defined period also continues to affect which warehouses have the stored value required for inclusion, even though the time controls are greyed out. However, the search for the latest values of the included warehouses is not limited to that period. The total may therefore include values from after the period and values calculated on different days.
If warehouse A has a value of €100 in January and its latest value is €150 in February, and warehouse B's latest value is €200, the combined total for a January query may be €350 when both warehouses have a stored value in January. In that case, the total is neither the warehouse value at the end of January nor the sum of the values stored in January.
Chart presentation and averages
In the settings, open Report settings and select Chart type. The options are Bar, Line, Spline, Area, Spline area, Stacked bar and Stacked area, along with horizontal versions of regular and stacked bars. Pie charts are not available for this report.
A regular chart shows warehouses as separate series. A stacked chart places warehouse values for the same time group on top of each other. Its total height represents the sum of that group's values; this calculation differs from the sum of the latest values in All combined mode.
Show average value adds the arithmetic mean of the warehouses for each time group: the sum of the warehouse values in that group divided by the number of warehouse series included. Zero values are included in the calculation. For example, €120 and €200 produce an average of €160. This is not an average of one warehouse's daily values or the average price of products. The result is rounded to two decimal places.
When displaying the average, missing values are also treated as zeros, so the average may show zero for future groups. In combined total mode, there is only one series, so the average equals the combined total. The average option is not available for horizontal bar charts.
Data labels displays numbers on charts that support them. Logarithmic scale changes the scale, not the warehouse values; it is not available for stacked charts. The grid and title settings available for each chart help make it easier to read.
Where do the stored values come from?
The report reads stored warehouse values and does not recalculate them. The total value is stored to two decimal places. The report's combined total is calculated from these stored values.
In FIFO calculation, the remaining batch quantities are valued at the batches' purchase prices. Purchase batches marked as depleted are excluded, and a missing purchase price is treated as zero. Moving average cost, or MAC, uses the product's company-wide, quantity-weighted average cost. A Current value per product set on a batch row overrides the normal unit price for that row; a value explicitly set to zero also applies. Because of MAC, a purchase in another warehouse may also change the value of the warehouse you are examining. The calculation principles and their differences are described in the guide to warehouse value and product cost.
The automatic evening calculation starts at 23:00 in the service's time zone. This is the start time of the calculation, not a promise of when it will finish. The calculation covers warehouses that have not been deleted, except for the Projektilla warehouse, even when Warehouse in use is not selected. A zero is also stored for an empty warehouse.
If you need a new calculation before the next automatic calculation, open Warehouse management → Warehouses from the main menu. Select a warehouse from the list on the left and open Warehouse value in its Basic information section. In the value window, select Update value. This starts a background calculation; if a calculation is already queued or running, a new one is not started. Wait for it to finish and reopen the value view to confirm the calculation time. The update stores a new total value and replaces the current product-by-product breakdown, but does not change stock balances.
A purchase price correction or a backdated purchase may correct previously stored values, so old report points may also change. Correcting old MAC values requires sufficient average cost history. If the required old or new MAC price is missing, or the stored record is not suitable for correction, the previous total value may remain unchanged. A price correction therefore does not guarantee that the entire past report history will be corrected, and starting a new calculation does not reconstruct missing historical daily values.
Saving settings
Changing filters fetches the chart data again. A change in the chart alone does not mean the settings have been saved for the next visit. Saving settings permanently requires administrator permissions.
Save the settings of an existing report panel using Save Settings in its title bar. Administrators can see this action when the panel's Settings are open.
Save changes to a new report or the whole page using Control report page → Save the page in the menu at the top of the view. This saves the page's reports, including their settings and filters, positions and sizes. Check the selections in the other panels as well before saving the whole page.
Saving changes the configuration of the shared report page. Other users receive the saved settings when they reopen the page, but their view permissions still limit the data. Saving does not freeze the report figures: they may change with new warehouse values, historical corrections and the relative period. Opening the report, filtering it and saving its settings do not change stock balances, purchase prices or warehouse value history.
Confirm that a successful save notification appears. Then reload the view, select the same report page and open the panel's settings. Check that the period, grouping, warehouse selection, combined total mode and presentation settings were retained. After saving the whole page, also check the new panels and layout. Simply switching pages and returning is not enough, as the open view may retain unsaved changes. If saving produces an error, check the situation after reloading: some of the page's reports may already have been saved.
Checking figures and investigating discrepancies
First check the requested period, time grouping, Warehouse selection and All combined mode. In the time chart, compare a point with the group's last stored value or, if the group has no stored value, the preceding value. For a combined total, check each included warehouse's latest value and its calculation time.
Open the warehouse value window described above and select History. Compare the report point with the Value column in the history. Value change represents the change derived from events and calculation explanations, not the warehouse's total value.
History shows the last actual stored value for each day in the service's time zone. A day with no stored value is omitted from the history. The report chart may still carry the previous value forward to that day. A missing history row therefore does not mean zero or that there were no events that day. The warehouse value history guide helps you check daily values, explanations of changes and warnings about incomplete history. The maximum six-month period for a single history query is a limitation of the history view, not a general time limit for this chart.
If a warehouse is missing from the report, check view permissions, deletion status and whether it has at least one stored value in the requested period. If the chart shows zero, check whether it is a stored zero value, a time before the first stored value or a missing value in the average display. If a figure differs from what you expected, also check the calculation time, the use of the full calendar group and corrections to previous values.