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?
- Go to Invoicing and find the documents with the list filters.
- 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.
- Click Convert in the action bar. The Bulk conversion window opens.
- In Convert to, choose the type of document you want to create.
- 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.
- Choose the Grouping.
- 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.
- 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.
- 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:
- One target per source document: delivering forty sales orders makes forty delivery notes.
- One target per customer: the documents of the same customer are combined into a single one.
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.
- Quote, sales order, work order and delivery note are left issued. They have already taken off the pending quantity from their source and, if they move stock, they have already moved it.
- Invoice and credit note are left as a draft document. They don’t yet have a tax number and haven’t taken anything off.
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 see | What has happened | What to do |
|---|---|---|
| ‘— no common target —’ | The ticked documents don’t share any target | Untick the ones you don’t need and do it in two batches |
| I can’t tick a document | It is a draft, voided or its type doesn’t convert into anything | A 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 out | Empty 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 fit | It is a normal discard: that document is converted separately |
| The invoices come out without a final number | That is expected: they start as drafts | Tick them in the list and use Issue |
| ‘Series … does not exist for …’ | The series typed hasn’t been set up for that type | Choose 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
- How do I delete a document?
- How do I make the consignment note for a shipment?
- How do I charge shipping or expenses without VAT?
- Setting up numbering series
- Why is my invoice one cent out and how do I fix it?
- How do I turn a quote into a sales order, a delivery note or an invoice?
- Can I leave a document half-done and go to another screen?
- How do I issue an invoice?
- How do I deliver a sales order in several deliveries?
- How do I invoice a fee that repeats every month?
- How do I invoice several delivery notes at once?
- Pro forma invoices