Thank you for your help, i was able to get that to work.
Now my issue is formatting when it is exported into the XML file.
Several Items have the same PO Number. I wish for the PO Number to show up
only once along with data such as who ordered it, shipping method. The only
info I wish to repeat is the item info. Example of the output file.
- <po_pohdrf00_x0020_Query>
<AUX_PO_NO>BARB0002</AUX_PO_NO>
<PO_HDR_DAT>2007-05-23T00:00:00</PO_HDR_DAT>
<PO_HDR_ORD_BY>BARBARA</PO_HDR_ORD_BY>
<PO_HDR_SHIP_VIA>TRUCK</PO_HDR_SHIP_VIA>
<PO_HDR_SPEC_TERMS>SPECIAL TERMS</PO_HDR_SPEC_TERMS>
<PO_LIN_ITEM_NO>C1860A</PO_LIN_ITEM_NO>
<PO_LIN_ITEM_DESC_1>HEWLETT-PACKARD PLOTTER</PO_LIN_ITEM_DESC_1>
<PO_LIN_ITEM_DESC_2>PAPER C1860A 24" x 150'</PO_LIN_ITEM_DESC_2>
<PO_LIN_QTY_ORD>21</PO_LIN_QTY_ORD>
<PO_LIN_OUR_UNIT>EACH</PO_LIN_OUR_UNIT>
</po_pohdrf00_x0020_Query>
- <po_pohdrf00_x0020_Query>
<AUX_PO_NO>BARB0002</AUX_PO_NO>
<PO_HDR_DAT>2007-05-23T00:00:00</PO_HDR_DAT>
<PO_HDR_ORD_BY>BARBARA</PO_HDR_ORD_BY>
<PO_HDR_SHIP_VIA>TRUCK</PO_HDR_SHIP_VIA>
<PO_HDR_SPEC_TERMS>SPECIAL TERMS</PO_HDR_SPEC_TERMS>
<PO_LIN_ITEM_NO>C4715A</PO_LIN_ITEM_NO>
<PO_LIN_ITEM_DESC_1>HEWLETT-PACKARD DESIGNJET</PO_LIN_ITEM_DESC_1>
<PO_LIN_ITEM_DESC_2>450C "D" SIZE C4715A</PO_LIN_ITEM_DESC_2>
<PO_LIN_QTY_ORD>5</PO_LIN_QTY_ORD>
<PO_LIN_OUR_UNIT>EACH</PO_LIN_OUR_UNIT>
This is how I wish for it to look like.
- <po_pohdrf00_x0020_Query>
<AUX_PO_NO>BARB0002</AUX_PO_NO>
<PO_HDR_DAT>2007-05-23T00:00:00</PO_HDR_DAT>
<PO_HDR_ORD_BY>BARBARA</PO_HDR_ORD_BY>
<PO_HDR_SHIP_VIA>TRUCK</PO_HDR_SHIP_VIA>
<PO_HDR_SPEC_TERMS>SPECIAL TERMS</PO_HDR_SPEC_TERMS>
<PO_LIN_ITEM_NO>C1860A</PO_LIN_ITEM_NO>
<PO_LIN_ITEM_DESC_1>HEWLETT-PACKARD PLOTTER</PO_LIN_ITEM_DESC_1>
<PO_LIN_ITEM_DESC_2>PAPER C1860A 24" x 150'</PO_LIN_ITEM_DESC_2>
<PO_LIN_QTY_ORD>21</PO_LIN_QTY_ORD>
<PO_LIN_OUR_UNIT>EACH</PO_LIN_OUR_UNIT>
<PO_LIN_ITEM_NO>C4715A</PO_LIN_ITEM_NO>
<PO_LIN_ITEM_DESC_1>HEWLETT-PACKARD DESIGNJET</PO_LIN_ITEM_DESC_1>
<PO_LIN_ITEM_DESC_2>450C "D" SIZE C4715A</PO_LIN_ITEM_DESC_2>
<PO_LIN_QTY_ORD>5</PO_LIN_QTY_ORD>
<PO_LIN_OUR_UNIT>EACH</PO_LIN_OUR_UNIT>