Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi all,
I have a problem whit the linearization of the bills of material.
I have a table which has on the same line the parent code and child code, with the use's factor for son.
The child code can become a father in another row, with the relative use's factor.
eg.
FATHER | SON | FACTOR-USE |
A | B | 2 |
A | C | 3 |
B | D | 1 |
C | E | 2 |
C | F | 2 |
F | G | 1 |
I want the linearization of the bill, so that I can bind the parent code and how many children are need to make the father.
eg. father A needs 2B, 3C, 2D, 6E, 6F, 6G
I did experiment with the function Hierarchy, but I can't able to define the use's factor.
Any ideas please?
thank
Hi,
I have solve this problem with the attached example. It's a long way in script, but it works.
Regards Vicky
Hi Vicky,
thanks very much for your answer, but my problem is that i don't know how many levels the bills of material is composed of, and so your example is not adaptable. any other ideas?
thanks
Tiziana