HTML Print Template - Change Unit cost and total cost to include the discount

V5 Question
1

Hi,

Is anyone able to help me with my Print Bill template.

I have mainly built it with HTML and I need the bill to remove the set discount amount from my unit cost and total cost.

How do I make it do this automatically. Please see the snippet of code in use now:

[ORDERS]
– Default format for orders
<table style=“width:100%”>
<tr>
<td width=60>{QUANTITY}</td>
<td width=500>{NAME}</td>
<td align=right width=60>{PRICE}</td>
<td align=right width=auto>{TOTAL PRICE}</td>
</tr>
</table>"

Thank you in advance

2

Has anyone got any idea how you deduct discount percentage from {PRICE} and {TOTAL PRICE}

I need it to be percentage as other wise it will deduct the full discount amount from both prices. Which is not what I require.

The Price is for unit price which I want to display the discounted rate and the total price is the discounted unit price x quantity.

Any help would be great.

thank you

3

Have you tried {VISIBLE PRICE} & {VISIBLE TOTAL}?

4

Hi Bob,

Thank you for your response.

I have just tried that and the it still shows the orginal price. The discount can be added manually so I need it to adjust to the percentage of the discount

thanks again :slight_smile:

5

How are you doing discounts, via Ticket Calculations or Order Tags?

6

I am doing discounts via ticket calculations.

7

Then the only way to do this is to use {REPORT ORDER DETAILS:O.ExactTotal:T.Id={TICKET ID}}. The reason to this is because Ticket Calculation is not an Order property.

O.ExactTotal will give you the value of the order with all calculations included (taxes, service charges, discounts, etc.)

8

Thank you for the sugguestion.

It isnt exactly what I need as I dont want to report the exact total as such.

image
image841×288 8.95 KB

The bits I have highlighted are the prices I need changed on my invoice. They need to deduct the discount percentage on the ticket. otherwise it makes the whole invoice complicated.

We dont want to display the discount value to the customer just the prices to amend to them

thank you :slight_smile:

9

Your using ticket calculation not order discounts. It’s only for entire ticket.

10

So I should change across to order discounts and then that will help fix my issue?

If so I will need to look into that further and readjust the system.

11

If you want to use Ticket Calculations, you will need to use O.ExactTotal from the report tags. Thats the only way to effectively get values that include all ticket calculations & taxes on per order basis.

For example, you have 2 orders with total bill value at 10$, VAT is 10%. O.ExactTotal will return you order values as $5.5.

In same sense, it will account for discounts, rounds etc.