OFBiz - Re: Dev - [OFBiz] Users - requirements

May 05, 2006; 11:01pm

I've moved this thread to the dev list because I'd like to discuss some 
design decision about the auto requirement creation.

I've reviewed the mods Si did to the checkCreateStockRequirement (i.e. 
the service that creates the requirements testing QOH inventory) in rev. 
5409 and there is one thing that I don't think is correct:
when the inventory is issued and the qoh is already under the minimum 
quantity, a research for existing requirements (in "created" status) has 
been added to update their required qty to reflect the new issuance; I 
think this is wrong because we cannot know if a requirement has already 
been approved and maybe already transformed into a purchase order (still 
not received).
The original idea of that service was based on a simple assumption: the 
minimum levels and the reorder quantity in the ProductFacility are 
properly set to maintain the stock levels sufficient to fulfill a 
'normal' number of sales.
For this reason the requirement, for the reorder qty, should be created 
only when the qoh reaches the minimum level: the remaining stock will be 
sufficient to fulfill all the incoming orders before the new purchase 
order (generated from the requirement) is received.

This is a simple strategy but it works for many simple companies; if we 
need an advanced requirement strategy (that takes into account every 
sales order, purchase order, manufacturing order and requirements in the 
system) we should use the MRP instead of the simple requirement creation 
algorithms.

So I propose to reintegrate some of the logic in rev. 5202 in the 
checkCreateStockRequirement service.

What do you think of this? Si, what do you think?

After this is done, I'll create a new service that does the same but 
looking at the ATP levels instead.

Jacopo

Scott Gray wrote:

Re: Dev - [OFBiz] Users - requirements - atp reaches minimum stock