The Operations Report lists the rows of the saved documents of every type: each row of each document that matches the filter is one row of the result, with its document number and type, date, partner, quantity, prices and amounts. Use it to see everything that happened with an item, a partner or a location, whatever the type of the documents. Open it from Reports → Operations….
Filter
The Operations 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. A filter without a check box always has its column. Each row is one row of a document, 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. The rules for text in a filter are on View Report Results.
| Filter | What it limits | Column by default |
|---|---|---|
| Operation No.: | The document numbers, from one number to another. | Always shown |
| Date: | The period, by the date of the document. Choose a period from the list, or Custom Dates and a start and an end date. Without dates the report covers all documents. | Always shown |
| Operation: | The type of the documents. All shows every type. Transfer shows the transfers in both directions, Production the ingredients and the products and Recipe both sides of the recipes. Advance Payment, Money In, Money Out and Money Audit have no item rows, so they give an empty result. | Always shown |
| Item code:, Item name: | The items. | Item code: shown, Item name: always shown |
| Barcode:, Catalogue: | The items by barcode or catalogue number. Each adds three columns. | Not shown |
| Item group: | The items of a group. | Not shown |
| Lot:, Serial number:, Production date:, Expiration date:, Lot location: | Listed when you work with lots. | Not shown |
| Partner name:, Partner group: | The partner of the document. | Shown |
| Location:, Location group: | The location of the document row. | Shown |
| User:, User group: | The user in the User field of the document. | Shown |
| Item tag:, Partner tag:, Location tag:, User tag: | Listed when such tags exist. They only filter. | No column |
| Quantity:, Profit: | The rows by their Quantity or Profit: choose equals, not equals, more than or less than and type a number. Profit: is not listed for a user without Show items profit. | Shown |
| Note: | The documents by the text of their note. | Not shown |
| Sort by: | Sorts by Operation No., Date, Item, Code, Partner Name, Location or User, ascending or descending. It sorts only by a column that is shown. | – |
Results
The result opens in its own tab. The example below shows the documents of one item in one location in the last ten days. Item code:, User: and the three group filters are cleared, and Measure and the VAT columns are hidden with View, so the amounts fit on the screen.

| Column | What it shows |
|---|---|
| Operation No., Operation, Date | The number, the type and the date of the document. |
| Code, Item, Barcode 1 to 3, Catalogue 1 to 3, Item Group | The item, as it is now in Items. |
| Partner Name, Partner Group, Location, Location Group, User, User Group | The partner, the location and the user of the document. |
| Quantity, Measure | The quantity of the row, in the measure it was entered in. A quantity that left the stock, for example a sold one, is positive too. |
| Sale Price, Sale Amount | The sale price of one measure saved with the row, after its discount, and Quantity × Sale Price: with VAT when prices include VAT, without VAT when they do not. |
| VAT Received Included or VAT Received, VAT Received Amount Included or VAT Received Amount | The VAT of the sale price, for one measure and for the row. |
| Purchase Price, Purchase Amount | The purchase price of one measure saved with the row, and quantity × purchase price. |
| VAT Given Included or VAT Given, VAT Given Amount Included or VAT Given Amount | The VAT of the purchase price, for one measure and for the row. |
| Profit | The quantity × (the sale price − the purchase price saved with the row). It means a profit only for the rows that sell. |
| Note | The note of the document. |
How the numbers are counted
- The report shows the saved documents of every type, also the ones that do not change the stock, such as offers, orders and restaurant orders. Drafts are in Drafts, and documents still pending in another database are left out. An annulled document no longer exists, so it is not shown.
- Each row of a document is one row of the result, and nothing is added up. A transfer gives two rows for each item: one in the location it left and one in the location it came to.
- A document counts on its Date, the date of the document, not on the day it was saved or edited.
- The prices and amounts include VAT when Use prices with included VAT is selected in Tools → Settings… → Special. The VAT columns are hidden when VAT registered is cleared there or all VAT groups are 0%.
- Amounts are in the main currency of the program. A document made in another currency is shown at the rate saved with it.
- Item, partner, location and user names come from the lists as they are now, not as they were on the day of the document.
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 Quantity, the amounts and Profit; with several types in the result it adds them all, so choose one type in Operation: for a total that means something. View shows the result as bars or a pie, for example the quantities by operation. 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. View Report Results describes all of these.
Double-click a row or use Actions → Edit to open its document for editing, with the checks and permissions of its page in Edit → Documents, for example Edit Sales. Actions → Print prints the document. The other entries of Actions, such as Related Documents, Show Changes History and Transform Selected Documents, depend on the type of the selected documents.
Permissions
All permissions are set in Edit → Administration → Permissions….
| Permission | What it allows | Not allowed by default for |
|---|---|---|
| Reports → Operations… | The report. | Operators (the whole Reports menu) |
| Manage operators and view their operations | The documents of all users. Without it User: is fixed to your name. | Operators |
A user with a Locked partner: or Locked location: in the user’s settings gets that partner or location fixed in the filter. A user without Show items purchase price there does not see the purchase price, the purchase VAT and Profit columns, and a user without Show items profit does not see Profit.
FAQ
How do I see everything that happened with one item?
Type the item in Item name:, leave All in Operation:, choose the period in Date: and sort by Date. For the stock at the start and the end of each day, use Items Flow.
Why is a transfer on two rows?
A transfer takes the items out of one location and puts them in another, and each side is a row with its own location. Type a location in Location: to see one side.
How do I find who changed a document?
Select its row and use Actions → Show Changes History. The report itself shows each document as it is now.
Related pages
- Reports
- Drafts report
- Sales and Purchases reports
- Items Flow
- Edit → Documents
- Print preview
- View Report Results