The Availability by Date Report answers how much of each item was in stock after each day on which it moved, in each location. It has one row for each day with movements of the item in the location. For the stock of all items on one chosen day, with its value, use Availability as of. Open it from Reports → Items → Availability by Date….
Filter
The Availability 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 dates the report shows every day with movements. | Always shown, no check box |
| Item code:, Item name: | The items. With Item name: cleared, Measure is hidden too. | 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 days to those with movements of the lot. A shown lot column splits the rows by lot. | Not shown |
| Quantity: | The rows by the quantity in stock after that day, more, less or equal to a number. | Always shown, no check box |
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: and Location group: cleared, so each row is a day on which the item moved there. The rows are by date.

| Column | What it shows |
|---|---|
| Date | A day with movements of the item in the location. |
| 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. |
| Quantity | The stock of the item in the location at the end of that day. |
How the numbers are counted
- The days come from 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, make no row. 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.
- Quantity adds all documents of the item in the location up to and including that day, from the first one, so the date filter does not change it. It is the stock of all lots together: the lot filters do not change it.
- 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. 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 in Stock with the same item.
Permissions
All permissions are set in Edit → Administration → Permissions….
| Permission | What it allows | Not allowed by default for |
|---|---|---|
| Reports → Items → Availability 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. With Show items available quantity cleared there, the user does not see Quantity.
FAQ
How do I find the days on which an item went below zero?
Choose the item in Item name: and set Quantity: to less than 0.
Why are some days missing?
A day without documents of the item in the location has no row. The stock on such a day is the Quantity of the day before it in the list.
Where do I see what moved on each day?
In Items Flow by Date, which has the same days with the quantity of each type of document.