Hi Jacopo, Thank you for the information. I shall dump the entity table and get the required data.
But as an aside on this topic with respect to manufacturing: In the future, how would ofbiz handle cases wherein the product has been manufactured and shipped to the customer and then one day one of the components need to be replaced (field replaceable unit). Would the inventory module allow us to keep track of the new subcomponent as well. In order to do this, we would need to be able to update the original subcomponent list of the manufactured product. From a manufacturing perspective, we would end up marking the failed subcomponent as bad (or deleting it altogether) and adding the replacement subcomponent. Regards Adarsh -----Original Message----- From: Jacopo Cappellato [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 10, 2007 11:31 AM To: [email protected] Subject: Re: Manufactured product help Hi Adarsh, right now there is no user interface to easily provide this information (hopefully I'll add something about this in the short term period). However, the information is in the following entity: WorkEffortInventoryAssign the workEffortId is the id of the production run task that used the material (usually the first task in the production run), and inventoryItemId is the id of the (serialized) item consumed. Hope this helps, Jacopo Adarsh Holavanahalli wrote: > Hi, > > I have a simple question about manufacturing in Ofbiz. I have an > inventory where are raw material components are serialized items. I have > FIFO inventory usage policy defined on the store. Now I have built > several products using the raw materials and the products themselves are > serialized items as well. Can anyone clarify the following points for > me? > 1. how do I list all the sub components with their > serial numbers in a specific manufactured product (say with serial > number A1234567) > 2. given the serial number of the raw material, how will > I trace it back to the product that it is a part of? > > > Thanks > Adarsh > > -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.446 / Virus Database: 269.0.0/754 - Release Date: 4/9/2007 10:59 PM -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.446 / Virus Database: 269.0.0/754 - Release Date: 4/9/2007 10:59 PM
