Hi Jim Software I use does this a different way. ItemMaster table which holds all parts and finished goods with a flag that says if the item is purchased or assembled LabourMaster table that holds all details of labour codes that are used DescriptorMaster table that holds all non-item components
This allows the BOMMaster to hold all assemblies and sub-assemblies with a flag to say if they are used as phantoms when used in other assemblies. This means that there are unlimited levels of sub-assemblies available. Regards Clive Williams -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Jim Belisle Sent: Thursday, 26 November 2015 02:58 To: [email protected] Subject: [RBASE-L] - BOM For years we have costed our products with a simple report just throwing together all parts making up a product not worrying about using an indented BOM. We would like to go to an indented BOM. Right now it is just Model# then all parts making up the model. We want something like this: Level 1: Model# Level 2: Assemblies and parts we ship Level 3: Sub assemblies (or parts if no subs) making up the assemblies. Level 4: Parts making up the sub assemblies. I can get it so all assemblies are together and then all subs together by assigning a BOMtype to them. So it will be: Assy Assy Assy Sub assy parts Sub assy parts Sub assy Parts That is not however what we want. I just can't seem to figure the proper way to handle this. Any blues clues would be appreciated. James Belisle Making Information Systems People Friendly Since 1990 [cid:[email protected]]
