0

Sub-BOMs Cost Managment

Hello everyone.

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.

8 replies

null
    • Alain_Fontaine
    • 11 mths ago
    • Reported - view

    It seems that you are venturing on the rough seas of recursive structures. Searching the forum for “recursive” will return some food for though.

      • Didier_Schoonjans
      • 11 mths ago
      • Reported - view

      Alain Fontaine

      Thanks for the info,
      But I can't find much that could help me.
      I may have searched incorrectly.

    • Alain_Fontaine
    • 11 mths ago
    • Reported - view

    I just reinstalled an example database in this thread, which is only one of those one finds when searching for "recursive":

    https://ninox.com/en/forum/technical-help-5ab8fe445fe2b42b7dd39ee7/resolving-a-bill-of-materials-60099f17f3f37f54ab80cc7c

      • Didier_Schoonjans
      • 11 mths ago
      • Reported - view

      Alain Fontaine 

      I just downloaded the ZIP file I will watch it carefully.
      But I am new to ninox and I studied programming languages 30 years ago. I have to relearn almost from scratch. But it's finally moving forward. I'm starting to find the logic but the programming languages of today have famously evolved.
      Sorry if my English is not very good (I speak French)

      Thank’s

    • Fred
    • 11 mths ago
    • Reported - view

    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).

      • Didier_Schoonjans
      • 11 mths ago
      • Reported - view

      Fred 

      Hello Fred,

      The sum is done well.
      When a BOM uses an item or labor, the cost value is reported in the table (these are lines 1 to 6).
      On the other hand, when I use an item which is itself a nomenclature (a sub-nomenclature in short), ninox must use the field « Coût Total (TVAC & MO) » (see printscreen 1 and 2). But in this case, it makes a loop. So I guess you would have to save the value first and then add it into the calculation.

      Thank's

      • Fred
      • 11 mths ago
      • Reported - view

      Didier Schoonjans I think that is a big limitation of your current setup with Articles being linked to other Articles. That is why my sample DB has a materials table and an Article table.

      • Didier_Schoonjans
      • 11 mths ago
      • Reported - view

      Fred 

      Maybe (I'm not convinced), but that's also why I had also planned a field that allows you to differentiate a simple "child" article (what you consider to be a material), from an article BOM "parent".
      I have already used several ERPs (used, not programmed), I have never seen two different tables for articles. On the other hand, each time, there is a checkbox to specify whether it is a child article (materials) or a parent article (nomenclature).
      But hey, maybe it's a limitation of NINOX (but since the base is linux, I don't think so).

Content aside

  • 11 mths agoLast active
  • 8Replies
  • 136Views
  • 3 Following