PO's to the vender

I needed to change our PO forms to reflect the MPQ counts, I have found that printing the po, or exporting to HML uses the same xml file, I have modified that OK. However if I choose to export and select Excel it uses the stylesheet to format the order, and I cannot get the MPQ values to work, is the field name changed in the xsl? below are the two sections of the report.

Extract of po.xml: PurchaseOrder.Entry.QuantityOrdered "|" PurchaseOrder.Entry.MPQ "|" int(PurchaseOrder.Entry.QuantityOrdered/PurchaseOrder.Entry.MPQ) "|" PurchaseOrder.Entry.OrderNumber "|" PurchaseOrder.Entry.LookUpCode "|" PurchaseOrder.Entry.Description "|" PurchaseOrder.Entry.UnitPrice "|" PurchaseOrder.Entry.ExtendedPriceOrdered

Extract of RMSPurchaseorder.xsl: EvenRow

--------------notice i changed the tax field to MPQ, however nothing comes up, but it works using HTML. and prints the following: QTY MPQ Case ........ 48 12 4 .......

Reply to
RLambert
Loading thread data ...

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.