1112
December 12, 2020, 2:40am
1
Hello everyone ,I have issue with price
and this is my template
<td colspan="2">-------------------------------------------------------------</td>
<td></td>
</tr>
<tr>
<td align=Left><span style="width:150px">ប្រាក់សរុប</span></td>
<td align=Right><div style="padding-right: 25px;">៛ [=F(TN('{PLAIN TOTAL: }'),'#,##0')]</div></td>
</tr>
<tr>
{DISCOUNTS}
<td align=Left>ប្រាក់គិតជា (៛)</td>
<td align=Right><div style="padding-right: 25px;">៛ [=F(TN('{TICKET TOTAL}'),'#,##0')]</span></div></td>
</tr>
<tr>
<td align=Left>ប្រាក់គិតជា ($)</td>
<td align=Right><div style="padding-right: 25px;">$ [=F(TN('{TICKET TOTAL}')*1/4000,'#,##0.##')] </span></div></td>
</tr>
<tr>
<td align=Left>ប្រាក់ទទួល</td>
<td align=Right><div style="padding-right: 25px;">៛ [=F(TN('{TENDERED TOTAL}'),'0.')]</div></td>
</tr>
<tr>
<td align=Left>ប្រាក់អាប់</td>
<td align=Right><div style="padding-right: 25px;">៛ [=F(TN('{CHANGE TOTAL}'),'0.')]</div></td>
</tr>
</tbody>
</table>
<div>---------------------------------------------------------------</div>
</div>
<div style="font-size:12px;font-family:' Battambang ';text-align: center;">
<div>Thank you!</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>[=F(TN('{PRICE}'),'#,##0')]</td>
<td width=50 align=center>[=F(TN('{TOTAL PRICE}'),'#,##0')]</td>
</tr>
{ORDER TAGS}
[ORDER TAGS]
-- Format for order tags
<tr>
<td width=120 align=Left>+ {ORDER TAG NAME} </td>
-- <td width=30 align=center>{QUANTITY}</td>
<td width=20 align=Right>x{ORDER TAG QUANTITY}</td>
<td width=50 align=Right>[=F(TN('{QUANTITY}')*TN('{ORDER TAG TOTAL PRICE}'),'0.00')]</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>FREE</td>
<td width=50 align=center>000</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>
Posflow
December 12, 2020, 6:23am
2
Can you copy your whole template inside and use Preformatted text
?
I cant see your format of your order template.
It must be something with your format function. What happens when you just use {PRICE}, {TOTAL PRICE}, {PLAIN TOTAL} or {TICKET TOTAL} no formatting applied. The easiest way to troubleshoot is often to simplify the issue so you can isolate the problem.
Memo
December 12, 2020, 11:11pm
4
^^ more to this, {PLAIN TOTAL}
, {TICKET TOTAL}
, etc. should already be formatted as a decimal (or a double) and TN()
isn’t required.
When I use your expressions for the printer tags it seems to round:
<L00>Plain Total: [=F(TN('{PLAIN TOTAL: }'),'#,##0')]
<L00>
<L00>Ticket Total: [=F(TN('{TICKET TOTAL}'),'#,##0')]
<L00>
<L00>Tendered Total: [=F(TN('{TENDERED TOTAL}'),'0.')]
<L00>
<L00>Change Total: [=F(TN('{CHANGE TOTAL}'),'0.')]
shows this:
whereas this
<L00>Plain Total: {PLAIN TOTAL}
<L00>
<L00>Ticket Total: {TICKET TOTAL}
<L00>
<L00>Tendered Total: {TENDERED TOTAL}
<L00>
<L00>Change Total: {CHANGE TOTAL}
shows this:
Same with your orders section:
[ORDERS]
<L00>{NAME}
<L00>{QUANTITY}
<L00>[=F(TN('{PRICE}'),'#,##0')]
<L00>[=F(TN('{TOTAL PRICE}'),'#,##0')]
[ORDERS]
{NAME}
{QUANTITY}
{PRICE}
{TOTAL PRICE}
1112
December 14, 2020, 7:58am
5
when I test database with other device it work ,but for this device doesn’t work !
1112
December 14, 2020, 8:01am
6
here my template
[LAYOUT]
-- Bill 01
<div style="font-size:12px;font-family:' Battambang ';text-align: center;">
<div style="font-size: 20px; font-weight: bold"></div>
<div></div>
<div style="font-size: 17px; font-weight: bold;margin-top: 10px">វិក្ក័យប័ត្រ</div>
<div>ទូរស័ព្ទ : 011 88 50 50 / 096 769 9988</div>
</div>
<div style="font-size:12px;font-family:' Battambang ';text-align: left;">
<div>លេខរៀង : {TICKET NO}</div>
<div>សេវាកម្ម : {USER NAME}</div>
<div>អតិថិជន : {ENTITY NAME:Customer}</div>
<div>ពេល : {TICKET DATE} {TICKET TIME}</div>
</table>
</div>
<div style="font-size:11px;font-family:' Battambang ';background: black">
<table>
<tr>
<td width=120><div style="background-color: #000;color:#fff;font-size:12px;font-weight:bold"> បរិយា </div></td>
<td width=30 align=center><div style="background-color: #000;color:#fff;font-size:12px;font-weight:bold">ចំនួន</div></td>
<td width=45 align=center><div style="background-color: #000;color:#fff;font-size:12px;font-weight:bold">តម្លៃ</div></td>
<td width=60 align=center><div style="background-color: #000;color:#fff;font-size:12px;font-weight:bold">តម្លៃសរុប</div></td>
</tr>
{ORDERS}
</table>
<div style="font-size:13px;font-family:' Battambang ';">
<table>
<tbody>
<tr>
<td colspan="2">-------------------------------------------------------------</td>
<td></td>
</tr>
<tr>
<td align=Left><span style="width:150px">ប្រាក់សរុប</span></td>
<td align=Right><div style="padding-right: 25px;">៛ [=F(TN('{PLAIN TOTAL: }'),'#,##0')]</div></td>
</tr>
<tr>
{DISCOUNTS}
<td align=Left>ប្រាក់គិតជា (៛)</td>
<td align=Right><div style="padding-right: 25px;">៛ [=F(TN('{TICKET TOTAL}'),'#,##0')]</span></div></td>
</tr>
<tr>
<td align=Left>ប្រាក់គិតជា ($)</td>
<td align=Right><div style="padding-right: 25px;">$ [=F(TN('{TICKET TOTAL}')*1/4000,'#,##0.##')] </span></div></td>
</tr>
<tr>
<td align=Left>ប្រាក់ទទួល</td>
<td align=Right><div style="padding-right: 25px;">៛ [=F(TN('{TENDERED TOTAL}'),'0.')]</div></td>
</tr>
<tr>
<td align=Left>ប្រាក់អាប់</td>
<td align=Right><div style="padding-right: 25px;">៛ [=F(TN('{CHANGE TOTAL}'),'0.')]</div></td>
</tr>
</tbody>
</table>
<div>---------------------------------------------------------------</div>
</div>
<div style="font-size:12px;font-family:' Battambang ';text-align: center;">
<div>Thank you!</div>
[ORDERS]
-- Default format for orders
<tr>
<td width=120 align=Left>{NAME}</td>
<td width=30 align=center>{QUANTITY}</td>
<td width=45 align=center>[=F(TN('{PRICE}'),'#,##0')]</td>
<td width=60 align=center>[=F(TN('{TOTAL PRICE}'),'#,##0')]</td>
</tr>
{ORDER TAGS}
[ORDER TAGS]
-- Format for order tags
<tr>
<td width=120 align=Left>+ {ORDER TAG NAME} </td>
-- <td width=30 align=center>{QUANTITY}</td>
<td width=20 align=Right>x{ORDER TAG QUANTITY}</td>
<td width=50 align=Right>[=F(TN('{QUANTITY}')*TN('{ORDER TAG TOTAL PRICE}'),'0.00')]</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=45 align=center>FREE</td>
<td width=60 align=center>000</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>
JTRTech
December 14, 2020, 8:49am
7
If its different on different devices check the regional settings for currency format in windows.
Posflow
December 14, 2020, 1:16pm
8
Here you go bong
I sorted out your [ORDERS]
,[PAYMENTS]
and totals. Have a look at how Ive organized formatting to get an idea how to sort out the rest of the template.
[LAYOUT]
-- Bill 01
<div style="font-size:12px;font-family:' Battambang ';text-align: center;">
<div style="font-size: 20px; font-weight: bold"></div>
<div></div>
<div style="font-size: 17px; font-weight: bold;margin-top: 10px">វិក្ក័យប័ត្រ</div>
<div>ទូរស័ព្ទ : 011 88 50 50 / 096 769 9988</div>
</div>
<J><F>
<div style="font-size:12px;font-family:' Battambang ';text-align: left;">
<div>លេខរៀង : {TICKET NO}</div>
<div>សេវាកម្ម : {USER NAME}</div>
<div>អតិថិជន : {ENTITY NAME:Customer}</div>
<div>ពេល : {TICKET DATE} {TICKET TIME}</div>
</div>
<J><F>
-- ---------------------------------
-- Order Headers
-- ---------------------------------
<div style="font-size:11px;font-family:' Battambang ';background: black">
<table>
<tr>
<td width=100><div style="background-color: #000;color:#fff;font-weight:bold">បរិយា</td>
<td width=30 align=center><div style="background-color: #000;color:#fff;font-weight:bold">ចំនួន</td>
<td width=65 align=center><div style="background-color: #000;color:#fff;font-weight:bold">តម្លៃ</td>
<td width=65 align=center><div style="background-color: #000;color:#fff;font-weight:bold">តម្លៃសរុប</td>
</tr>
</table>
</div>
{ORDERS}
<F>-
<J><F>
-- ---------------------------------
-- Totals
-- ---------------------------------
<div style="font-size:14px;font-family:' Battambang ';background: black">
<table>
<tr>
<td width=120><div style="background-color: #000;color:#fff;font-weight:bold">ប្រាក់គិតជា ៛</td>
<td width=140 align=center><div style=font-weight:bold">[=F(TN('{TICKET TOTAL}')-TN('{CALCULATION TOTAL:Discount}')-TN('{CALCULATION TOTAL:Round}'))]</td>
<tr>
<td width=120 ><div style="background-color: #000;color:#fff;font-weight:bold">ប្រាក់គិតជា $</td>
<td width=140 align=center><div style=font-weight:bold">[=F(TN('{TICKET TOTAL}')/4000)] $</td>
</tr>
</table>
</div>
-- ---------------------------------
-- Discount & Payments output
-- ---------------------------------
{DISCOUNTS}
{PAYMENTS}
<J><F>
<div style="font-size:12px;font-family:' Battambang ';text-align: center;">
<div>Thank you!</div>
[ORDERS]
-- Default format for orders
<div style="font-size:12px;font-family:' Battambang ';text-align: left;">
<table>
<tr>
<td width=100 align=Left>{NAME}</td>
<td width=30 align=center>{QUANTITY}</td>
<td width=65 align=center>{PRICE}</td>
<td width=65 align=center>{TOTAL PRICE}</td>
<tr>
</table>
</div>
{ORDER TAGS}
[ORDER TAGS]
-- Format for order tags
<tr>
<td width=120 align=Left>+ {ORDER TAG NAME} </td>
-- <td width=30 align=center>{QUANTITY}</td>
<td width=20 align=Right>x{ORDER TAG QUANTITY}</td>
<td width=50 align=Right>[=F(TN('{QUANTITY}')*TN('{ORDER TAG TOTAL PRICE}'),'0.00')]</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=45 align=center>FREE</td>
<td width=60 align=center>000</td>
</tr>
[ORDERS:Void]
-- Nothing will print for void lines
[ENTITIES:Table]
-- Table entity format
<L00>Table: {ENTITY NAME}
[PAYMENTS]
<div style="font-size:14px;font-family:' Battambang ';background: black">
<table>
<tr>
<td width=120><div style="background-color: #000;color:#fff;font-weight:bold">ប្រាក់ទទួល</td>
<td width=140 align=center><div style=font-weight:bold">{TENDERED}</td>
<tr>
<td width=120 ><div style="background-color: #000;color:#fff;font-weight:bold">ប្រាក់អាប់</td>
<td width=140 align=center><div style=font-weight:bold">{CHANGE}</td>
</tr>
</table>
</div>
[DISCOUNTS]
<div style="font-size:14px;font-family:' Battambang ';background: black">
<table>
<tr>
<td width=120 align=Left>{CALCULATION NAME} ({CALCULATION AMOUNT}%)</td>
<td width=140 align=center><div style=font-weight:bold">{CALCULATION TOTAL}</td>
<tr>
</table>
</div>
1 Like
RickH
December 18, 2020, 4:42pm
10
you’ll need to post the templates for both printouts so we can see whats missing
[LAYOUT]
-- General layout
<div style="margin:0 0 5 0;border:1 1 1 1;border-color:black">
<div style="text-align:center;font-size:24;font-weight:bold;margin:5 0 5 0;border:0 0 1 0;border-color:black">
HOLLYWOOD<br/>RESTAURANT
</div>
-- <div style="text-align:center;font-size:14;font-weight:bold;margin:0 0 5 0;border:0 0 1 0;border-color:black">
-- Samba Cafe<br/>Istanbul
-- </div>
<div style="font-weight:bold;margin:0 0 5 5; font-size:14">
<div align=left>Tarix: {TICKET DATE}</div>
<div>Saat: {TIME}</div>
<div>Personal: {USER NAME}</div>
{ENTITIES}
<div style="margin:0 0 0 0">Çek №: {TICKET NO}</div>
</div>
</div>
<table width=200 style="border:1 1 1 1;margin:2 0 5 0;border-color:black;font-size:14; padding:5 0 5 2">
{ORDERS}
</table>
<div style="font-weight:bold;margin:0 0 5 0;padding:5 0 5 0;border:1 1 1 1;border-color:black;font-size:14">
[<table >
<tr>
<td width="14*" align=right>Toplam:</td><td width="6*" align=right>{PLAIN TOTAL} AZN</td>
</tr>
-- <tr>
-- <td width="14*" align=right>Ara Toplam</td><td width="6*" align=right>[[={TICKET ORDER TOTAL EXP:(ODI=True)}!={TICKET TOTAL}?'{TICKET ORDER TOTAL EXP:(ODI=True)}':'']]</td>
-- </tr>
</table>]
{DISCOUNTS}
[<table>
<tr>
<td width="14*" align=right>Toplam İkram</td><td width="6*" align=right>-{ORDER STATE TOTAL:Gift}</td>
</tr>
</table>]
{SERVICES}
[<table>
<tr>
<td width="14*" align=right>Yekun Hesab:</td><td width="6*" align=right>{TICKET TOTAL} AZN</td>
</tr>
<tr>
<td width="14*" align=right>Ödəniş:</td><td width="6*" align=right>[[={PAYMENT TOTAL}>0?'{PAYMENT TOTAL}':'']] AZN</td>
</tr>
</table>]
<table style="font-size:16; border:1 0 0 0;border-color:black;margin:5 0 5 0">
<tr>
<td width="12*" align=right>Ödəniləcək Hesab:</td><td width="5*" align=right>{REMAINING TOTAL} AZN</td>
</tr>
</table>
<div align=center style="border:1 0 0 0;border-color:black;padding:15 0 5 0">[={PAYMENT TOTAL}>0?'PAYMENTS':'']</div>
<table>
{PAYMENTS}
</table>
</div>
<br/>
<div align=center style="font-size:12; font-weight:bold">Ünvan: Bakı ş, Azadlıq pr. 20</div>
<br/>
<div align=center style="font-size:12; font-weight:bold">Tel: +994 51 000 00 00</div>
<br/>
<div align=center style="font-size:18; font-weight:bold">T Ə Ş Ş Ə K Ü R E D İ R İ K</div>
<br/>
[DISCOUNTS]
<table>
<tr>
<td width="14*" align=right>{CALCULATION NAME} %{CALCULATION AMOUNT}:</td>
<td width="6*" align=right>{CALCULATION TOTAL} AZN</td>
</tr>
</table>
[SERVICES]
<table>
<tr>
<td width="14*" align=right>{CALCULATION NAME}:</td>
<td width="6*" align=right>{CALCULATION TOTAL} AZN</td>
</tr>
</table>
[PAYMENTS]
<tr>
<td width="14*">{PAYMENT NAME}:</td>
<td width="6*" align=right>{PAYMENT AMOUNT} AZN</td>
</tr>
[ORDERS]
-- Default format for orders
<tr>
<td width="14*">{NAME}</td>
<td width="2*" align=right>{QUANTITY} </td>
<td width="5*" align=right>{PRICE} </td>
<td width="4*" align=right>{TOTAL AMOUNT}</td>
</tr>
<tr>
<td colspan=3>
{ORDER TAGS}
</td>
</tr>
[ORDERS:İkram]
-- Format for gifted orders
<tr>
<td width="14*">{NAME} (İkram)</td>
<td width="2*" align=right>{QUANTITY} </td>
<td width="5*" align=right>{PRICE} </td>
<td width="4*" align=right>{TOTAL AMOUNT}</td>
</tr>
<tr>
<td colspan=3>
{ORDER TAGS}
</td>
</tr>
[ORDERS:İade]
-- Nothing will print for void lines
[ORDER TAGS]
-- Format for order tags
<div style="padding:0 0 0 30">* [={ORDER TAG QUANTITY}>1?'{ORDER TAG QUANTITY} X ':'']{ORDER TAG NAME} [({ORDER TAG TOTAL PRICE})]</div>
[ENTITIES:Masa]
-- Table entity format
<div>Masa: {ENTITY NAME}</div>
[ENTITIES:Müşteri]
-- Customer entity format
<div>Müştəri: {ENTITY NAME} {ENTITY DATA:Phone}</div>