This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

DEVELOPERS FORUM - BOM Quantity Report

jsnosal - Monday, August 6, 2012 2:32 PM:

 

I’m trying to create a BOM report that shows the approved manufacture and part for each part. This is so when we send the BOM to our manufacture they have the list of all our approved manufactures for that part. I’m using the BOM Quantity Report as a template. I have the AML written the way I need it. I’m just having an issue with XSLT template. Is there a tool I can use or any suggestions on what I could do to get the template to work? Thank you for your help.  

 

<Item type="Part" action="get" id="{@id}" select="item_number,name">

 <Relationships>

  <Item type="Part BOM" select="sort_order,quantity,related_id(item_number,name)">

    <related_id>

    <Item type="Part" select="item_number,name">

<Relationships>

<Item type="Part AML" action="get" select="sort_order,quantity,related_id(manufacturer,keyed_name)"></Item>

</Relationships>

<Item type="Part BOM" select="sort_order,quantity,related_id(item_number,name)">

<related_id>

  <Item type="Part" select="item_number,name">

<Relationships>

<Item type="Part AML" action="get" select="sort_order,quantity,related_id(manufacturer,keyed_name)"></Item>

</Relationships>

<Item type="Part BOM" select="sort_order,quantity,related_id(item_number,name)">

<related_id>

<Item type="Part" select="item_number,name">

<Relationships>

<Item type="Part AML" action="get" select="sort_order,quantity,related_id(manufacturer,keyed_name)"></Item>

</Relationships>

<Item type="Part BOM" select="sort_order,quantity,related_id(item_number,name)">

<related_id>

<Item type="Part" select="item_number,name">

<Relationships>

<Item type="Part AML" action="get" select="sort_order,quantity,related_id(manufacturer,keyed_name)"></Item>

</Relationships>

</Item>

</related_id>

</Item>

</Item>

</related_id>

</Item>

</Item>

</related_id>

</Item>

</Item>

</related_id>

</Item>

</Relationships>

</Item>

 



RobMcAveney - Tuesday, August 7, 2012 8:40 AM:

Take a look at this thread: http://www.aras.comhttp://www.aras.com/Community/forums/t/396.aspx

Rob



jsnosal - Tuesday, August 7, 2012 9:30 AM:

Thank you so much. This is exactly what I was looking for.