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.