Ask A Question I

Fri, 17 Jul 2020 06:56:55 GMT

Ask a question in a forum.

Custom BOM Quantity Rollout Report

rmurphy — Fri, 17 Jul 2020 13:25:54 GMT

Hi,

I am trying to develop a custom BOM Quantity Rollout report, we have been able to pull in all the information we need from the Parts and Part BOM however, we need help pulling in the Manufacturer Part from the Part AML,

I need help in determining what I must add to the query in order to pull in the Part AML correctly, below is the current query:

<Item type="Part" action="get" id="{@id}" select="item_number,name,cavi_manufacturer">
 <Relationships>
  <Item type="Part BOM" select="sort_order,quantity,related_id(item_number,name,cavi_manufacturer)">
   <related_id>
    <Item type="Part" select="item_number,name,cavi_manufacturer">
     <Relationships>
      <Item type="Part BOM" select="sort_order,quantity,related_id(item_number,name,cavi_manufacturer)">
       <related_id>
        <Item type="Part" select="item_number,name,cavi_manufacturer">
         <Relationships>
          <Item type="Part BOM" select="sort_order,quantity,related_id(item_number,name,cavi_manufacturer)">
           <related_id>
            <Item type="Part" select="item_number,name,cavi_manufacturer">
             <Relationships>
              <Item type="Part BOM" select="sort_order,quantity,related_id(item_number,name,cavi_manufacturer)">
               <related_id>
                <Item type="Part" select="item_number,name,cavi_manufacturer">
                 <Relationships>
                  <Item type="Part BOM" select="sort_order,quantity,related_id(item_number,name,cavi_manufacturer)">
                   <related_id>
                    <Item type="Part" select="item_number,name,cavi_manufacturer"></Item>
                   </related_id>
                  </Item>
                 </Relationships>
                </Item>
               </related_id>
              </Item>
             </Relationships>
            </Item>
           </related_id>
          </Item>
         </Relationships>
        </Item>
       </related_id>
      </Item>
     </Relationships>
    </Item>
   </related_id>
  </Item>
 </Relationships>
</Item>

Any help on how to modify this to include the Part AML would be greatly appreciated,

Thanks in advance,

rmurphy さんの グループ アクティビティ

Ask A Question I

Custom BOM Quantity Rollout Report

rmurphy さんのグループアクティビティ