Item - Which BOM is it in

midnightmidnight Member Posts: 74
We have an item which could be in numerous BOM's. We need a quick way to pop in the item number and list all the BOM's that have that item number in it. I do a Where-Used from the item card, I get a list of items but no BOM numebrs. Any ideas?

WhereUsed_zps80678241.jpg

Comments

  • SPost29SPost29 Member Posts: 148
    Where used list is created by CU 99000770.
    In the BuildWhereUsedList function
    BuildWhereUsedList(Type : ' ,Item,Production BOM';No : Code[20];"Calc.Date" : Date;Level : Integer;Quantity : Decimal)
    IF Level > 30 THEN
      EXIT;
    
    IF Type = Type::"Production BOM" THEN BEGIN
      ItemAssembly.SETCURRENTKEY("Production BOM No.");
      ItemAssembly.SETRANGE("Production BOM No.",No);
      IF ItemAssembly.FIND('-') THEN
        REPEAT
          WhereUsedList."Entry No." := NextWhereUsedEntryNo;
          WhereUsedList."Item No." := ItemAssembly."No.";
          // Add this line
          WhereUsedList."Production BOM No." := ItemAssembly."Production BOM No.";
         // end Add
          WhereUsedList.Description := ItemAssembly.Description;
          WhereUsedList."Level Code" := Level;
          WhereUsedList."Quantity Needed" :=
            Quantity *
            (1 + ItemAssembly."Scrap %" / 100) *
            UOMMgt.GetQtyPerUnitOfMeasure(
              ItemAssembly,
    

    that should show up on the form then.
  • midnightmidnight Member Posts: 74
    Worked like a charm.....Thanks.
Sign In or Register to comment.