How to Set Up Consignment Operations in Odoo 18 | Odoo 18 Functional Tutorials |Odoo 18 New Features – CBMS Odoo ERP

How to Set Up Consignment Operations in Odoo 18 | Odoo 18 Functional Tutorials |Odoo 18 New Features – CBMS Odoo ERP

In Odoo, handling consignment (buying and selling stock without owning it) involves specific configurations to manage inventory and financial transactions effectively. Below are the steps to set up consignment operations in Odoo:

1. Set Up Consignment Locations
Consignment stock typically requires separate inventory locations.

Create Vendor Location:

Go to Inventory → Configuration → Locations.
Create a new location for the consignment stock (e.g., Vendor Consignment).
Set the location type to Vendor Location.
Create Customer Location:

Create another location for consignment stock for customers (e.g., Customer Consignment).
Set the location type to Customer Location.
2. Manage Incoming Consignment Stock (Vendor Stock)
Consignment stock remains owned by the vendor until it is sold. You need to manage stock transactions without affecting your financial accounts.
Steps:
Create a Purchase Order:

Create a purchase order but don’t validate the invoice.
Add the consignment products with their quantities.
Receive Products into Vendor Location:

When receiving the products, ensure the stock is recorded in the Vendor Consignment location.
The system records the products but does not create a financial liability until the products are sold.
3. Sell Consignment Stock
When selling consignment stock, you need to account for the transfer of ownership and record the liability to the vendor.

Steps:
Create a Sales Order:

Create a sales order for the customer and confirm it.
Deliver the products from the Vendor Consignment location.
Record Vendor Liability:

For every product sold, generate a vendor bill to account for the cost of goods sold (COGS).
Match the quantity sold with the quantity billed to the vendor.
4. Return Unsold Consignment Stock
If unsold stock needs to be returned to the vendor:

Create a Return Picking:

Navigate to Inventory → Operations → Transfers.
Select the consignment receipt and create a return for the required products.
Process the Return:

Move the products back to the vendor from the Vendor Consignment location.
5. Configure Accounting for Consignment
To ensure proper financial tracking:

Link the consignment stock locations to specific stock valuation accounts.
Define custom journal entries to record the movement of consignment stock and COGS.
6. Reports and Reconciliation
Use the Inventory Valuation Report to monitor consignment stock levels.
Reconcile vendor invoices with consignment sales to ensure accurate payment records.

#Odoo18 #ConsignmentOperations #OdooTutorial #Odoo18Features #Odoo18NewFeatures #InventoryManagement #OdooERP #Odoo18Guide #BusinessAutomation #ERPSoftware #Odoo #OdooTutorials #StockManagement #OdooForBusiness #ERPSystems #Odoo18Release #Odoo18Tutorial #Consignment #Odoo18InventoryManagement #SupplyChain #ERP #Odoo18ERP #BusinessSoftware #Odoo18Tips #Odoo18Training #LearnOdoo18 #Odoo18Implementation #ConsignmentInventory #Odoo18NewFeatures

Connect With Us:
—————————————
➡️ Website:
➡️ Email: info@mycbms.com
➡️ Twitter:
➡️ LinkedIn:
➡️ Facebook:
➡️ Instagram:
➡️ Pinterest:

#Set #Consignment #Operations #Odoo #Odoo #Functional #Tutorials #Odoo #Features

Similar Posts

2 Comments on How to Set Up Consignment Operations in Odoo 18 | Odoo 18 Functional Tutorials |Odoo 18 New Features – CBMS Odoo ERP

  1. avatar
    @abdullah_alomran says:

    What about the wholesale price in the consignment flow?
    Right now, you only show how to transfer the items to the vendor, but you didn’t clarify how they will know the wholesale cost after selling the products. For example, if we send 50 pcs, how will the vendor enter them in their system? And how can their system calculate the profit if they don’t have both the retail and wholesale prices?

    Let me explain with an example:
    • T-shirts: 10 pcs – wholesale $10 / retail $15
    • Shorts: 5 pcs – wholesale $6 / retail $10
    • Shoes: 5 pcs – wholesale $15 / retail $25

    When the vendor sells all items, their profit should be:
    • T-shirts → $5 × 10 = $50
    • Shorts → $4 × 5 = $20
    • Shoes → $10 × 5 = $50
    Total = $120 profit

    On my side, I also need to calculate my profit:
    • T-shirts cost $7 → sold on consignment $10 → $3 × 10 = $30
    • Shorts cost $4 → sold on consignment $6 → $2 × 5 = $10
    • Shoes cost $10 → sold on consignment $15 → $5 × 5 = $25
    Total = $65 profit

    So, in the real consignment flow, both sides (vendor and owner) need to see all this information clearly in the system.

    And please, don’t suggest that I open each product manually, check its cost, calculate the percentage profit, and then write it on paper. This is not practical, specially if i will give them more than 30 or 40 different items.

    That’s why we need Odoo to handle the full flow of consignment with wholesale + retail prices, so the system can show the correct profit automatically for both sides.

Comments are closed.