Consignment Settlement & COGS | Invoice-to-Bill Matching
by Odoo DevHouse https://apps.odoo.com/apps/modules/browse?author=Odoo%20DevHouse$ 150.12
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Discuss (mail)
• Invoicing (account) • Inventory (stock) |
| Lines of code | 482 |
| Technical Name |
dh_consignment_settlement_cogs |
| License | OPL-1 |
| Website | https://apps.odoo.com/apps/modules/browse?author=Odoo%20DevHouse |
| Versions | 18.0 19.0 |
Consignment Settlement & COGS
Track every consigned outbound line-by-line. Match customer invoices to vendor settlement bills automatically - with live Pending / Settled status and full COGS visibility.
consigned stock
delivered
posted
SURFACE
bill posted
The Gap: Odoo correctly excludes consigned stock from COGS at invoice time (the vendor-owned portion has zero cost). But there is no native link between the customer invoice lines (consigned outbounds) and the vendor's eventual settlement bill. Accountants must manually cross-reference each consigned quantity with the matching vendor bill line - an error-prone, time-consuming process with no status tracking.
In standard Odoo 18, the consignment cycle is split across two independent accounting events - the customer invoice and the vendor settlement bill - with no native surface to link them. Accounting teams face:
- Manual cross-referencing of every consigned invoice line against vendor bills - no automated linking
- No settlement status - impossible to know at a glance which consigned outbounds have been matched to a vendor bill
- No visibility into pending consignments - unmatched lines can stay open indefinitely without detection
- Credit note complexity - partial returns create proportional reversals that are impossible to track without a ledger
- Audit gaps - no traceability from consigned outbound quantity to the vendor bill line that covers its cost
- COGS reconciliation risk - consignment cost recognition depends on finding the right vendor bill manually, leading to timing mismatches
This module introduces a Consignment Settlement Ledger - automatically populated when a customer invoice is posted. Each consigned outbound becomes a ledger row (one per invoice line à consigning vendor) that accounting can assign to the matching vendor bill. Status transitions from Pending -> Settled as bills are matched. Credit notes and partial returns are handled with proportional reverse rows. Zero configuration required - the module is silent on invoices with no consigned stock.
- Auto-Generated Settlement Ledger: One ledger row per (invoice line à consigning vendor) created automatically on invoice posting
- Pending / Settled Status: Each row tracks its own status - Pending until a posted vendor bill is assigned, then Settled
- Invoice Notebook Tab: "Consignment Lines" tab on every customer invoice shows its settlement rows at a glance
- Vendor Bill Auto-Fill: Selecting the vendor bill on a row auto-fills the product cost from the first matching bill line
- Invoice-Level Pending Flag: "Consignment Pending" field on the invoice (stored, searchable) - turns off when all rows are settled
- Vendor Bill Settled Lines Tab: Vendor bills show which settlement rows they cover in a "Settled Consignment Lines" tab
- Credit Note Support: Returns auto-create proportional negative rows linked back to the original invoice's ledger rows
- Powerful Filters: Filter settlement ledger by vendor, pending status, settled status, sale order, invoice, or product
- Invoice List Decoration: Customer invoice list highlights rows with pending consignment settlements in amber
- Multi-Company & Multi-Currency: Currency and company inherited from the source invoice
- No Configuration Required: Zero setup - activates on installation, silent when no consigned stock is present
- Native Groups Reused: No new security groups - uses standard Odoo Accounting access levels
Receive Vendor-Consigned Stock
Use the standard Odoo consignment flow: set the Owner field on the incoming stock receipt to the vendor's partner. This marks those stock move lines as vendor-owned. No module configuration needed at this step.
Sell and Deliver to Your Customer
Create and confirm a Sales Order. Validate the delivery picking. The consigned outbound move lines carry the vendor owner, which the module uses later to identify consigned portions. Mixed deliveries (own + consigned stock) are fully supported.
Post the Customer Invoice - Ledger Rows Created Automatically
When you click Confirm on the customer invoice, the module hooks into the posting event. For every invoice line that shipped consigned stock, it creates one Consignment Settlement Line per consigning vendor, recording the outbound quantity in the invoice line's UoM. A "Consignment Lines" tab appears on the invoice form showing all settlement rows. The invoice is flagged as "Consignment Pending".
Open the Consignment Settlement Ledger
Navigate to Accounting -> Customers -> Consignment Settlement. The ledger opens pre-filtered to Pending rows. Use the search bar to filter by vendor, product, invoice, or sale order. Each row shows the consigned quantity, the originating customer invoice, and its settlement status.
Assign the Vendor Settlement Bill
When the vendor sends the settlement bill, create the vendor bill through the standard Odoo vendor bill flow and post it. Then open the relevant ledger rows and set the Vendor Bill field. The Product Cost auto-fills from the first matching product line on the bill. Each matched row turns green (Settled). Once all rows on an invoice are settled, its Consignment Pending flag clears automatically.
Handle Returns via Credit Notes
If the customer returns goods, post a credit note. The module automatically creates proportional reverse rows in the ledger, linked back to the original invoice's rows via "Reverses" traceability. Partial returns produce proportionally scaled negative quantities. Match these reverse rows to a vendor credit note when it arrives.
| Status | Condition | Appearance in List |
|---|---|---|
| Draft | Invoice is in Draft state | Default |
| Pending | Invoice posted, no vendor bill assigned (or bill not posted) | Amber warning |
| Settled | Posted vendor bill is assigned to this row | Green success |
| Cancelled | Source customer invoice was cancelled | Muted / greyed out |
Step 1 - Incoming Receipt with Consignment Owner Set
On the incoming stock receipt, set the Owner field to the consigning vendor partner.
Step 2 - Customer Invoice Posted -> Consignment Lines Tab Appears
After posting the customer invoice, a "Consignment Lines" tab appears automatically. It lists one settlement row per (invoice line à consigning vendor) with quantity, owner, and current status. The invoice is flagged Consignment Pending.
Step 3 - Consignment Settlement Ledger (Pending Filter Active)
Navigate to Accounting -> Customers -> Consignment Settlement. The ledger opens pre-filtered to Pending rows - highlighted in amber. Filter by vendor, product, sale order, or invoice to find the rows you need to match.
Step 4 - Settlement Line Form: Assign the Vendor Bill
Open a pending settlement row. Set the Vendor Bill field to the vendor's posted settlement bill. The Product Cost field auto-fills from the first matching product line on the bill. The cost can still be edited manually if needed.
Step 5 - Settlement Ledger: Row Turns Green (Settled)
After assigning a posted vendor bill, the settlement row immediately transitions to Settled status and appears green in the list. Once all rows for a customer invoice are settled, the invoice's "Consignment Pending" flag is automatically cleared.
Step 6 - Vendor Bill: Settled Consignment Lines Tab
Open the vendor settlement bill. A "Settled Consignment Lines" tab appears showing all settlement rows matched to this bill - product, quantity, originating customer invoice, and cost subtotal. Full visibility from the vendor side.
Step 7 - Customer Invoice List: Pending Rows Highlighted
In the customer invoice list view, invoices with unsettled consignment lines are highlighted in amber. The optional "Consignment Pending" column can be added via the column customizer for quick at-a-glance status.
Vendor Consignment Programs
Distributors and retailers operating vendor-consignment programs can track every consigned unit sold and ensure every vendor settlement bill is accounted for.
Mixed Stock Invoicing
Businesses selling a mix of own inventory and vendor-consigned goods on the same invoice - the ledger isolates the consigned portion for settlement tracking.
Accounting Audit Trails
Accounting teams that need a clean, auditable record linking consigned outbounds to the exact vendor bill line that covers the cost.
Consignment Returns
Businesses with frequent customer returns - proportional reverse ledger rows are automatically created on credit notes, with traceability back to the original rows.
Period-End Consignment Reviews
Finance teams performing period-end close can use the settlement ledger to identify all pending consignment obligations before closing the books.
Multi-Currency Consignment
International companies using consignment with foreign vendors - currency is inherited from the source invoice for consistent multi-currency settlement tracking.
Installation & Configuration
- Prerequisites: Requires
mail,stock_account, andsale_stock- all standard Odoo modules (Community or Enterprise) - Install: Copy the module to your addons path and install via Apps -> Update App List -> Search "Consignment Settlement"
- No configuration needed: The module activates on installation. No new accounts, no new groups, no rules to configure
- Set up consignment flow: Ensure your incoming receipts set the Owner field to the consigning vendor partner (standard Odoo consignment)
- Test: Post a customer invoice that includes delivery from consigned stock -> check that the "Consignment Lines" tab appears on the invoice
- Assign bills: Go to Accounting -> Customers -> Consignment Settlement, filter to Pending, and assign vendor bills as they arrive
Note: The module is fully silent on invoices with no consigned stock. Installing it does not affect any existing invoices or workflows - it only activates on new postings that involve vendor-owned stock (owner on move lines).
Why does the "Consignment Lines" tab not appear on my invoice?
- The invoice must be Posted (not Draft) - the ledger rows are created at posting time.
- At least one invoice line must have underlying stock move lines with an owner (consigned stock) in the delivered picking.
- The owner must be set on the move lines (not just the picking header) - check the detailed operations on the delivery.
- The delivery direction must be to a Customer location - internal transfers are excluded.
Does this module change the COGS accounting entries on my invoices?
No. This module does not touch any journal entries. Odoo's native stock_account already handles consignment COGS correctly - consigned stock is excluded from the COGS entry at delivery time. This module only adds the settlement ledger so accounting can match consigned outbounds to vendor bills. No accounts are created or modified.
Can one invoice have lines from multiple consigning vendors?
Yes. The module creates one settlement row per (invoice line à consigning vendor combination). If a single invoice has lines delivered from two different consignment owners, you get two rows - one per owner - which can be matched to separate vendor bills independently.
What happens when I post a credit note for a consignment invoice?
The module automatically creates proportional negative-quantity settlement rows on the credit note, linked back to the original invoice's rows via the "Reverses" field. For a full refund, the reverse quantity matches the original. For partial refunds, the quantity is scaled proportionally by the refund ratio. Return stock pickings are not consulted - the original invoice ledger is used directly, because owne is not reliably preserved on return move lines.
Can I split one settlement row across multiple vendor bills?
Not directly - each row holds one bill reference. If a vendor splits their settlement across multiple bills, you can edit the quantity on the ledger row to create a partial match, or use the bill assignment as an approximation. A full wizard for multi-bill splitting is outside the current scope.
Does it work with Anglo-Saxon and Continental accounting?
Yes. The module does not generate any journal entries of its own, so it is agnostic to the accounting method. It works alongside both Anglo-Saxon (COGS at delivery) and Continental (COGS at invoice) setups.
Does it support multi-company environments?
Yes. The company on each settlement row is inherited from the source invoice. The settlement ledger is company-scoped. A multi-company column is optionally visible for users with the multi-company group.
Does installing this module affect existing invoices?
No. Ledger rows are only created at invoice posting time. Installing the module does not retroactively create rows for existing posted invoices. Only new invoices confirmed after installation will trigger ledger row creation.
Full Consignment Visibility
Know at any moment which consigned outbounds are still pending settlement - across all customers, vendors, and invoices. No more spreadsheets or manual tracking.
Faster Period-End Close
Filter the settlement ledger to Pending before period close to ensure no consignment obligations are missed. Dramatically reduces accounting review time.
Reduced Reconciliation Risk
Auto-filled product cost from the vendor bill eliminates manual data entry errors. Status tracking prevents consignment costs from slipping through without recognition.
Complete Audit Trail
Every consigned outbound is traceable from the customer invoice line -> settlement row -> vendor bill -> chatter history. Full visibility for auditors and finance managers.
Need Help or Have a Feature Request?
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Discuss (mail)
• Invoicing (account) • Inventory (stock) |
| Lines of code | 482 |
| Technical Name |
dh_consignment_settlement_cogs |
| License | OPL-1 |
| Website | https://apps.odoo.com/apps/modules/browse?author=Odoo%20DevHouse |
Odoo Proprietary License v1.0 This software and associated files (the "Software") may only be used (executed, modified, executed after modifications) if you have purchased a valid license from the authors, typically via Odoo Apps, or if you have received a written agreement from the authors of the Software (see the COPYRIGHT file). You may develop Odoo modules that use the Software as a library (typically by depending on it, importing it and using its resources), but without copying any source code or material from the Software. You may distribute those modules under the license of your choice, provided that this license is compatible with the terms of the Odoo Proprietary License (For example: LGPL, MIT, or proprietary licenses similar to this one). It is forbidden to publish, distribute, sublicense, or sell copies of the Software or modified copies of the Software. The above copyright notice and this permission notice must be included in all copies or substantial portions of the Software. THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
Please log in to comment on this module