Posted by
Christopher Farley on
URL: http://ofbiz.116.s1.nabble.com/OFBiz-Users-Automatic-Purchasing-tp136301p136303.html
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.
--
Christopher Farley
www.northernbrewer.com
_______________________________________________
Users mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users