This question has been flagged
4 Replies
10086 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.

Avatar
Discard
Best Answer

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
Avatar
Discard
Author

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.

Author

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 .

Best Answer

Hi maybe this module helps: 

https://apps.odoo.com/apps/modules/11.0/td_consignment_stock/

Avatar
Discard