Hi guys, what you are saying makes perfect sense from the database perspective. the only problem i found was that the inventory item was not searchable using the alias fields. is this correct or does the manufacturing module have the ability to pull up the inventory item based on the serial number or manufacturing ID alias? thanks Adarsh
-----Original Message----- From: Jonathon -- Improov [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 22, 2007 11:24 AM To: [email protected] Subject: Re: ofbiz inventory ID format Chris is right. Use an additional field like "itemId" or "serialNumber" or similar. Read the Data Model book about productId in entity Product. Jonathon Chris Howe wrote:
Your additional use cases bring up the problem with coding information
in your product Id. Manufacturer Id, serialized inventory, prefixed
product Ids are all aliases. It is generally best for the productId as
the primary key to only have meaning to the database and not to the
users. This has been brought up and discussed in more detail
throughout the ML so I won't rehash it here. But be warned to consider
a more comprehensive approach to naming conventions.
--- Adarsh Holavanahalli <[EMAIL PROTECTED]> wrote:
Thanks for the responses. Importing the product IDs is a painful
thing to
teach the normal user. but i guess it will have to do for now. it
would have
been nice if we could have setup the inventory ID prefixes as part of
the
setup file. imagine that this one step will allow barcoded
manufacturing
stickers to be preprinted (for different components) and serialized
inventories to suddenly be more meaningful.
hope this gets into the wish list of future ofbiz releases
Adarsh
-----Original Message-----
From: BJ Freeman [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 22, 2007 3:05 AM
To: [email protected]
Subject: Re: ofbiz inventory ID format
just a short note, if you import the product ID thru the webtools.
you can have any product ID you want.
then do the rest manually if you want.
Adarsh Holavanahalli sent the following on 5/20/2007 9:50 PM:
Hi,
Is there anyway to control the format of the inventory item ID in
ofbiz?
right now all inventory items start at 10000 or so. is there a way
to add
a
prefix or a suffix to the automatically generated item ID?
thanks
Adarsh
