Odoo Help


This community 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.


manage sales order and stock for Consignment

on 8/29/13, 11:17 AM 3,275 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

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

1 follower(s)


Asked: 8/29/13, 11:17 AM
Seen: 3275 times
Last updated: 3/16/15, 8:10 AM