Don't show the price

1112 · December 13, 2020, 1:30am

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

Can you copy your whole template inside and use Preformatted text?

I cant see your format of your order template.

josephrussell · December 12, 2020, 10:29pm

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:12pm

^^ 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:
2020-12-12_17;04_1607814283_Samba.Presentation

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:
2020-12-12_17;04_1607814294_Samba.Presentation

Same with your orders section:

[ORDERS]
<L00>{NAME}
<L00>{QUANTITY}
<L00>[=F(TN('{PRICE}'),'#,##0')]
<L00>[=F(TN('{TOTAL PRICE}'),'#,##0')]

2020-12-12_17;09_1607814588_Samba.Presentation

[ORDERS]
{NAME}
{QUANTITY}
{PRICE}
{TOTAL PRICE}

2020-12-12_17;10_1607814623_Samba.Presentation

1112 · December 14, 2020, 7:58am

when I test database with other device it work ,but for this device doesn’t work !

1112 · December 14, 2020, 8:01am

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

If its different on different devices check the regional settings for currency format in windows.

Posflow · December 14, 2020, 1:19pm

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>

1112 · December 17, 2020, 1:39am

show only one price

RickH · December 18, 2020, 4:42pm

you’ll need to post the templates for both printouts so we can see whats missing

gadimovilgar · January 3, 2021, 9:13pm

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