Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear all,
I have been trying to achieve a Bill of Materials using various functions, and finally I was able to achieve (I think!) what I needed using the HierarchyBelongsTo function…
However, my costs are wrong as the higher level components include the costs for the lower level, so what I need to do is ignore the cost for any component that has a sub component. But how do I go about calculating which item belongs to which?
Here is an example output of data:
Comp | LL Cost Comp | TL Cost Comp | Depth |
SA9500FW1 | 0.206807692 | 0 | 0 |
SA9500FW2 | 0.219461539 | 0 | 0 |
6852A | 0 | 0.228 | 1 |
20935H | 0 | 0.0198 | 1 |
20940H | 0 | 0.0198 | 1 |
4488 | 0.23199834 | 0 | 1 |
4489 | 0.23043029 | 0 | 1 |
5011 | 0 | 0 | 1 |
5011 | 0 | 5 | 1 |
5011 | 0 | 7.5 | 1 |
6857 | 0 | 0.159 | 1 |
10859 | 0 | 0 | 1 |
10859 | 0 | 0.003744164 | 1 |
10859 | 0 | 0.00425 | 1 |
10859 | 0 | 0.0139 | 1 |
31055 | 0 | 0.1354 | 1 |
7008 | 0 | 0 | 2 |
7008 | 0 | 83 | 2 |
7008 | 0 | 104.89 | 2 |
7035 | 0 | 0 | 2 |
7035 | 0 | 29.5 | 2 |
7035 | 0 | 62.1 | 2 |
7143 | 0 | 0 | 2 |
7143 | 0 | 2.92 | 2 |
7143 | 0 | 3.1 | 2 |
7143 | 0 | 3.17 | 2 |
7157 | 0 | 0 | 2 |
7157 | 0 | 1.89 | 2 |
7157 | 0 | 2.24 | 2 |
7173 | 0 | 0 | 2 |
7173 | 0 | 6.89 | 2 |
7173 | 0 | 9.7 | 2 |
7241 | 0 | 0 | 2 |
7241 | 0 | 12.8 | 2 |
7241 | 0 | 13.73 | 2 |
7244 | 0 | 0 | 2 |
7244 | 0 | 1.8 | 2 |
7244 | 0 | 2.3 | 2 |
7246 | 0 | 0 | 2 |
7246 | 0 | 2.9 | 2 |
7246 | 0 | 3.49 | 2 |
7259 | 0 | 0 | 2 |
7259 | 0 | 3.15 | 2 |
7259 | 0 | 4.6 | 2 |
7304 | 0 | 0 | 2 |
7304 | 0 | 0.195 | 2 |
7304 | 0 | 0.31 | 2 |
7428 | 0 | 0 | 2 |
7428 | 0 | 16.35060001 | 2 |
7428 | 0 | 16.43919 | 2 |
7440 | 0 | 0 | 2 |
7440 | 0 | 3.507457604 | 2 |
7440 | 0 | 4.5 | 2 |
Many thanks for any help you could provide!!
Kind Regards,
Dayna
IS this what you mean?
I will have a look and let you know! Thanks Jochem!
IS YOUR PROBLEM SOLVED??
Jochem,
I have been on annual leave, so I don't know if it resolves my issue 100%. But it seems to break down the components.
Many thanks,
Dayna
Hi Jochem
I see your qvw about this topic, also I have a question for you.
It's possible with the semi-elaborate products has the BOM explossion with hierarchy
Let me explain
You have a Final Product with this formula, but in the formula you have a code who has his own formula
I have maybe 3 or 4 levels in some products. Any Ideas?
The final output its only have materials requirements with the semi-elaborate requirements.
thank you