The Inventory on cut-off date screen shows the stock balance and stock value you had on a chosen date. You select a cut-off date, and the system calculates how your inventory looked at that exact point in time.
The feature is typically used for accounting, stocktaking, and end-of-period reconciliation, where you need an accurate snapshot of the stock value on a specific date. It is useful for warehouse managers, accountants, and managers.
Prerequisites
Before you use the screen, make sure that:
You have access to the Logistic module.
Warehouses and articles are set up and in use.
Inventory movements (receipts, withdrawals, orders, stocktakes) have been registered for the period you want to view.
Step-by-step
Log in to ProdSys at app.prodsys.com.
Open Logistic in the menu and select Inventory cut-off. 👉 Open the screen in ProdSys
Choose a Cut-Off Date. This is the date the balance is calculated for.
Select a warehouse in the dropdown, or leave All Warehouses to see everything together.
Click Show all to load the balance.
Read the balance and value in the Inventory on cut-off date table. The grand total appears at the bottom.
Click an article to see the transactions behind the figures in the Movements panel at the bottom.
How the figures are calculated
Quantity and value are based on the inventory movements up to and including the chosen cut-off date. The value is calculated using the WAC (weighted average cost) at that point in time. This means Total Value reflects the actual stock value as it was on the date you selected – not today's cost price.
Field reference – Inventory on cut-off date
Field | Description |
Warehouse | The warehouse where the article is stored |
Article No. | The unique article number |
Description | A short description of the article |
Location | The storage location within the warehouse |
Quantity | The balance on the cut-off date, with unit (pcs, m, m², etc.) |
Total Value | Calculated stock value based on WAC on the cut-off date |
Field reference – Movements
Field | Description |
Order category | The movement type, e.g. Order or Stocktake order |
Category number | The order or stocktake number the movement comes from |
Customer name | The customer linked to the movement |
Movement Date | The date the movement was registered |
Qty | The quantity moved in or out |
Price | The unit price for the movement |
Location | The storage location the movement applies to |
Filtering and grouping
Use the filter icon in a column header to find specific warehouses, articles, or locations.
Click a column header to sort.
Drag a column header into the "Drag a column header here …" area to group the data, for example by warehouse.
Choose the number of rows per page (5–40) at the bottom, and browse with the page numbers.
Tips and best practices
Set the cut-off date to the last day of the period when reconciling against your accounts.
Use All Warehouses to see the total value for the whole company, or filter by one warehouse for closer control.
Click into articles with a negative quantity (shown in red) to find the cause in Movements.
Related articles
The inventory balance screen
Inventory by location
Stocktaking