Help

2

Selling Products on Consignment. Step One - qty moved but not changed, valuation unchanged. Step Two - decrease qty, decrease valuation.

Avatar
Ray Carnes

I want to have this happen in Odoo v9.

1. Customer places order.

  • Customer pays nothing - they are just asking for items they MAY buy from me.  They will report and pay later what they 'buy'.

2. In Odoo, we process a Stock Transfer (Internal Transfer).

  • Items are moved from MY Warehouse to a CUSTOMER Warehouse (Consignment Location).  

  • Since I still own the items, there are is no Accounting Impact (or just freight is added to my Inventory Asset). The value of MY Inventory is unchanged (or increased slightly if I roll the freight cost back in).

  • Since I still own the items, but they have moved, there is a QTY Impact. The QTY on HAND at MY Warehouse decreases, the QTY on HAND at CUSTOMER Warehouse increases..  

3. Customer reports usage.

  • This represents the quantity of items they have consumed - and they need to pay me for these items.

4. In Odoo, we process a Stock Transfer (Delivery Order - move from WH to CUST) for the reported usage.

  • Items are moved from CUSTOMER Warehouse (Consignment Location) to CUSTOMER Location (just like a normal Delivery Order).

  • Since I no longer own the items, there is an Accounting Impact.  The value of MY Inventory decreases. 

  • Since I no longer own the items, there is a QTY Impact. The QTY on HAND at the Consignment Location decreases, the QTY on HAND at CUSTOMER Location increases.


This process has to work over different months.  They may place the order in August, consume some in August and the rest in September and not send me the usage report until October. 

I need a way to process (4) and enter the 'date effective'.  For example, I may get a report in October telling me 40% were consumed in August and 50% were consumed in September.  When I enter this October 8th, Odoo would need to change the asset value of my Inventory in August AND September (even though I validate the Stock Transfers in September).


Back when I was using OpenERP v6, I had a Customer who wanted to receive Incoming Shipments on Monday, even though they were processed 'in the real world' on Friday - so wanted to change the date of the Shipment BACK to Friday and have Odoo back date the stock move.

Odoo provided the patch discussed at https://answers.launchpad.net/openobject-addons/+question/208808 

Avatar
Discard