We have been asking Netsuite for Assembly Matrix Items for many years now with no response and STILL no solution. Matrix items are very powerful for obvious reasons but they cannot track inventory of parts used to assemble items. If we create an Assembly Item, we lose all the benefit of matrix functionality. Because we have thousands of items, each lacking either the assembly functionality or the matrix functionality, they all have to be rebuilt to accomplish this. Item type that meets basic inventory needs is one of the most fundamental concepts of a business and requires a solution. Otherwise we will end up starting over to rebuild everything, again. Our wait is over. Either we find a work around, or...... Here is where I am at so far.
Example: Widget XYZ has 2 member parts (top, bottom) available in 2 Sizes (small, large) and 2 Colors (red, white). We need to keep inventory of each part in each size/color and NS matrix item functionality cannot track inventory of parts, just whole product.
Trying to create a workaround and here is what we have so far:
1. Create Matrix Item for Top part
[INDENT] [LIST]Top - Small - Red[/LIST]
[LIST]Top - Large - Red[/LIST]
[LIST]Top - Small - White[/LIST]
[LIST]Top - Large - White[/LIST][/INDENT]
2. Create Matrix Item for Bottom part
[INDENT] [LIST]Bottom - Small - Red[/LIST]
[LIST]Bottom - Large - Red[/LIST]
[LIST]Bottom - Small - White[/LIST]
[LIST]Bottom - Large - White[/LIST][/INDENT]
3. Create Assembly Item to serve as Parent Assembly
[INDENT][LIST]Assemblies must have members so just add ficticious item as member[/LIST][/INDENT]
4. Create 4 Assembly Items to serve as Childs Assembly
[INDENT][LIST]Child Assembly Members are sub-matrix items in step 1 & 2[/LIST]
[LIST]Enter Parent Assembly created in step 3 to Sub-Item Of field on each of the 4 child assemblies [/LIST]
[LIST]1. Widget XYZ - Small - Red[/LIST]
[LIST]2. Widget XYZ - Small - White[/LIST]
[LIST]3. Widget XYZ - Large - Red[/LIST]
[LIST]4. Widget XYZ - Large - White[/LIST][/INDENT]
These 4 child assemblies are the items used in transactions and inventory is tracked on the final product (assembly) and its parts (initial matrix item). The parent assembly is associated to the child assemblies with the 'sub-item of', however, we need to define the characteristics (size, color) of each child-assembly in a better way than free form text in the assembly item title.
Some ideas:
[LIST]Child assembly members are matrix items with defined Size & Color characteristics[/LIST]
[LIST]Create list/record type field Color and another for size attached to each child assembly[/LIST]
[LIST]Custom Sublist for size and one for color[/LIST]
Any and all ideas are welcome and much appreciated.