2 Replies Latest reply: Nov 9, 2012 7:08 AM by Josetxo Amonarriz RSS

    Bill of Materials from Navision

    Josetxo Amonarriz

      Hello,

       

      I have been looking for a way to make a explosion of the Production_BOM_Line table.

      Every Item with a BOM (Bill of Materials) has a BOM No. in this table, which has these relevant fields:

       

      BOM No.     Line No.      Type                 Item/ProdBOM No.    

       

      BOM1          1               Item                    Item1

      BOM1          2               Item                    Item2

      BOM1          3               BOM                BOM2

       

      BOM2          1               Item                    Item1

      BOM2          2               Item                    Item2

      BOM2          3               Item                    Item3

       

      Item1           1               Item                    Item4

      Item1           2               BOM                   BOM3


      BOM3          1               Item                    Item5

      BOM3          2               Item                    Item6

       

      So, BOM1 is a Bill of Materials which has three components / lines: two Items (Item1 and Item2) and a BOM (BOM2). This BOM2 consists on three items (Item1, Item2 and Item3). Item1 consists on another Item (Item4) and a BOM (BOM3).

       

      I would like to make a explosion of this BOM table like a tree. Can the hierarchy function help on this?

      I would really appreciate any recommendation on how to attack this issue.

       

      Thanks!