Skip to content

Groups and segments

A group is a fixed list of records, with a name: ‘The trade fair ones’, ‘Items in the autumn promotion’, ‘Invoices to review’. A segment is a rule, also with a name: ‘Customers in Valencia who have bought this year’. The group always has the same ones until you add or remove one; the segment says, each time it is used, who meets the rule that day. They can be about customers, suppliers, items, documents or almost any other type of record. Both are saved from any report and are in CRM → Groups and segments.

How does a group differ from a segment of customers, items or invoices?

The group stores which ones; the segment stores the question. If you save the customers in Alicante as a group, tomorrow they are still the same ones even if one moves away. If you save them as a segment, the one who moves to Alicante comes in on their own and the one who leaves drops out. With items or invoices it works the same way: the group is today’s list; the segment, the rule.

GroupSegment
What it storesA list of recordsA rule: a report, its ranges and some steps
Changes on its ownNoYes, each time it is used
Records are added or removed by handYesNo: the rule decides
Useful forA closed list that you decide‘The ones that meet this’, today and a month from now

You can make a group out of a segment whenever you like, with Save as group: it is the snapshot of who meets it today.

What types of record can a group or a segment be about?

Almost all the ones that appear in a report: the ones with an identity of their own, that is, that can be pointed out one by one. The full list is the one in the It is a group of drop-down.

There are four reports whose rows aren’t records but summaries or events: the balances accumulated by account and month, the balances by cost centre and month, the change log and the access log. They can be queried just the same, but they aren’t saved in a group or a segment.

Each group and each segment is of a single type, chosen when it is created and not changed afterwards.

What do I see in the list of groups and segments?

One row for each group and each segment you can use: your own and the ones someone else in the company has shared. For each one it says whether it is a group or a segment, what type of record it is about, how many records it has and whose it is. For a segment, the records column says ‘by its rule’: it doesn’t store anyone, so it is counted when you open it.

At the top you search by name or description and filter by whether they are groups or segments and by type of record: the drop-down starts at ‘All record types’ and has one option per type. Clicking a row opens its record.

How do I create a group of items, documents or customers?

There are two ways. The usual one is from a report of that type: you narrow it until you have the records you want and save it with Selection (it is in running a report). The other is to create it empty here, with New group, and add the records one by one by their code. That second way only works for types that have a code finder; the rest are filled from a report.

Step by step

  1. Click New group.
  2. Type the Group name. It can’t be repeated among the ones you see, not even by changing capitals or accents.
  3. In It is a group of, choose the type of record: customers, suppliers, items, sales documents… It can’t be changed afterwards.
  4. Click Create the group. Its record opens, ready for you to add members.

How do I create a segment of customers, items or invoices?

A segment always starts from a report: you open it, enter its ranges, add the Query steps you need and save it with Selection → Segment. What is saved is exactly that —the report, the ranges and the steps that are on—, not the records that were showing. The segment is of the *report*’s type of record: customers if it was a customers one, sales documents if it was an invoices one. It is in running a report.

What is in the record of a group of customers, items or documents?

At the top, its name, a description to remind you what it is for and the Share it with the whole company box. Below, how many are in the group and the list of its members. What it shows for each one depends on the type:

For each member you see what its record says today: the group stores which one it is, not a copy of its details. If a customer changes name or town, or an item its description, the group shows the new details.

How do I add a customer, an item or a document to a group or remove it?

To add one by hand, type its code in the field above the list (or look it up with the magnifying glass or with F2) and click Add to the group. That field only appears in groups of customers, suppliers, sales agents, items, families, warehouses, payment methods, price lists, carriers and ledger accounts. To remove one, click the cross on its row. Removing it from the group doesn’t touch its record.

To add or remove many at once, do it from a report of that type: narrow it and, in Selection, choose the group and click Add to the group or Remove from the group. Anything already in it isn’t repeated. In a group of documents, instalments, stock or any type without a code field, it is the only way to fill it.

Member changes are applied straight away. Save is for the name, the description and the sharing box.

What is in a segment’s record and how do I change its rule?

On the left, its name, its description, the sharing box and how many records meet the rule today. On the right, the rule, in the same steps panel as the reports: each step with its text —‘Province is equal to «Valencia»’— and with how many are left after it.

The steps are changed right there: you add a condition, turn a step off or remove it. The count above is redone with each change, but the segment doesn’t change for anyone until you click Save.

The rule allows the same as the Query of a report: conditions on details from another table (the customer’s payment method, the items on their invoices), steps that add or remove, and two conditions in the same step. A segment with a step that adds —‘those with payment method K and, in addition, all those with payment method D’— is still a rule: every time it is used it applies its steps again, in order. How each thing is set up is in getting a report.

How do I see who is in a group or meets a segment?

With View in a report. It opens the general report of its type of record —the customers one, the items one, the sales documents one…— with a single step applied: ‘is in the group…’ or ‘is in the segment…’. From there you bring it up like any report —View, Report, Data, by email— and you can keep narrowing it with more steps.

How do I combine, intersect or subtract groups and segments?

From a report of the same type of record, with the two Selection buttons: Only the ones in it keeps the ones that are in the group or segment you choose, and The ones not in it takes them out. Each adds a step to the Query, so they chain:

A group of items can only be intersected in an items report; a customers one, in a customers one. If the type doesn’t match, the step isn’t added and the message says so.

