Re: [OFBiz] Users - Automatic Purchasing

Posted by Jacopo Cappellato on
URL: http://ofbiz.116.s1.nabble.com/OFBiz-Users-Automatic-Purchasing-tp136301p136329.html

Hi Christopher,

I agree with Si when he says that you should consider extending the
existing requirement stuff.

The enhancements you are suggesting are very good stuff (I can see you
have a good understanding of the existing data model and processes
related to requirements) and, as Si already said, some of them are
partially implemented.

1 and 2 are partially implemented (see the Manufacturing-->Approve
requirement screen)
3 and 4 are planned features that it would be great to see implemented:
if you need help, please let me know.

About the primary supplier concept: given a product, the primary
supplier could be the one with higher priority in the SupplierProduct
entity; and, when creating a requirement for a product, you could link
the 'primary' supplier to the requirement thru the
RequirementPartyAssign (or something similar, I don't remember the name
of the entity) giving it a role like PRIMARY_SUPPLIER.

Regards,

Jacopo

Christopher Farley wrote:

> Si Chen ([hidden email]) wrote:
>
>
>>It would be nice to have some automated purchase order creation.
>>
>>But, how is "Purchase orders will be automatically created, and the user
>>can approve them or cancel them" going to be really different than
>>"Requirements are automatically created, and the user can create
>>purchase orders from them or cancel them"? Might you be writing a lot of
>>code to support essentially the same business process.
>
>
> I could use requirements, but I would need to make the following
> enhancements to OFBiz:
>
>  1. Create a screen to automatically generate requirements from
>     current inventory values: for each item with an ATP less than the
>     minumumQuantity, create a new requirement.  The quantity of this
>     requirement is reorderQuantity - ATP. This screen should allow
>     the user to limit automatic requirement generation by
>     supplier, product SKU range, product category, etc.
>
>  2. Improve the Approve Requirements process. A lot of businesses have
>     thousands, or even tens of thousands of SKUs, and there needs to be
>     a way to approve and reject requirements en masse. My idea would
>     be to list all requirements on a single screen so they can be
>     selected with a check box. Include buttons to Select All/Deselect
>     All. Finally, you need a way to either approve or reject the selected
>     requirements.
>    
>  3. For adding requirements to purchase orders: the Requirement List
>     should only show requirements that contain products that are valid
>     for the current Supplier. You would need to "SELECT * FROM requirement
>     WHERE product_id IN (SELECT product_id FROM supplier_product WHERE
>     party_id = ?)"
>    
>  4. Currently, when you try and put a requirement on a purchase order,
>     and the quantity is less than the supplier's minimum order qty, you
>     get an error: "SupplierProduct not found". This needs to be fixed.
>     Idea: Next to the "Submit Button" on the Requirement List, include
>     a checkbox that says "Increase Quantities to Match Supplier's
>     Minimum Order Quantities".
>  
> This would not necessarily require a "Primary Supplier" to be defined.
>
> Maybe this would be easier than what I proposed earlier. My other
> solution could have been a stand-alone application, whereas enhancing the
> requirements involves mucking with existing OFBiz code/applications.
> I'm somewhat comfortable creating a stand-alone app, but moderately
> fearful of enhancing existing OFBiz code.
>

 
_______________________________________________
Users mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users