Skip to content

How do I convert several documents at once?

From the Invoicing list you can tick several issued documents and convert them all at once: deliver forty sales orders, turn accepted quotes into sales orders, invoice a whole month. It is called Bulk conversion.

What do I need before I start?

You need documents that are issued and have something pending. A draft document isn’t converted, and neither is one that has been fully used up.

All the documents you tick have to be able to be converted into the same type. A sales order and a delivery note share a target —the invoice—, so they can be ticked together. A sales order and an invoice don’t share any, and then the window doesn’t offer any target.

Each document needs a customer. One without a customer isn’t included in a bulk conversion.

How do I do it?

  1. Go to Invoicing and find the documents with the list filters.
  2. Tick the box of each document you want to convert. You can only tick what allows conversion; the box tells you what can be done with that row.
  3. Click Convert in the action bar. The Bulk conversion window opens.
  4. In Convert to, choose the type of document you want to create.
  5. If you want, enter the Series for the new documents. Leave it empty so that each one comes out in the series of its source.
  6. Choose the Grouping.
  7. If you want, narrow it down with Customer, Date from / Date to and From no. / To no.. Whatever falls outside those ranges simply isn’t converted.
  8. Click Preview. You will see the list of documents that are going to be created, with their series, their sources, their lines and their amount. Nothing is created yet.
  9. Click Convert. When it finishes, the result appears, and you can download it with Export CSV.

Which series do the new documents come out in?

In the one you enter in Series. It is a code with a magnifying glass and F2: it offers the series of the type you are going to create, with their next number. If you change Convert to, the series is emptied, because each type has its own.

With Series empty, each new document comes out in the series of its source. So a sales order in series ‘B’ can be invoiced in ‘A’ by choosing it here. If your company has Invoice series when bringing in an order or delivery note set to The invoice’s default series (in Settings → Sales and documents → Codes), invoices with an empty Series go instead to the default invoice series; delivery notes follow the one of the source.

A series that doesn’t exist isn’t created: the program warns you and converts nothing. If the chosen series has Show with VAT ticked, the new documents come out with prices including VAT, without changing the total.

If your company has Invoice each series separately ticked (in Settings → Sales and documents → Codes), invoices always follow the series of their source and don’t combine sources from different series. That only applies to invoices: a delivery note does combine sales orders from different series.

What does each grouping mean?

The Grouping decides how many new documents are created:

When several sources are combined in one document, the lines are never merged. Each source comes down under its own heading, with its number and its date. That way you always know where each line came from.

The currency always splits the group: two documents from the same customer in different currencies aren’t combined.

What state are the new documents left in?

It depends on the type you have created, and it is worth knowing before converting forty things.

If you have converted to invoices, the next step is to tick them in the list and use Issue selected. Until then, their sources still count as pending.

What happens with the documents that can’t be converted?

They are discarded with their reason and don’t drag the others down with them. They appear in the result with the explanation for each one: ‘is already fully consumed’, ‘it is cancelled’, ‘is still a draft’, ‘has nothing pending conversion’, ‘belongs to another customer’.

Each new document is created separately. If thirty-seven out of forty go through and three fail, the thirty-seven stay done and the result says what happened with the others.

The process goes one by one, not all at once. With many documents it takes a while, and that is why there is a progress bar. Don’t close the window while it is working.

What if I want to convert only part of a document?

Bulk conversion takes **all the pending quantity** of each source. There is no way to say here ‘from this sales order deliver only 40 of 100’.

For a partial delivery you have to do it document by document, from the editor: it is explained in I deliver a sales order in several deliveries.

If something goes wrong

What you seeWhat has happenedWhat to do
‘— no common target —’The ticked documents don’t share any targetUntick the ones you don’t need and do it in two batches
I can’t tick a documentIt is a draft, voided or its type doesn’t convert into anythingA draft is edited directly; an invoice only goes to a credit note
‘No documents fall within the given ranges.’The date, customer or number ranges leave everything outEmpty the ranges and Preview again
‘The … belongs to another customer: it cannot be mixed’With grouping by customer there is a source that doesn’t fitIt is a normal discard: that document is converted separately
The invoices come out without a final numberThat is expected: they start as draftsTick them in the list and use Issue
‘Series … does not exist for …’The series typed hasn’t been set up for that typeChoose it with the magnifying glass, or create it in Document series

Previous: Invoice several delivery notes at once · Next: Invoice a fee that repeats · Next: From quote to invoice

More about Invoicing