[OFBiz] Users - generating minimum stock requirements

[Si Chen]

Hi Jacopo,

I am now wondering if my original idea was good.  Which do you think is 
better -
1.  Keep adding to one requirement for the product and facility 
combination - or
2.  Create a separate requirement for each item issuance or order item, 
so we can trace back to the original order?  That way, we can trace from 
a purchase order back to the original sales order or item issuance.

What was your original idea behind the requirements?  If we implement 
(1), how do we make it so that we can relate the original order item or 
item issuance to the requirement and thru to purchase orders?

Thanks!

Si

Jacopo Cappellato wrote:

> Si,
>
> these are all good points.
> It's true, I'm not considering pending requirements (i.e. requirements 
> in the CREATED or APPROVED status) in the checkCreateStockRequirement 
> service.
> I made the assumption that the reorder quantity (and the lead times) 
> is properly set to cope with the average number of incoming orders and 
> so I kept things very simple: when the minimum quantity is reached one 
> requirement for the reorder quantity is created (this new requirement 
> SHOULD be sufficient for the average number of orders entered from now 
> on at least for the next few weeks).
>
> By the way, your approach is better than mine so it would be very nice 
> to see it implemented.
>
> About the facilityId field: yes, it would be nice to fill it, however 
> under some circumstances it's difficult to say for which facility we 
> are creating the requirement...
>
> About your last question about requirements' status:
>
> yes, the requirements' status is considered when the requirement is 
> added to an order; in the order entry page you can only see 
> requirements in the APPROVED status; at now you can approve a 
> requirement in two ways:
> - by editing the requirement in the ordermgr
> - by selecting the requirement in the "Approve requirements" page in 
> the manufacturing component
> When the order is checked out, the requirements' status is changed to 
> ORDERED.
> We should only update the quantity of the requirements in CREATED 
> status, not APPROVED.
>
> Jacopo
>
> Si Chen wrote:
>
>> Jacopo -
>>
>> Found what I think might be the issue:
>>
>> in checkCreateStockRequirement, you have this if statement:
>>
>> <if-compare-field field-name="quantityOnHandTotal" 
>> to-field-name="productFacility.minimumStock" 
>> operator="greater-equals" type="Double">
>>
>> So basically you are making sure that the QOH total starts out being 
>> greater than minimum stock before issuing a requirement.  Thus, if 
>> the item is already below minimum stock, no more requirements will be 
>> created.
>>
>> I think we should change this code so that:
>> 1.  We should always calculate what the new QOH will be
>> 2.  If the new QOH is below the minimum stock, then first see if a 
>> requirement for this facility and product already exists and is in 
>> the state of CREATED.  If it is, then update this requirement with 
>> the new quantity.  If not, then create a new requirement.
>>
>> That way, as an item is continuously ordered, the amount required is 
>> added to, until a person can intervene and order it.
>>
>> Also, do you think the Requirements should have the facilityId field 
>> filled in.
>>
>> Finally, in the order manager, are you using the requirement status 
>> to control which requirements can be used to add to the order?  If 
>> not, should we do that?
>>
>>
>> Si
>>
>
>
> _______________________________________________
> Users mailing list
> Users at lists.ofbiz.org
> http://lists.ofbiz.org/mailman/listinfo/users
>