CyberStore Documentation
CustomerOrderDisplay.xslt
The following is the default XML transformation file applied to a SORQRY output during Sales Order lookup.
<?xml version="1.0" ?> <xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0" xmlns:TBLART="TBLART" xmlns:SALBRN="SALBRN" xmlns:SALARE="SALARE" xmlns:SALSLS="SALSLS"> <xsl:template match="/"> <HTML> <HEAD> <title> Order Lookup </title> <script type="text/javascript" language="javascript" src="../../main/scripts/query.js"></script> <script> <![CDATA[ function showvalue(sorder) { sor=window.open("salesordervalue.aspx?order=" + sorder + "", "orderwin", "top=100,left=100,height=" + window.screen.availHeight*0.4 + ",width=" + window.screen.availWidth * .5 + ",resizable,scrollbars") sor.window.focus() } ]]> </script> </HEAD> <BODY> <div class="logoWrapper"> <div class="divTableCell logo"></div></div> <table class="orderdisplayTable" border="0"> <!-- <tr> <td class="orderdisplayTitle" align="center" colspan="5"> Order Lookup </td> </tr> --> <tr> <td class="orderdisplayLabel" nowrap="on" width="30%">Order Number:</td> <td class="orderdisplayField" nowrap="on" width="30%"> <xsl:value-of select="/SorDetail/SalesOrder" /> </td> <td class="orderdisplayField" /> <td rowspan="7" class="orderdisplayLabel" nowrap="on" valign="top" width="10%"> Ship To: </td> <td class="orderdisplayField" nowrap="on" width="30%"> <xsl:value-of select="/SorDetail/CustomerName" /> </td> </tr> <tr> <td class="orderdisplayLabel" nowrap="on">Invoice Terms:</td> <td class="orderdisplayField" nowrap="on"> <xsl:value-of select="//TBLART:Description" /> </td> <td class="orderdisplayField" nowrap="on"> </td> <td class="orderdisplayField" nowrap="on"> <xsl:value-of select="/SorDetail/ShipAddress1" /> </td> </tr> <tr> <td class="orderdisplayLabel" nowrap="on">Order Date:</td> <td class="orderdisplayField" nowrap="on" colspan="2"> <xsl:value-of select="/SorDetail/OrderDate" /> </td> <td class="orderdisplayField" nowrap="on"> <xsl:value-of select="/SorDetail/ShipAddress2" /> </td> </tr> <tr> <td class="orderdisplayLabel" nowrap="on">Shipping Instructions:</td> <td class="orderdisplayField" nowrap="on"> <xsl:value-of select="/SorDetail/ShippingInstrs" /> </td> <td></td> <td class="orderdisplayField" nowrap="on"> <xsl:value-of select="/SorDetail/ShipAddress3" /> </td> </tr> <tr> <td class="orderdisplayLabel" nowrap="on">Special Instructions:</td> <td class="orderdisplayField" nowrap="on" colspan="2"> <xsl:value-of select="/SorDetail/SpecialInstrs" /> </td> <td class="orderdisplayField" nowrap="on"> <xsl:value-of select="/SorDetail/ShipAddress4" /> </td> </tr> <tr> <td class="orderdisplayLabel" nowrap="on">Customer PO:</td> <td class="orderdisplayField" nowrap="on" colspan="2"> <xsl:value-of select="/SorDetail/CustomerPoNumber" /> </td> <td class="orderdisplayField" nowrap="on"> <xsl:value-of select="/SorDetail/ShipAddress5" /> </td> </tr> <tr> <td class="orderdisplayLabel" nowrap="on"> Order Status: </td> <td class="orderdisplayField" nowrap="on" colspan="2"> <!--(<xsl:value-of select="/SorDetail/OrderStatus" />)   --> <xsl:choose> <xsl:when test="/SorDetail/OrderStatus[. ='0']"> In process </xsl:when> <xsl:when test="/SorDetail/OrderStatus[. ='*']"> Cancelled </xsl:when> <xsl:when test="/SorDetail/OrderStatus[. ='\']"> Cancelled </xsl:when> <xsl:when test="/SorDetail/OrderStatus[. ='1']"> Open order </xsl:when> <xsl:when test="/SorDetail/OrderStatus[. ='2']"> On back order </xsl:when> <xsl:when test="/SorDetail/OrderStatus[. ='3']"> Released backorder </xsl:when> <xsl:when test="/SorDetail/OrderStatus[. ='4']"> In warehouse </xsl:when> <xsl:when test="/SorDetail/OrderStatus[. ='8']"> Ready to invoice </xsl:when> <xsl:when test="/SorDetail/OrderStatus[. ='9']"> Complete </xsl:when> <xsl:when test="/SorDetail/OrderStatus[. ='S']"> On hold </xsl:when> <xsl:otherwise> <xsl:value-of select="/SorDetail/OrderStatus" /> </xsl:otherwise> </xsl:choose> </td> <td class="orderdisplayField" nowrap="on"> <xsl:value-of select="/SorDetail/ShipPostalCode" /> </td> </tr> <tr> <!-- <td class="orderdisplayLabel" valign="top"> </td> <td class="orderdisplayField" nowrap="on"> </td> </tr> <tr> <td class="orderdisplayLabel" nowrap="on"> </td> <td class="orderdisplayField" nowrap="on" colspan="2"> </td> --> </tr> <tr> <!-- Display of DETAIL LINES --> <td colspan="5"> <br /> <table width="100%" align="center" cellpadding="5" cellspacing="0" border="0"> <tr class="detailhdg2" valign="bottom"> <td class="orderdisplaydetailLabel" nowrap="on"> Stock Code </td> <td class="orderdisplaydetailLabel"> Description </td> <!-- Special column to hold serial/bin hyperlinks <td class="orderdisplaydetailLabel" /> --> <td class="orderdisplaydetailLabel"> Customer Price </td> <td class="orderdisplaydetailLabel"> Unit Price </td> <td class="orderdisplaydetailLabel" Title="Unit of Measure"></td> <td class="orderdisplaydetailLabel">Qty</td> <td class="orderdisplaydetailLabel" nowrap="on"></td> <!-- <td class="orderdisplaydetailLabel"> Warehouse </td> --> <td class="orderdisplaydetailLabel"> Value </td> <td class="orderdisplaydetailLabel" nowrap="on"> Ship Qty </td> <td class="orderdisplaydetailLabel" Title="Back order quantity"> B/O Qty </td> <td class="orderdisplaydetailLabel" nowrap="on"> Est. Ship Date </td> </tr> <xsl:for-each select="SorDetail/SalesOrderLine"> <tr> <xsl:choose> <xsl:when test="position() mod 2 = 1"> <xsl:attribute name="class">TableRow</xsl:attribute> </xsl:when> <xsl:otherwise> <xsl:attribute name="class">HighlightTableRow</xsl:attribute> </xsl:otherwise> </xsl:choose> <!-- MERCHANDISE LINES --> <xsl:if test="Merchandise[. !=' ']"> <td class="orderdisplaydetailField" nowrap="on"> <xsl:if test="Merchandise/MWarehouse[. !='**']"> <xsl:value-of select="Merchandise/MStockCode" /> </xsl:if> <xsl:if test="Merchandise/MWarehouse[. ='**']"> <xsl:value-of select="Merchandise/MStockCode" /> </xsl:if> </td> <td class="orderdisplaydetailField" nowrap="on"> <xsl:value-of select="Merchandise/MStockDes" /> </td> <!-- Special column to hold serial/bin hyperlinks <td class="orderdisplaydetailField" nowrap="on"> Serials <xsl:if test="Merchandise/Lot[. !='']">  Lots </xsl:if> <xsl:if test="Merchandise/Bin[. !='']">  Bins </xsl:if> </td> --> <td class="orderdisplaydetailField" nowrap="on" align="right"> <xsl:value-of select="format-number(Merchandise/MPrice,'###,###,###.00')" /> </td> <td class="orderdisplaydetailField" nowrap="on" align="right"> <xsl:value-of select="format-number(Merchandise/OrderLineValue div (Merchandise/MBackOrderQty + Merchandise/MShipQty),'###,###,###.00')" /> </td> <td class="orderdisplaydetailField" nowrap="on"> <xsl:value-of select="Merchandise/MPriceUom" /> </td> <td class="orderdisplaydetailField" nowrap="on" align="right"> <xsl:value-of select="format-number(Merchandise/MOrderQty,'###,###,##0')" /> </td> <td class="orderdisplaydetailField" nowrap="on"> <xsl:value-of select="Merchandise/MOrderUom" /> </td> <!-- <td class="orderdisplaydetailField" nowrap="on"> <xsl:value-of select="Merchandise/MWarehouse" /> </td> --> <td class="orderdisplaydetailField" nowrap="on" align="right"> <xsl:value-of select="format-number(Merchandise/OrderLineValue,'###,###,###.00')" /> </td> <td class="orderdisplaydetailField" nowrap="on" align="right"> <xsl:value-of select="format-number(Merchandise/MShipQty,'###,###,##0')" /> </td> <td class="orderdisplaydetailField" nowrap="on" align="right"> <xsl:value-of select="format-number(Merchandise/MBackOrderQty,'###,###,##0')" /> </td> <td class="orderdisplaydetailField" nowrap="on" align="center"> <xsl:value-of select="Merchandise/MLineShipDate" /> </td> <!-- SERIALS --> <xsl:if test="Merchandise/Serial[. !='']"> <tr style="display:none" id="ser_{generate-id()}"> <td colspan="2" /> <td colspan="5"> <table width="100%" align="left" style="border:thin solid outset"> <tr class="detailhdg2"> <td class="orderdisplaydetailLabel" nowrap="on"> Serial </td> <td class="orderdisplaydetailLabel" nowrap="on"> Lot </td> <td class="orderdisplaydetailLabel" nowrap="on" align="right"> Qty </td> <td class="orderdisplaydetailLabel" nowrap="on" align="center"> Expiry date </td> </tr> <xsl:for-each select="Merchandise/Serial"> <tr> <td class="subdetail" nowrap="on"> <xsl:value-of select="Serial" /> </td> <td class="subdetail" nowrap="on"> <xsl:value-of select="Lot" /> </td> <td class="subdetail" nowrap="on" align="right"> <xsl:value-of select="StockQtyToShip" /> </td> <td class="subdetail" nowrap="on" align="center"> <xsl:value-of select="NewExpiryDate" /> </td> </tr> </xsl:for-each> </table> </td> </tr> </xsl:if> <!-- LOTS --> <xsl:if test="Merchandise/Lot[. !='']"> <tr style="display:none" id="lot_{generate-id()}"> <td colspan="2" /> <td colspan="5"> <table width="100%" align="left" style="border:thin solid outset"> <tr class="detailhdg2"> <td class="detailcell" nowrap="on"> Lot number </td> <td class="detailcell" nowrap="on" align="right"> Qty </td> <td class="detailcell" nowrap="on"> Certificate </td> <td class="detailcell" nowrap="on" align="center"> Expiry date </td> </tr> <xsl:for-each select="Merchandise/Lot"> <tr> <td class="subdetail" nowrap="on"> <xsl:value-of select="Lot" /> </td> <td class="subdetail" nowrap="on" align="right"> <xsl:value-of select="StockQtyToShip" /> </td> <td class="subdetail" nowrap="on"> <xsl:value-of select="Certificate" /> </td> <td class="subdetail" nowrap="on" align="center"> <xsl:value-of select="LotExpiryDate" /> </td> </tr> </xsl:for-each> </table> </td> </tr> </xsl:if> <!-- BINS --> <xsl:if test="Merchandise/Bin[. !='']"> <tr style="display:none" id="bin_{generate-id()}"> <td colspan="2" /> <td colspan="5"> <table width="100%" align="left" style="border:thin solid outset"> <tr class="detailhdg2"> <td class="detailcell" nowrap="on"> bin </td> <td class="detailcell" nowrap="on"> Lot number </td> <td class="detailcell" nowrap="on" align="right"> Quantity </td> </tr> <xsl:for-each select="Merchandise/Bin"> <tr> <td class="subdetail" nowrap="on"> <xsl:value-of select="Bin" /> </td> <td class="subdetail" nowrap="on"> <xsl:value-of select="Lot" /> </td> <td class="subdetail" nowrap="on" align="right"> <xsl:value-of select="StockQtyToShip" /> </td> </tr> </xsl:for-each> </table> </td> </tr> </xsl:if> </xsl:if> <!-- FREIGHT LINES --> <xsl:if test="Freight[. !=' ']"> <td class="orderdisplaydetailField" nowrap="on" style="text-indent:10px"> {Freight} </td> <td class="orderdisplaydetailField" nowrap="on" colspan="7"> <xsl:value-of select="Freight/NComment" /> </td> <td class="orderdisplaydetailField" nowrap="on" align="right"> <xsl:value-of select="Freight/NMscChargeValue" /> </td> <td> </td> </xsl:if> <!-- MISC CHARGE LINES --> <xsl:if test="MiscCharge[. !=' ']"> <td class="orderdisplaydetailField" nowrap="on" style="text-indent:10px"> {Misc charge} </td> <td class="orderdisplaydetailField" nowrap="on" colspan="7"> <xsl:value-of select="MiscCharge/NComment" /> </td> <td class="orderdisplaydetailField" nowrap="on" align="right"> <xsl:value-of select="MiscCharge/NMscChargeValue" /> </td> </xsl:if> <!-- COMMENT LINES --> <xsl:if test="CommentLine[. !=' ']"> <td class="orderdisplaydetailField" colspan="10" style="text-indent:10px"> <xsl:value-of select="CommentLine/NComment" /> </td> </xsl:if> </tr> </xsl:for-each> </table> </td> </tr> </table> </BODY> </HTML> </xsl:template> </xsl:stylesheet>
This document is copyrighted by Dovetail Internet Technologies, LLC., the developers of CyberStore (www.CyberStoreForSYSPRO.com).
The name SYSPRO and other information contained in this document and the application are used with the permission of SYSPRO Impact Software, Inc. (www.syspro.com) Published Tuesday, December 20, 2022