Adding TotalVolume and TotalMass into SHC_OrderHeader, ORD_OrderHeader and ARC_OrderHeader with trigger on SHC_OrderDetail that sums them up for all items in the cart on insert, update and delete queries

Change 1 for Calculating Total Volume and Total Mass for Cart and Orders:

From 2.18.4.8701

•  <xsl:param name="CustRequestDate" /> <xsl:param name="OrderDate" /> <xsl:param name="RequestedShipDate" /> <xsl:param name="InvoiceDateEntered" /> <xsl:param name="Discount1" /> <xsl:param name="Discount2" /> <xsl:param name="Discount3" /> <xsl:param name="MiscTax" /> <xsl:param name="TaxShipping" /> <xsl:param name="ShippingCost" />

Changes in 2.19.1.9625:

• <xsl:param name="CustRequestDate" /> <xsl:param name="OrderDate" /> <xsl:param name="RequestedShipDate" /> <xsl:param name="InvoiceDateEntered" /> <xsl:param name="Discount1" /> <xsl:param name="Discount2" /> <xsl:param name="Discount3" /> <xsl:param name="MiscTax" /> <xsl:param name="TaxShipping" /> 

     <xsl:param name="FSTTaxShipping" /> 

      <xsl:param name="ShippingCost" />

Change 2:

From 2.18.4.8701:

•  <xsl:template name="Freight"> <xsl:if test="$ShippingCost!=''"> <FreightLine> <NMscChargeValue> <xsl:value-of select="format-number($ShippingCost,'0.00###')" /> </NMscChargeValue>  <NMscTaxCode></NMscTaxCode> <NMscFstCode></NMscFstCode>

Changes in 2.19.1.9625:

•  <xsl:template name="Freight"> <xsl:if test="$ShippingCost!=''"> <FreightLine> <NMscChargeValue> <xsl:value-of select="format-number($ShippingCost,'0.00###')" /> </NMscChargeValue>

<xsl:if test="$TaxShipping != 'Y'"> <NMscTaxCode></NMscTaxCode>

          </xsl:if> <xsl:if test="$FSTTaxShipping != 'Y'"> <NMscFstCode></NMscFstCode>

          </xsl:if>