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 ...

    • 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 print your invoices in product order

      If you want to print your orders in product order, this can be done by making sure that the field that you want to order the orders by is included in the view, for products, this may be 'Item Title'. ""SKU"" or ""Item ID"" fields. You will then be ...

    • 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%] ...