The result can in turn be saved as a group or as a segment. A segment saved this way follows both: if A changes or B changes, it changes.

A segment can’t end up asking about itself, either directly or through another one: when you save it, the program rejects it and says which condition prevents it. Nor can a segment built on a report that filters with a formula with no equivalent condition be used as a step of another one; the message explains this.

What can I do in one go with the customers, items, documents or contacts in a group or a segment?

The record of every group and every segment has the What to do with them panel. It only shows what makes sense for its type of record:

Type of recordWhat can be done
CustomersSend an email, send a WhatsApp, chase overdue invoices, tag, change a field (sales agent, price list, route or customer type), create tasks and invoice with a template
SuppliersSend an email, send a WhatsApp, tag and create tasks
CRM contactsSend an email, send a WhatsApp, tag and create tasks
ItemsTag, change a field (publish in the shop or the family) and change the price by a percentage
DocumentsInvoice the delivery notes, issue the drafts and send them by email
InstalmentsMake a batch

There are always three steps: you choose the action and fill in its details, click See who it affects and, if you agree, Do it with… (or Prepare it). See who it affects changes nothing: it says how many it would be done to, how many are left out and why (‘Already has that tag’, ‘Has no phone’, ‘Is blocked’).

If there are more than 50 records, you first have to tick the ‘…yes, I want to do it with all of them’ box. Whatever changes records or creates documents runs in the background, record by record, and you can keep working. Below, What has been done keeps every use: what was done, when, by whom, to how many and what happened with each record.

The actions that send something —the email, the reminder, the documents by email— send nothing from here: they leave the send prepared in Mailing, where it is reviewed and launched.

How do I invoice the same thing to every customer in a group or a segment with an invoicing template?

With the Invoice with a template action, in the What to do with them panel of a group or a segment of customers. You choose a template from Sales → Recurring invoicing, which acts as the mould, and the program makes one document for each customer:

The documents are left as drafts, to be reviewed, unless you choose Are issued now. Issuing is a tax event and can’t be undone. See who it affects says how many documents would come out and for what amount, and leaves out anyone who has no customer record, is blocked or is inactive.

The template doesn’t change: it still belongs to its customer, with its frequency and its next issue, and this use doesn’t count among its issues.

How do I chase the overdue invoices of the customers in a group or a segment?

With the Chase overdue invoices action, on a group or a segment of customers. For each customer it finds the invoices with a collection that is overdue and unpaid, and leaves a document send prepared in Mailing: one email per customer with their invoices as PDFs. The default subject is ‘Payment reminder: overdue invoices’; you can write another one, and chase only what has been overdue for more than a number of days.

See who it affects says how many invoices there are and how much is outstanding, and leaves out anyone who owes nothing overdue, has no email, or owes something with no invoice to send (a balance carried over from another financial year). Nothing goes out until you launch the send in Mailing, which applies its unsubscribes and its address checks.

How do I send a WhatsApp to CRM contacts or to the customers in a group?

With the Send a WhatsApp action: you choose an approved template and fill in its placeholders. A customer or a supplier is written to on the mobile in their record (or their phone, if they have no mobile); a CRM contact, on their main phone (or a mobile, if none is marked as main). The message to a contact is noted in their CRM record.

See who it affects leaves out anyone with no phone and anyone who hasn’t given permission: an advertising template needs each person’s express permission. The messages go out little by little and each one can be seen, with its status, in WhatsApp send, from What has been done.

Who sees my groups and my segments?

Only you, unless you tick Share it with the whole company. Once shared, anyone with access to this screen sees it and uses it in their reports, but only you can change it, archive it or delete it.

A shared segment is evaluated by each person with their own permissions. Anyone who can’t run the report it is built on can’t see which records the segment leaves either.

What happens if I archive or delete one?

Archiving takes it out of the lists to choose from but keeps what it has, and it can be reactivated; deleting removes it completely, without touching anyone’s record.

What happens to a group if I delete a customer, an item or a document?

A business partner that is deleted (customer, supplier or sales agent) leaves every group of customers, suppliers, sales agents and business partners it was in. If a record of another type is deleted —an item, a document—, it stops counting in the group and stops showing in its list. In a segment there is nothing to remove: the record stops meeting the rule because it no longer exists.

Who can use this screen?

Anyone with access to CRM → Groups and segments: with view access, they see them and use them in their reports; with create access, they create groups and segments, also from a report; with edit access, they change their own, add and remove members, archive them and delete them.

If something goes wrong

What you seeWhat is happening
‘There is already a group or a segment called…’The name can’t be repeated among the ones you see. Choose another.
‘… isn’t yours: only whoever created it can change it’It is shared with you. You can use it, not change it.
‘The segment … refers to itself’An ‘is in…’ condition closes a loop between segments. Remove it.
‘… is made of … and «…» isn’t: you can’t ask whether its records are in it’The group or segment is about a different type of record from the report. Open it with View in a report, or use a report of its type.
A segment’s record doesn’t show its ruleThe report it was built on no longer exists or your profile can’t run it. The notice says which of the two.
A group’s record has no field to add by codeIts type of record has no code finder. Fill it from a report, with Selection → Add to the group.
A record doesn’t appear in a group’s listIt was deleted: it stops counting and showing in the group.

More about CRM