The Items Flow by Date Report answers how the stock of each item changed day by day: for each day with movements, the stock at the start of the day, the quantities of each type of document and the stock at the end of the day, in each location. Open it from Reports → Items → Items Flow by Date….
Filter
The Items Flow by Date Report window opens first. Fill in only the filters you need: an empty filter does not limit the report. Click OK to run the report. Clear empties the filters and sets the check boxes back to their default. The window keeps the last filter you ran.

The check box in front of a filter puts its column in the result. In this report a cleared check box only hides the column: the rows stay apart by day, item and location. A text filter finds the values that contain the text. Press F4 or click … to choose from a list.
| Filter | What it limits | Column by default |
|---|---|---|
| Date: | The days, by the date of the documents. Choose a period from the list, or Custom Dates and a start and an end date. Without a start date the report starts with the first document, without an end date it ends today. | Always shown, no check box |
| Item code:, Item name: | The items. | Shown |
| Barcode:, Catalogue: | The items by barcode or catalogue number. Each adds three columns. | Not shown |
| Item group: | The items of a group. | Shown |
| Location:, Location group: | The locations. | Shown |
| Item tag:, Location tag: | Listed when such tags exist. They only filter. | No column |
| Lot:, Serial number:, Production date:, Expiration date:, Lot location: | Listed when you work with lots. They limit the movement columns to the lot. A shown lot column splits the rows by lot. | Not shown |
| Sort by: | Sorts by Date, Code, Item or Location, ascending or descending. Without it the rows are by date. | – |
Results
The result opens in its own tab. The example below has one item in Item name: and one location in Location:, with Barcode:, Catalogue:, Item group:, Location: and Location group: cleared, so each row is a day. Measure and the columns of consignments, productions, notes and returns are hidden with View.

| Column | What it shows |
|---|---|
| Date | The day. |
| Code, Item, Barcode 1 to 3, Catalogue 1 to 3, Measure, Item Group | The item, as it is now in Items. Quantities are in this Measure. |
| Location, Location Group | The location. |
| Beginning Qtty | The stock of the item in the location before that day. |
| Purchase Qtty, Sale Qtty, Waste Qtty, Written-off Qtty | The quantities of the purchases, sales, wastes and write-offs of the day. |
| Stock-taking Qtty | The corrections of the stock-takings: counted minus available, negative for a shortage. |
| Transfer to Location, Transfer from Location | The quantities transferred into and out of the location. |
| Consigned Qtty, Consignment Sold Qtty, Consignment Returned Qtty | The quantities given on consignment and returned. A consignment sale does not change the stock, so the report leaves it out and Consignment Sold Qtty stays 0. |
| Production Ingredient, Production Product | The quantities used and made in productions. |
| Debit Note Qtty, Credit Note Qtty | The quantities of debit and credit notes. |
| Returned Qtty, Returned to Supplier Qtty | The quantities of returns from customers and purchase returns. |
| Ending Qtty | The stock of the item in the location at the end of that day. |
How the numbers are counted
- The report counts saved documents that change the stock. Drafts, documents still pending in another database and documents that do not move the stock, such as orders and offers, are left out. An annulled document no longer exists, so it is not counted.
- A document counts on its Date, the date of the document, not on the day it was saved or edited. A row is made only for a day with movements of the item in the location.
- Beginning Qtty and Ending Qtty count all documents of the item in the location from the first one, also those before the period, and all lots together: the lot filters do not change them.
- Items marked Non-inventory or service and deleted items are left out.
Work with the results
Document opens the print preview of the result with its filters, and Export saves it to a file. Totals adds a row with the totals of the quantity columns. View shows the result as bars or a pie (see View Report Results). Filter → Report Filter shows the filters next to the result and runs it again as you change them, Report Filter as New… opens the result of another filter in a new tab, and Quick Filter searches the text of the rows. Refresh runs the report again. The report can also be a panel of the Dashboard.
The rows of this report do not open an item: double-click does nothing and Actions has no entries. To open an item, use Items Flow with the same filter.
Permissions
All permissions are set in Edit → Administration → Permissions….
| Permission | What it allows | Not allowed by default for |
|---|---|---|
| Reports → Items → Items Flow by Date… | The report. | Operators (the whole Reports menu) |
A user with a Locked location: in the user’s settings gets that location fixed in the filter.
FAQ
Why are some days missing?
A day without documents of the item in the location has no row. The stock of such a day is the Ending Qtty of the day before it in the list.
Why do two rows look the same after I clear Location?
The rows stay apart by location, only the column is hidden. For one row of all locations use Items Flow or Items Accounting Flow.
Why are the rows of different items mixed?
The rows are by date. Choose Item in Sort by:, or one item in Item name:, to follow one item.