7 Replies Latest reply: May 15, 2014 10:12 AM by Olly Bond RSS

    Capture Material List within Item List

    vanhan _

      I am a new user of Monarch v10 and I have only the learning guide as my training.  Let's say my level of knowledge is "infant".

       

      I am trying to capture the Material Information (Type M) that is related Item # 260790.  I have used a footer to capture the information, but only the first  item is showing up on my table and summary.  How do I get all the M information on my table and summary and have it connected with the main Item it is related to? :confused:

         

      SyteLine 3.5b01a   kprod                                     KENNEDY MFG                                  EDBLAC   09/23/11 08:15:37         

      ITEM23-R                                                Item Current Routing                                              Page: 6289                                                                               

      Item: 260790                             Description: DOOR ASSY.- WC28                         Revision: 0B0                                                                               

      Crew Ctl                

      Oper WC     Description           Move Hrs Queue Hrs Setup Hrs  Pieces/Lbr Hr   Pieces/Mch Hr  FixSchHrs OffsetHrs   Size Pnt Cell           

      -


      -


      -


      -


      -


      -


        -


        -


      -


      -


      -


      --- -


                 

        10 288    8 Pt Multi Spot              ?         ?      0.00          50.000          50.000         ?         ?   1.00 No                                                                               

      WELD HINGE                                                                               

      BUILD SEQUENCE: 26                                                                               

      Type Item                                    Revision              Quantity U/M Per Ref Eff Date Obs Date BOM Seq                       

           -


      -


        -


      --- --- --- -


      -


      -


                               

           M    121028                                  0D0                    1.00000 EA   U   J                          ?                       

                  DOOR - WC28                                                                               

      M    121026                                  0B0                    1.00000 EA   U   J                          ?                       

                  DOOR PANEL - WC28                                                                               

      M    B120644                                 0C0                    1.00000 EA   U   J                          ?                       

                  STAPLE                                                                               

      M    B121031                                 0C0                    1.00000 EA   U   J                          ?                       

                  HINGE - WC28                                                                               

      M    B122064                                 0B0                    2.00000 EA   U   J                          ?                       

                  BRACKET, CATCH                                                                               

      20 202    Aux Body Line-F4D2           ?         ?      0.00          40.000          40.000         ?         ?   1.00 No                                                                               

      WELD PANEL & STAPLE                                                                               

      30 202    Aux Body Line-F4D2        0.00      0.00      0.00          40.000          40.000         ?         ?  12.00 Yes                                                                               

      WELD BRACKET CATCH                                                                               

      SyteLine 3.5b01a   kprod                                     KENNEDY MFG                                  EDBLAC   09/23/11 08:15:37         

      ITEM23-R                                                Item Current Routing                                              Page: 6290                                                                               

      Item: 260791                             Description: BODY ASSY. - WC28                        Revision: 0A0                                                                               

      Crew Ctl                

      Oper WC     Description           Move Hrs Queue Hrs Setup Hrs  Pieces/Lbr Hr   Pieces/Mch Hr  FixSchHrs OffsetHrs   Size Pnt Cell           

      -


      -


      -


      -


      -


      -


        -


        -


      -


      -


      -


      --- -


                 

        10 201    MACH/BODY/DRW WELD           ?         ?      0.00           5.000           5.000         ?         ?   1.00 Yes                                                                               

      WELD                                                                               

      BUILD SEQUENCE: 39                                                                               

      Type Item                                    Revision              Quantity U/M Per Ref Eff Date Obs Date BOM Seq                       

           -


      -


        -


      --- --- --- -


      -


      -


                               

           M    121029                                  0F0                    1.00000 EA   U   J                          ?                       

                  BODY - WC28                                                                               

      M    260792                                  0A0                    1.00000 EA   U   J                          ?                       

                  TOP PAN ASSY. - WC28                                                                               

      M    260793                                  0B0                    1.00000 EA   U   J                          ?                       

                  BOTTOM PAN WELD - WC28[/CODE]                                                                               

      This is what my summary looks like for a specific item:

      260790     DOOR ASSY.- WC28     No       10     288     8 Pt Multi Spot     121028     DOOR - WC28     Yes     50     50     1     No     1     652

      260790     DOOR ASSY.- WC28     No       20     202     Aux Body Line-F4D2                    40     40     1     No          652

      260790     DOOR ASSY.- WC28     No       30     202     Aux Body Line-F4D2                    40     40     12     Yes          652

                                                                             

      Summary                                                                      1956[/CODE]

       

      Any help would be greatly appreciated.

       

      Thank you!

      Vanessa Hansen

        • Capture Material List within Item List
          Olly Bond

          Hello Vanessa,

           

          The trick is to start with the most detailed/repeated/granular information - the data that you want to have on each row of your table - and make that your Detail template. Then look upwards in your report - anything above that you can grab with an Append or a Page Header template, and then look down from the detail and grab what you need with a Footer.

           

          You can only have one Detail template - but you can have up to 22 Appends and Footers if you need. In your case, make the M-Type records the Detail and the Items an Append and you should be fine.

           

          Best wishes,

           

          Olly