none
Multi Level Bill of Material BoM - child total quantities as per branch quantity RRS feed

  • Question

  • Cheers fellow developers,

    I'm VBA beginner trying to accomplish something beyond my limited knowledge. So, I have this ERP system that exports Bill of materials, however it does not multiply children quantities in relation to its parents. Every user must check the BoM and correct the quantities to issue for quote or purchasing. What I want is that every child get its quantities multiplied by their correspondent parent in a new column.

    The data below shows my problem, I manually filled color each major parent for easy visualization, you can observe that some items drills down all the way to level 6 (.....) and can come back to any level. Column Item is related item number to its parent, but should not be trusted as sequential because it can have a part with same item number at same level.

    Note: Some parents there is no quantity, in this case no multiplications shall be done to its children. Also some children have no quantity, same thing no need to multiply.

    Qty. Level Item
    1 1 001
    1 .2 001
      .2 002
      .2 003
      .2 004
      .2 005
    0.5 ..3 001
      .2 006
    1 1 002
    1 .2 001
    1 ..3 001
      ...4 001
    1 ....5 001
    1 ....5 002
    2 ..3 002
    1 ...4 001
    2 ..3 003
    2 ...4 001
    1 ..3 004
      ...4 001
    1 ....5 001
    1 ....5 002
    1 ....5 003
    1 ..... 001
    1 ..... 002
    1 ..... 003
    1 1 003
      .2 001
    1 ..3 001
      ...4 001
    1 ...4 002
    1 ..3 002
    1 ...4 001
    2 ...4 002
    1 ...4 003
    2 ...4 004
    1 ..3 003
    1 ..3 004
      ...4 001
    1 .2 001
      ..3 001
    1 ..3 002
    1 1 004
      .2 001
      ..3 001
      ..3 002
    1 ...4 001
      ..3 006
    1 ...4 001
    1 ..3 007
    1 ..3 008
    0.01 ...4 001
      ..3 009
    1 .2 001
    1 .2 002
    1 ..3 001
      ..3 002
      ..3 003
    1 .2 003
    1 ..3 001
      ..3 002
    3 .2 004
    0.33 ..3 001
      ..3 002
    3 .2 005
    3 .2 006
      .2 007
      .2 008
    1 1 005
    1 1 006
    1 1 007
    1 .2 001
      .2 002
      .2 003
      .2 004

    Thursday, August 8, 2019 1:11 PM