Odoo Help


manage sales order and stock for Consignment

on 8/29/13, 11:17 AM 4,692 views

Our retail business handle both outright and consignment stock. We have one warehouse and 1 shop.

What is the right way to setup OpenERP operation for this situation ?

2 different location node for two type of stock is not possible.

We need to generate report of stock value on each stock type. Also we need to generate payment to suppliers base on sold item per month.

Thank you.

Yohanes Iwan Sugiarto
On 8/29/13, 10:24 PM

It's more a matter of accounting and how we design the Chart of Account. Received consigned goods doesn't have any effect on company's accounting record.

But since OpenERP writes journal everytime we receive goods (which in my opinion is a good thing), we have to design the account so that the journal doesn't affect company's Profit/Loss nor Balance Sheet.

e.g: Put the Stock Valuation Account outside company's account structure. This can be set per product item, or better: to the product category.

Tracking the stock value of the consigned goods will be very easy too, because we already made a separate account for the stock valuation account.

Now when it comes to selling, we also need to design a different Sales journal, since consignment sales are usually commission based transaction.

Separate these account from the regular sales journal accounts:

  • Stock input account
  • Stock output account
  • Stock valuation account
  • Income account
  • Expense account

The difficult is per item,it may have different purchase model : consigned or out right. Knowing which stock item is belong to which purchase model is useful to: monitor stock value for your out right, how long your money have stayed in the warehouse.

on 9/12/13, 2:14 PM

My plan resolve this matter is : * extent the purchase order to record purchase model (consigned / outright). * upon reception of the stock to warehouse, stock move traceability is attributed with consigned/ outright .

on 9/12/13, 2:25 PM

About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

1 follower(s)


Asked: 8/29/13, 11:17 AM
Seen: 4692 times
Last updated: 2/2/18, 8:40 AM