Hello everyone, Could anyone help me, I want to show Total Amount on bill before we discount with order tag. please kindly see on picture below Thanks!
Try using {PLAIN TOTAL}
Don’t think plain total will work if thats an order tag for discount
Plain total is before calculations and taxes no?
Can you share more of your setup and that template so can see where numbers are coming from?
Guessing you would need to do something like
Subtotal + order tags total:discount 10%*-1
[LAYOUT]
-- Bill 01
<div style="font-size:12px;font-family:Calibri;text-align: center;">
<div style="font-size: 20px; font-weight: bold">Orange Solutions</div>
<div>#31B st. 598, Khan ToulKork</div>
<div>Tel:095 00 88 99</div>
<div style="font-size: 15px; font-weight: bold;margin-top: 10px">RECEIPT</div>
</div>
<div style="font-size:12px;font-family:Calibri;text-align: left;">
<div>Ticket No: {TICKET NO}</div>
{ENTITIES}
<div>Cashier: {USER NAME}</div>
<div>Date: {TICKET DATE} {TICKET TIME}</div>
</table>
</div>
<div style="font-size:11px;font-family:Calibri;background: black">
<table>
<tr>
<td width=120><div style="background-color: #000;color:#fff;font-size:14px;font-weight:bold">Description</div></td>
<td width=30 align=center><div style="background-color: #000;color:#fff;font-size:14px;font-weight:bold">Qty</div></td>
<td width=40 align=center><div style="background-color: #000;color:#fff;font-size:14px;font-weight:bold">Price</div></td>
<td width=50 align=center><div style="background-color: #000;color:#fff;font-size:14px;font-weight:bold">Amt</div></td>
</tr>
{ORDERS}
</table>
<div style="font-size:13px;">
<table>
<tbody>
<tr>
<td colspan="2">-------------------------------------------------------------</td>
<td></td>
</tr>
<tr>
<td align=Left><span style="width:150px">Sub-Total </span></td>
<td align=Right><div style="padding-right: 25px;">$ {PLAIN TOTAL: }</div></td>
</tr>
<tr>
<td align=Left><span style="width:150px">Discount </span></td>
<td align=Right><div style="padding-right: 25px;">$ {ORDER TAG TOTAL:Discount}</div></td>
</tr>
<tr>
{DISCOUNTS}
<td align=Left>TOTAL(USD)</td>
<td align=Right><div style="padding-right: 25px;">$ <span style="float:right; background-color: #000;color:#fff;font-weight:bold">{TICKET TOTAL}</span></div></td>
</tr>
<tr>
<td align=Left>TOTAL (RIEL)</td>
<td align=Right><div style="padding-right: 25px;"><span style="background-color: #000;color:#fff;font-weight:bold">R [=F(TN('{TICKET TOTAL}')*4000,'#,##0.##')] </span></div></td>
</tr>
<tr>
<td align=Left>Recieved</td>
<td align=Right><div style="padding-right: 25px;">{TENDERED TOTAL}</div></td>
</tr>
<tr>
<td align=Left>Change</td>
<td align=Right><div style="padding-right: 25px;">{CHANGE TOTAL}</div></td>
</tr>
</tbody>
</table>
<div>---------------------------------------------------------------</div>
</div>
<div style="font-size:12px;font-family:Calibri;text-align: center;">
<div>Thank you!</div>
<div>POWER BY: ORANGE SOLUTION!!</div>
[ORDERS]
-- Default format for orders
<tr>
<td width=120 align=Left>{NAME}</td>
<td width=30 align=center>{QUANTITY}</td>
<td width=40 align=center>{PRICE}</td>
<td width=50 align=center>{TOTAL PRICE}</td>
</tr>
{ORDER TAGS}
[ORDER TAGS]
-- Format for order tags
<tr>
<td width=120 align=Left>Discount *{ORDER TAG NAME} </td>
-- <td width=30 align=center>{QUANTITY}</td>
<td width=40 align=center> {ORDER TAG PRICE}</td>
</tr>
{ORDER TAG TOTAL:Discount}
[ORDERS:Gift]
-- Format for free orders
<tr>
<td width=120 align=Left>{NAME}</td>
<td width=30 align=center>{QUANTITY}</td>
<td width=40 align=center>{PRICE}</td>
<td width=50 align=center>FREE</td>
</tr>
[ORDERS:Void]
-- Nothing will print for void lines
[ENTITIES:Table]
-- Table entity format
<L00>Table: {ENTITY NAME}
[PAYMENTS]
<tr>
<td align=Right>{PAYMENT NAME}: {PAYMENT AMOUNT}</td>
</tr>
[DISCOUNTS]
<tr>
<td width=200 align=Left>{CALCULATION NAME} ({CALCULATION AMOUNT}%)</td>
<td align=Right width=50><div style="padding-right: 25px;">{CALCULATION TOTAL}</div></td>
</tr>
this is my bill Template please kindly check thanks!
Something like this
[=FF(TN('{PLAIN TOTAL}')-TN('{ORDER TAG TOTAL:Discount}'),'#.##')]
Or
[=FF(TN('{PLAIN TOTAL}')+(TN('{ORDER TAG TOTAL:Discount}')*-1),'#.##')]
2 Likes
FYI when pasting code to forum you need to highlight the code and click the </> button else forum strips allot of the formatting stuff which makes it hard to follow.
1 Like
This is what gives me my subtotal
£[=F(TN('{TICKET TOTAL}')+TN('{ORDER TAG TOTAL:Discount Item Custom Value}')*-1+TN('{ORDER TAG TOTAL:Discount Item Custom Percent}')*-1+TN('{ORDER TAG TOTAL:Price Override}')*-1+TN('{ORDER TAG TOTAL:Promotion}')*-1+TN('{CALCULATION TOTAL:Discount Ticket Total Percent}')*-1+TN('{CALCULATION TOTAL:Staff Discount}')*-1+TN('{CALCULATION TOTAL:Manager Discount}')*-1+TN('{CALCULATION TOTAL:Loyalty Discount}')*-1,'0.00')]
It includes a mixture of order tags and calculations to get the sub total amount, amend to whatever your tag and calculation names are
1 Like
I did say something like 
Looking at ricks
Change to single F and change hashes to 0s
2 Likes
Could you help me to edit code on my bill template ? because I change it did not show anything plsease… 
Try this:
[=F(TN('{TICKET TOTAL}')+TN('{ORDER TAG TOTAL:Discount}')*-1,'0.00')]
1 Like
it work thanks you so much