Advanced Report features
How to show custom order values in my Picking List or Sales Report?
Introduced in version 2.0.0.32 You can now show the custom entered order values on the Picking List or Sales Report by using the following macros: [%CUSTOM_ENTERED1%] [%CUSTOM_ENTERED2%] [%CUSTOM_ENTERED3%] [%CUSTOM_ENTERED4%] [%CUSTOM_ENTERED5%] ...
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 change the information displayed on invoices depending on the site that is used
The following guide explains how to change the information displayed on invoices depending on the site that is used. This feature is available in the Lite,Professional, Premium and Managed subscriptions of One Stop Order Processing. In One Stop Order ...
Display word ALERT if the company name is more than 20 characters
You can set the default value of a field to the following to display the word ALERT if it is more than 20 characters. !!![$][20][30]#[=]#[][ALERT] If you still want to display the field being tested you should use the custom fixed value and set the ...
How to create a macro for an invoice that uses a combination of ANDs and ORs
You can use multiple value tests in a macro (on the screen or in an invoice/packing slip etc.). The following example shows how this can be done. if you want to display the text NO VAT TO PAY If someone pays in US dollars AND the shipping cost is ...
When using the Find Macro how do I find the position (location) of a word within the text?
It can be useful to find the location of a word or character within other text when using macros. To do this put a ? in both the returned values for the macro. For example, if you want to find the location of a word with a sentence use the following: ...
How to search for different values using macros
You may want to have a macro (in a view, email or invoice) that tests for more than one value before generating an outcome. For example, if you want to provide a specific courier for all postcodes except certain specified area codes. This may be ...
"How to use ANDs and ORs when displaying values"
There isn't a direct representation of AND or OR. However, this can be achieved in different ways. For example, To use an OR To see if a postage type is first class or expedited you can use the following #Expedited#first class#[?][%Shipping ...
How to edit reports to highlight orders with different invoice and delivery addresses
How to you set a specific logo for each of your selling channels If you amend the invoice in notepad (or any other editor) and change the text [%INV_ADD%] to #!#[%INV_POSTCODE%]X[=][%DEL_POSTCODE%]X[][<font ...
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 ...
How do I change size of product images printed on an invoice?
The following guide explains how to change the size of your product images printed on an invoice in One Stop Order Processing. This feature is available in the Lite,Professional, Premium and Managed subscriptions of One Stop Order Processing. If you ...