Select Page

Partners not in Use in Operations

The Partners not in Use in Operations Report answers which partners have no document of a chosen type in a period, for example the customers who bought nothing in the last three months. It lists these partners with their details. Open it from Reports → Partners → Partners not in Use in Operations….

Filter

The Partners not in Use 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.

Partners not in Use in Operations Report filter window with Date, Partner name, Partner group, Operation, Sort by and the OK, Cancel and Clear buttons

The check box in front of a filter puts its column in the result. Each row is one partner, 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 in which the partner has no document. Choose a period from the list, or Custom Dates and a start and an end date. Without dates the report lists the partners without any such document. No column
Partner name: The partners by name. Always shown, no check box
Partner group: The partners of a group. Shown
Partner tag: Listed when partner tags exist. It only filters. No column
Operation: The type of the documents. All looks at the documents of every type. Transfer looks at the transfers in both directions, Production and Recipe at both of their sides. No column
Sort by: Sorts by Partner Code or Partner Name, ascending or descending. –

Results

The result opens in its own tab. The example below has Sale in Operation: and the last ten days in Date:, so it lists the partners who bought nothing in these days, the suppliers among them.

Partners not in Use in Operations Report results with the Partner Code, Partner Name, City, Address, Contact Name, UIC and Partner Group columns and the Close, Document, Export, View, Filter, Actions and Refresh buttons
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.

How the numbers are counted

  • A partner is listed when no saved document of the chosen type and period has this partner, in any location. Drafts and documents still pending in another database do not count as a use. An annulled document no longer exists, so it does not count either.
  • Only documents with item rows count. A partner with only advance payments or cash entries in the period is listed.
  • A document counts on its Date, the date of the document, not on the day it was saved or edited.
  • The partners moved to the Deleted group 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, for example to contact the customers again. 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 not in Use in Operations… The report. Operators (the whole Reports menu)

A user with a Locked partner: in the user’s settings gets that partner fixed in Partner name:.

FAQ

How do I find the partners that were never used?

Leave Date: empty and All in Operation:. The result lists the partners without any saved document.

Can I delete the partners in the list?

Not from the report. Open them in Partners: a partner with documents of another type or period cannot be deleted and can only be moved to the Deleted group.

Documentation