Posted by
Carl Sopchak on
URL: http://ofbiz.116.s1.nabble.com/Dev-Ordering-Units-of-Measure-tp167406.html
Much to my surprise, OFBiz does not seem to "do" order quantities in units of
measure other than the stock keeping unit. (I.e., you can't order a "Box" of
something when stock is kept in "Eaches".) Someone, please let me know if
I'm wrong here! Or, if anyone has made the mod on a "custom" basis, please
contact me off-list.
Assuming I need to make this change, here is what I propose:
1) Add attributes to the Product entity: skuUom (stock keeping unit UoM), and
customerOrderUom (default customer order quantity UoM; I forsee a
supplierOrderUom in my future, too, but I'm not sure yet).
2) Add the above fields to the Product Entry screen. Validate that either the
two UoM's are equal, or that there are UomConversion records to go between
the two.
3) Add attributes to the OrderItem entity: quantityAsOrdered and
quantityAsOrderedUom.
4) Change the entry of order line items so that the quantity that is entered
on the screen is saved in the quantityAsOrdered attribute, and add a
drop-down of units of measure, showing only those units of measure which have
a UomConversion record on file where the uomIdTo = product.skuUom, with the
default value being the product.customerOrderUom, and the selection being
saved in quantityAsOrderedUom. The quantityAsOrdered would be converted from
the quantityAsOrderedUom to the product.skuUom, and the result stored in
OrderItem.quantity. (There may be a rounding issue here that convertUom will
have to address...)
5) Change the display of order lines to show the quantityAsOrdered and
quantityAsOrderedUom instead of (or in addition to?) quantity and skuUom.
Here are my questions:
- Overall, does this make sense? Comments / suggestions / etc. welcome...
- I haven't received my Data Modeling Resource Books yet (on order...), so I'm
assuming the entities mentioned above are the right place to put the
additional attributes. Please correct me if I'm wrong.
- As for the "drop-down of UoMs" based on the product entered, this may be a
bit difficult on a web page due to the way web browsing works (although I've
seen "dynamic" pages that do similar things). Is there a standard way to
handle such things in OFBiz? Should I just display the customerOrderUom, and
supply a pop-up to pick from (based on the productId)? This does seems a bit
awkward though, particularly for "high volume" order entry.
- Although I'm sure I could find where everything needs to go, if anyone would
like to point me to specific things that would need changing (particularly if
I missed something), it would be most appreciated.
Thanks in advance for the help and comments.
Carl
_______________________________________________
Dev mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/dev