Re: [OFBiz] Users - Automatic Purchasing

Posted by Christopher Farley on
URL: http://ofbiz.116.s1.nabble.com/OFBiz-Users-Automatic-Purchasing-tp136301p136326.html

Daniel Kunkel ([hidden email]) wrote:

> 4. Just to confirm terminology: my script calcs requirement quantity
> like
>    this:
>    requirementQuantity = reorderQuantity - availableToPromiseQuantity
>    Am I interpreting "reorderQuantity" properly? Or is
> "reorderQuantity"
>    meant to be a fixed quantity that is ordered each time you order?
>
> I think reorderQuantity is something that is different for each
> supplier, and is based on minimumQuantity and OrderQuantityIncrements.
>
> Would it make more sense to do something like...
>
>    requirementQuantity = minimumStock - incomingShipments -
> availableToPromiseQuantity

My current system has a concept of minimumStock and maximumStock levels.
We order all items that have fallen below the minimum stock levels, and
we replentish these items up to the maximum stock levels.

I was guessing that "reorder quantity" was analagous to "maximum stock".
My only justification for this was that, in the seed data, reorderQuantity
was always greater than minimumStock.

OFBiz does have a separate field for a supplier minimum order quantity,
in the supplier_product relation. But auto-generating requirements
shouldn't consider this -- it is just a service to generate requirements
based on what your facility needs. Later, you can adjust the purchase
order to take into account the supplier's minimum order quantity and
order quantity increments...

As for taking into account incoming shipments, yes this should be done.
Does anybody know if there is an existing service to query the incoming
shipments? I'll have a look...

> At some point, to make OFBiz truly generic, we might want to think about
> upgrading the inventory system to one that can track future inventory
> requirements at multiple points in time.  In the electronics industry
> lead times can exceed 6 months... with numerous future
> purchases/deliveries planned... It can get tricky to know if you can
> sell X today, and still meet all of your promised deliveries.


--
Christopher Farley
www.northernbrewer.com
 
_______________________________________________
Users mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users