The Items Input Control Report answers what came in with each purchase, for the input control of goods: every purchase row with its date and time, the manufacturer, the lot, the quantity, the expiration date, where the goods are stored, the transport and the accompanying document. Open it from Reports → Items → Items Input Control….
Where the data comes from
The report shows what was entered in the purchases. In the Purchase window, click View → Addon properties… and select the properties you need:
- Manufacturer, Lot, Expiration Date, Storage Location and Accompanying Document are columns of the rows. Manufacturer suggests the supplier of the purchase until you type another name.
- Time and Transport are fields of the whole purchase.
When you work with lots, Lot and Expiration Date come from the lot of each row.
Filter
The Items Input Control 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. Each row is one purchase row, so a cleared check box only hides its column. 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 period, by the date of the purchases. Choose a period from the list, or Custom Dates and a start and an end date. | Shown |
| Manufacturer: | The rows by manufacturer. | Shown |
| Item name: | The items. | Shown |
| Lot: | The rows by lot. | Shown |
| Quantity: | The rows by quantity. | Shown |
| Expiration date: | The rows by expiration date. | Shown |
| Transport: | The purchases by transport. | Shown |
| Sort by: | Sorts by Date, Manufacturer, Item, Quantity or Transport, ascending or descending. | – |
Results
The result opens in its own tab. The example below shows a purchase of today with all the properties filled in, found with today in Date: and the start of the manufacturer names in Manufacturer:.

| Column | What it shows |
|---|---|
| Manufacturer | The manufacturer of the row. |
| Date, Time | The date and the time of the purchase. |
| Item | The item, as it is now in Items. |
| Lot, Expiration Date | The lot of the row and its expiration date. |
| Quantity | The purchased quantity, in the item’s Measure. |
| Storage Location | Where the goods of the row are stored. |
| Transport | The transport of the purchase. |
| Accompanying Document | The document that came with the goods of the row, for example a certificate. |
How the numbers are counted
- The report lists the rows of the saved purchases. Drafts and documents still pending in another database are left out. Other documents, such as purchase returns or transfers, are not in the report.
- A purchase counts on its Date, the date of the document.
- A column is empty when its property was not filled in for the row or the purchase.
- The report has no supplier, price or location column.
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 total of Quantity. 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.
Double-click a row or use Actions → Edit to open its item. Actions → Transform Selected Items puts the selected items in a new document (see Transform Document). Actions → Print Selected Items prints their labels when a quick print setup of Print Barcodes exists.
Permissions
All permissions are set in Edit → Administration → Permissions….
| Permission | What it allows | Not allowed by default for |
|---|---|---|
| Reports → Items → Items Input Control… | The report. | Operators (the whole Reports menu) |
| Change Addon Properties | View → Addon properties… in the document windows, to choose the properties the purchases show. | Operators |
FAQ
Why are most columns empty?
The purchases were saved without those properties. Add them with View → Addon properties… in the Purchase window and fill them in for the next purchases.
How do I find the goods that expire soon?
Choose the coming days in Expiration date:. For the quantity still in stock use Items in Stock.
Where do I see the supplier of each row?
This report has no supplier column. Purchases by Items can show the purchased items of each supplier.