openerp-india team mailing list archive

[Régis C. <427733@xxxxxxxxxxxxxxxxxx>]

Hello,

The problem is “I want to keep a small security stock, but the scheduler tells me to buy now the units of all future sale orders of the year”. MTS is unusable because of this behavior.
It seems that OpenERP bases its MRP computation on a wrong virtual stock value. I explain :

The virtual stock changes over the time and we can compute its value for each day (see Stock Level Forecast report). An order point must be triggered on date D according to the virtual stock of date D (e.g. computed with the stock moves where date_expected <= D).
Currently, OpenERP’s scheduler seems to use only the virtual stock on "infinite" date (e.g. no limit in stock moves selection) like displayed in product form, thus all the future requirements are fulfilled at once !

Using MRP “standard” vocabulary, Virtual Stock or Projected Available should be computed like this:
Projected_avaible(D)=real_stock + scheduled_receipt + planned_order_receipt – gross requirement

Scheduled_receipt : stock moves [Supplier=>Stock] where date_expected <= D and state not in [‘done’, ‘cancel’]
Planned_order_receipt : stock moves [Procurement=>Stock] where date_expected <= D and state not in [‘done’, ‘cancel’]
Gross requirement : stock moves [Stock=>Client] where state = ‘assigned’ or (date_expected <= D and state = ‘confirmed’)

Olivier Dony wrote : "Imagine you create 3 different SO for a MTS product with 0 stock, with different planned dates? Do you want the system to create 3 different PO's for the same product to the same supplier with different dates?"
Yes I do, especially if there is a huge delay between SO planned dates. I want to purchase WHEN the min stock rule matches (- supplier lead time of course).

Do you agree ?

Régis

-- 
You received this bug notification because you are a member of OpenERP
Indian Team, which is subscribed to OpenERP Addons.
https://bugs.launchpad.net/bugs/427733

Title:
  error with planed date on purchase order for product MTS

Status in OpenERP Addons (modules):
  Confirmed

Bug description:
  Hi,

  There is a problem with generated planed date on purchase order when a
  manufacturing order want a product "make to stock" with 0 in stock.

  (0 security days for this exemple)

  When I sale today (september 11) a velo with delivery in 30 days to
  customer (oktober 11), 3 days for manufacturing and I have 0
  handelbars (MTS) in stock, this handelbar have 5 days from supplier to
  me, OpenERP should generate a purchase order for this handelbar for
  planed date 30-3 days = in 27 days (oktober 8), but the system
  generates a planed date for today-5 days = there 5 days (september 6)
  -> in the past !!!

  It unusable for calculating supply in a production !!

  - version 5.0.3 with JIT module -

To manage notifications about this bug go to:
https://bugs.launchpad.net/openobject-addons/+bug/427733/+subscriptions