Sub-BOMs Cost Managment
In the display of a BOM I added a « Coût » column which allows to value a BOM line by line.
Then I planned a formula field « Coût Total (TVAC & MO) » which allows to calculate the total cost of a nomenclature
Now what I would like is to be able to report the « Coût Total (TVAC & MO) » of a BOM in the « Coût » field when a BOM is considered a child (a sub-BOM). I guess I need to create a result record of « Coût Total (TVAC & MO) » but I don't know how to do it.
Lines 1 & 2: Management of purchase prices
Lines 3 to 5: Management of items that are not purchased and not managed in stock (for example: labor)
Lines 6 to ...: Cost management of sub-BOMs
Can anybody help me ?
Thanks in advance and have a nice day everyone.
It seems that you are venturing on the rough seas of recursive structures. Searching the forum for “recursive” will return some food for though.
I just reinstalled an example database in this thread, which is only one of those one finds when searching for "recursive":
Looking around your DB, when you get to line 7, if you can get the correct grouping of articles, what quantities do you want to multiply to figure out Cout? (sorry for the lack of proper spelling).
- 5 mths agoLast active