Consignment sales

Consignor and commission

The consignor is a vendor third party. The module adds:

• on each product, a “Consignor (consignment)” field: the third party who owns it. Left empty, the product is a regular one and the module ignores it;
• on the product and on the third party, a “Consignment commission (%)” field.

The rate applied is the product’s if set, otherwise the consignor’s, otherwise the module’s default rate. The commission is computed on sales excluding or including tax, as you choose.

Sales to settle

Sales are read from your validated customer invoices, TakePOS receipts included.

• Credit notes and negative lines are deducted, in quantity, amount and commission.
• Draft invoices, replaced invoices and down payments are ignored.

ProductsConsignment sales, “Sales to settle” tab: for each consignor, the number of lines, quantity sold, sales excluding and including tax, the commission and the amount due to the consignor (excl. tax), up to the chosen date, with a total.

The statement

The “Create the statement” button takes all of the consignor’s sales not yet settled up to that date, including an older invoice validated late. The statement gets a DVyymm-NNNN reference and creates, as drafts:

• in “two invoices” mode (the default): the consignor’s supplier invoice, one line per product, and your commission invoice addressed to the consignor;
• in “one invoice” mode: the consignor’s supplier invoice for their sales minus the commission.

Nothing is validated automatically: you check the invoices, then validate them.

The statement card details each sale — date, invoice, product, quantity, amounts, rate, commission — and gives the amount due to the consignor. It can be printed. While its invoices are drafts, the statement can be deleted: its invoices are deleted with it and its sales become to settle again.

On the consignor’s card, the “Consignment” tab shows their products (selling price, stock, rate), their sales to settle as of today and their statements.

A sale is settled only once

Each invoice line sold is recorded with the statement that settles it. A unique key in the database forbids recording it a second time, even when two statements are created at the same time. An older invoice validated after a statement is not lost: the next statement picks it up.

VAT

Invoices are created with the VAT Dolibarr suggests: product rate, consignor subject to VAT or not. A consignor not subject to VAT gets a supplier invoice without VAT. The commission invoice has a single line, at the rate Dolibarr suggests by default for your company.

The VAT treatment of consignment (agency, commission, second-hand goods) depends on your business and your contract: check with your accountant before validating the invoices.

Your company’s country must be set: without it, Dolibarr suggests no VAT, and the module’s page says so.

ProductsDépôt-vente (Consignment sales), “Ventes à régler” (Sales to settle) tab, up to 12/10/2026, in a fictitious farm shop: three consignors, each with lines, quantity sold, sales excluding and including tax, the commission and the amount due, and an “Établir le relevé” (Create the statement) button. Under the table, a reminder of the “two invoices” mode.

Statement card DV2610-0001 for Ferme du Bois Joli, on Dolibarr 24.0.1: period from 17/09 to 12/10/2026, “two invoices” mode, supplier invoice and commission invoice as drafts. The detail has five lines, including a credit note (quantity −1) deducted with its commission. Due to the consignor: €171.38 excl. VAT.

The module’s setup page is reserved for administrators. It recalls the four set-up steps and how VAT is handled.

• Two dedicated permissions, not granted by default: “See consignment sales” opens the menu, the tab and the statements; “Create and delete consignment statements” shows the buttons.
• Dolibarr permissions on top: creating a statement also requires the permission to create supplier invoices and, in “two invoices” mode, to create customer invoices. A request sent without these permissions is refused by the server.
• The consignor’s tab only opens on a third party the user has access to.
• Sales representatives limited to their consignors: without Dolibarr’s permission to see all third parties, a user only sees, creates and deletes the statements of the consignors they are the assigned sales representative of, as in Dolibarr’s lists; a forged request is refused.
• Transactions: a statement is created in a single transaction; if a step fails, nothing is recorded.
• Controlled deletion: confirmation is asked, and deletion is refused if an invoice of the statement is already validated.
• Forms carry Dolibarr’s anti-CSRF token; the setup page enforces it.

The dolixdepotvente folder, in readable PHP, under the GPL v3 or later licence: the module descriptor, the sales-to-settle and statements page, the statement card, the consignor’s tab, the setup page, the calculation class, the SQL files of the two tables and the icons.

• Languages: French (fr_FR), English (en_US) and German (de_DE).
• A README.md (in French) describing how it works, VAT, settings and limits.
• A ChangeLog.md.

• Two tables are added: llx_dolixdv_releve, one row per statement (reference, consignor, period, mode, totals, commission, invoices created, author, date), and llx_dolixdv_line, one row per settled sale, with a unique key on the invoice line.
• Three extra fields: “Consignor (consignment)” and “Consignment commission (%)” on products, “Consignment commission (%)” on third parties.
• What a statement writes: one row in llx_dolixdv_releve, one row per settled sale in llx_dolixdv_line, and the draft invoices, created by the core classes. The customer invoices sold are not modified.
• Three settings, stored as Dolibarr constants: DOLIXDV_DEFAULT_COMMISSION, DOLIXDV_COMMISSION_BASE and DOLIXDV_MODE.
• No Dolibarr file is modified. No outgoing connection.
• When disabled, the menu and the tab disappear. Invoices created remain: they are ordinary Dolibarr invoices. The two tables, the fields with their values and the settings are not deleted.