[OFBiz] Users - Cycle counting & other OFBiz inventory curiosities

[David E. Jones]

This is a very basic part of data modeling, ie to use a sequenced key  
like this for flexibility. With inventory items we don't just want a  
single item by facility/location/product. We want to support single  
records for serialized inventory (ie with serial number) and we want  
to keep track of the date received and expiration date of every set  
of product received for the automatic allocation routines and such.  
So, all of those would have to be part of the primary key as well.  
Other fields would qualify for this too, so we'd end with at least  
half a dozen and generally quite a few more fields in the PK and  
that's a mess, and what is worse is that adding a new one requires  
redoing the PK def when updating OFBiz.

When bugs like this come up the only way to get around them is to  
find the problem and fix them. Unfortunately some people submit a lot  
of untested, crappy code and then take off and don't monitor the  
mailing lists or Jira to make sure they didn't screw anything up, so  
everyone has to wait until someone else has sufficient time and  
knowledge to take care of it....

-David


On Nov 11, 2005, at 9:18 AM, Christopher Farley wrote:

> Ray (ray.barlow at makeyour-point.com) wrote:
>
>> I've already logged an issue about the new inventory items creation,
>> although I've yet to understand whether it is really by design:
>> http://jira.undersunconsulting.com/browse/OFBIZ-521
>> New inventory items are also create for purchase order receiving  
>> as well.
>
> I don't fully understand why the primary key for inventory items is  
> not
> facility/location/product. I've purchased a few inventory/supply chain
> books in an attempt to understand inventory accounting a little bit  
> better,
> but it still seems as if facility/location/product uniquely identifies
> a inventory item. The use of a separate primary key allows for  
> multiple
> inventory items to be created for the same exact product/location.
>
> The weird thing is that I played with Neogia, which claimed to  
> complete
> refactor the whole OFBiz inventory system. However, Neogia still does
> the same thing with inventory items. So I've been assuming there was a
> good reason for the existing design.
>
> -- 
> Christopher Farley
> www.northernbrewer.com
>
> _______________________________________________
> Users mailing list
> Users at lists.ofbiz.org
> http://lists.ofbiz.org/mailman/listinfo/users

-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 2466 bytes
Desc: not available
Url : http://lists.ofbiz.org/pipermail/users/attachments/20051111/47095969/smime-0001.bin