Community: Inventory and MRP أرشيف القائمة البريدية

expert-inventory@mail.odoo.com

الصورة الرمزية

Re: SEEKING: Way to BACK DATE Stock Transfers. Selling Products on Consignment. I don't know until a month later what goods have been 'bought'??

بواسطة
Elico Corporation, Eric Caudal
- 07 أغسطس, 2017 08:58:32

Hi Ray,

What is your set up on valuation/put away strategy?

I would think FIFO/Realtime. This means that when the goods are shipped out, the valuation from the quant is taken into account.

If average, I think you have a no-go here (stock move will take into account the value at today's valuation average price.

besides that, in standard Odoo, you have no way to input a date in the past for the inventory moves (that is linked to the way Odoo calculates inventory adjustment).

You might want to have a look at some module that allows backdating in the community but do it with extreme care

--
Eric Caudal [Founder and CEO]
Skype: elico.corp. Phone: + 86 186 2136 1670 (Cell), + 86 21 6211 8017/27/37 (Office)
Elico Shanghai (Hong Kong/Shenzhen/Singapore)
Odoo Gold Partner // Best Odoo Partner APAC 2014 and 2016
On 08/08/2017 12:45 AM, Ray Carnes wrote:

Hi Experts,

How are other people handing stock transfers that happen in the real world at a different time that they can be processed in Odoo?

 

I posted this question to https://www.odoo.com/forum/help-1/question/selling-products-on-consignment-step-one-qty-moved-but-not-changed-valuation-unchanged-step-two-decrease-qty-decrease-valuation-122490

I want some help with stock transfers in Odoo that need to be BACK DATED.

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 (like an 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 (like a 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 some in September and not send me the usage report until October.   At this point, they still have items to consume in October or November.

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 they 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 

 

How are other people handing stock transfers that happen in the real world at a different time that they can be processed in Odoo?

 

 

http://www.bistasolutions.com/images/Sign_Image/Bista-Solutions-logo-for-Email-sig.png

RAY CARNES

Senior Odoo Consultant


?

Greater Los Angeles, UNITED STATES.

?

909.864.4576

?

bista_ray

?

www.bistasolutions.com

USA |

Canada |

UAE |

India

?

?

?

?


The information in this email (including any accompanying document) is 
intended only for the recipient and any distribution of the same is prohibited.

 

 


المرجع