How to include the Original item quantities Total on Invoices

How to include the Original item quantities Total on Invoices

How to include the Original item quantities Total on Invoices


If you automatically change the number of items orders on a website (e.g. Ebay) to a different value, but want to include the original number of items ordered on teh Invoice, Packing Slip etc.. you can use the following macro.

#!#<!>SELECT Str(Sum(TOrderLine.nOrigQty)) FROM TOrder INNER JOIN TOrderLine ON (TOrder.nOrderSeq = TOrderLine.nOrderSeq) AND (TOrder.ID = TOrderLine.ID) WHERE TOrder.nOrderSeq = [%ORD_ID%]#!#

This will create a total of all the original quantity values for each order.


    • Related Articles

    • How to include an SKU on your packing list

      The following guide explains how to include a SKU on the packing list in One Stop Order Processing. This feature is available in the Lite, Professional, Premium and Managed subscriptions of One Stop Order Processing. The packing list that you print ...

    • Can I include a gift message or additional information for each order line?

      Introduced in version 2.0.0.29 New fields have been added for additional information for each order line. Message text Each order line can now have a separate message, for example, a gift message. This is automatically imported for Amazon and Ebay ...

    • How to include sales and product totals in Picking Lists?

      You can now include totals in the footer for Picking Lists. You any of the following macros to include totals for the orders and products shown in the Picking List. [%TOTAL_LINE_ITEMS%] [%TOTAL_SALES_PRODUCT%] [%TOTAL_SALES_PRODUCT_TAX%] ...

    • Can I show the total order lines on an invoice, packing slip or picking list?

      You can now show the total number of lines in an order by using the [%TOTAL_ORDER_LINES%] macro. You can also use this value in formulas. For example, to display the word CHECK whenever a customer has ordered more than 1 item use the following macro ...

    • How to include a conditional statement into a report using Macros

      The following guide explains how to include a conditional statement in a report using Macros This feature is available in the Lite, Professional, Premium and Managed subscriptions of One Stop Order Processing. Html templates contain many macros to ...