Hi Jonathon,
I did mean UI search screens.
thanks
Adarsh
Jonathon -- Improov wrote:
Do you mean, "not searchable" as in there's no search screen to search
by InventoryItem fields?
One easy way is to create a view entity, which can be searchable by
all the fields it pulls together.
Jonathon
Adarsh Holavanahalli wrote:
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
------------------------------------------------------------------------
No virus found in this incoming message.
Checked by AVG Free Edition. Version: 7.5.467 / Virus Database:
269.7.6/813 - Release Date: 5/20/2007 7:54 AM
