The Partners Participation in Operations Report answers how much each partner took part in the documents of a chosen type in a period, for example how much each customer bought this month. It lists the partners with the total quantity of the rows of those documents, and can split it by location. Open it from Reports → Partners → Partners Participation in Operations….
Filter
The Partners Participation in 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 cleared check box also adds the rows up over that column: Location: is cleared by default, so a partner has one row for all locations of a location group, or one row for all locations when Location group: is cleared too. A filter without a check box always has its column, except Date: and Operation:, which only filter. 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 of the documents counted in Total Qtty. Choose a period from the list, or Custom Dates and a start and an end date. Without dates the report counts the documents of every date. | No column |
| Partner name: | The partners by name. | Always shown, no check box |
| Partner group: | The partners of a group. | Shown |
| Location: | The locations of the documents. A partner without documents of the type and period has no location, so a location here leaves it out. | Not shown |
| Location group: | The locations of a group. | Shown |
| Partner tag:, Location tag: | Listed when such tags exist. They only filter. | No column |
| Total qtty: | The rows by Total Qtty: choose equals, not equals, more than or less than and type a number, for example more than 0 for the partners that took part. | Always shown, no check box |
| Operation: | The type of the documents counted in Total Qtty. All counts every type. Transfer counts the transfers into the locations, Production and Recipe the ingredients. Purchase does not limit the report: the result is the same as with All. | No column |
| Sort by: | Sorts by Partner Code, Partner Name, Location or Total Qtty, ascending or descending. It sorts only by a column that is shown. | – |
Results
The result opens in its own tab. The example below has Sale in Operation:, the last ten days in Date: and more than 0 in Total qtty:, so it lists the customers of these days. Location group: is cleared, so each customer has one row.

| Column | What it shows |
|---|---|
| Partner Code, Partner Name, City, Address, Contact Name, UIC, Partner Group | The partner, as it is now in Partners. All but Partner Group have no check box: hide them with View. |
| Location, Location Group | The location of the documents. |
| Total Qtty | The sum of the quantities of all rows of the documents of the type and period with this partner, in the measures of the items. 0 when there are none. |
How the numbers are counted
- Every partner is listed, also the ones without documents of the type and period: they have 0 in Total Qtty. The partners moved to the Deleted group are left out.
- Total Qtty adds the quantities of different items together, for example 2 pieces and 1.5 kg make 3.5. It shows how much a partner took part, not an amount of money. For the amounts use Sales by Partners or Purchases by Partners.
- Only saved documents count. Drafts and documents still pending in another database are left out, and an annulled document no longer exists.
- A document counts on its Date, the date of the document, not on the day it was saved or edited.
- Partner and location names come from the lists as they are now.
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 Total Qtty. 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 partner (see Adding, editing and deleting partners).
Permissions
All permissions are set in Edit → Administration → Permissions….
| Permission | What it allows | Not allowed by default for |
|---|---|---|
| Reports → Partners → Partners Participation in Operations… | The report. | Operators (the whole Reports menu) |
A user with a Locked partner: or Locked location: in the user’s settings gets that partner or location fixed in the filter.
FAQ
How do I find my best customers of the month?
Choose Sale in Operation: and the month in Date:, set Total qtty: to more than 0 and sort by Total Qtty descending. For the best customers by money, use Sales by Partners.
Why does a partner have several rows?
The partner has documents in locations of different location groups, and Location group: is selected. Clear it for one row per partner.
How do I see the partners without documents?
Set Total qtty: to equals 0, or use Partners not in Use in Operations.