Getting the total for 1 product category

I had a party of 20 in last night and at the end of the night one of the customers wanted to pay for all the drinks. I had to scrol through the whole ticket selecting the drinks and then split them off the bill. Is there a way of either selecting all the drinks category in one go or getting the total amount for the drinks on that ticket?

I would probably want it so that when i press a button it shows or enters a ticket tag for the total for the drinks on that ticket.

I do this on my printed receipts.
I have a product/item tag which is wet/dry which relates to my PMS integration, part of this involves turning the item tag into a order state on order adding.
I then use;

<J00>Drinks:|£{TICKET ORDER TOTAL EXP:(ODI=True) AND (OS.NewBook GLA=2101)}
<J00>Food:|£{TICKET ORDER TOTAL EXP:(ODI=True) AND (OS.NewBook GLA=3101)}

ODI=True excluded voided orders.
OS.NewBook GLA is my PMS revenue code for wet and dry etc.

How would i go about doing this?

You could probably use item tags directly but to use states like I have you would have;

Product Tags;

Action;

Rule;

Printer template tags as above.

If i replaced the ticket tag with FoodDrink and the numbers 2101 with drink and 3101 with food and updated the print template :
Drinks:|£{TICKET ORDER TOTAL EXP:(ODI=True) AND (ProductTag:FoodDrink=drink)}
Food:|£{TICKET ORDER TOTAL EXP:(ODI=True) AND (ProductTag:Food/Drink=food)}

would that work?

What ticket tag??? …

Sorry, meant Product tag.

(OS.NewBook GLA=2101)}
what is the OS for?

Its part of the report expression. OS = Order State, hence the rule to turn product tag into state on order added to ticket.

You may be able to use product tag directly, my setup uses states so I showed you that, you can by all means try and use the product tag directly. You will need to see if there is a valid expression usable in TICKET ORDER TOTAL EXP for item/product tag.

1 Like

Ill try it the way you have done it and see how it goes. Thanks @JTRTech

so im using FoodDrink as the product tag

[LAYOUT]
-- General layout
<L00>
<L00>
<bmp>C:\epos pics\logo.bmp
<C00>Main Road, Dinnington, 
<C00>Newcastle Upon Tyne, NE13 7JS
<C00>www.thelastdaysoftheraj.co.uk
<C01>01661 59 8181
<C01>01661 59 8484
<L00>
<L12>Table:{ENTITY NAME:Table}
<L01>
<F>-
{ORDERS}
<F>=
<EB>
<J00>Drinks:|£{TICKET ORDER TOTAL EXP:(ODI=True) AND (OS.FoodDrink=Drink)}
<J00>Food:|£{TICKET ORDER TOTAL EXP:(ODI=True) AND (OS.FoodDrink=Food)}
{DISCOUNTS}
[<J10>Total Gift:|{ORDER STATE TOTAL:Gift}]
{SERVICES}
<J10>Total:|{TICKET TOTAL}
{PAYMENTS}
<DB>
<F>=
<F>
<C11>T H A N K   Y O U
<C00>Vat No: 214987385
<L00>
<L00>
<L00>

<C00>Like us on Facebook &
<C00> Please visit us again soon
<L01>
<L00>
<L01>


[ORDERS GROUP|PRODUCT TAG:Kitchen Group:Drink,Special,Appetiser,Starter,Main,Sides,Rice,Nan,Sundries,Beverage,Special]

[DISCOUNTS]
<J00>{CALCULATION NAME} %{CALCULATION AMOUNT}|{CALCULATION TOTAL}

[SERVICES]
<J00>{CALCULATION NAME}|{CALCULATION TOTAL}

[PAYMENTS]
<J00>{PAYMENT NAME}|{PAYMENT AMOUNT}

[ORDERS]
-- Default format for orders
<J00>- {QUANTITY} {NAME}|{TOTAL PRICE}
{ORDER TAGS}

[ORDERS:Gift]
-- Format for gifted orders
<J00>- {QUANTITY} {NAME}|**GIFT**
{ORDER TAGS}

[ORDERS:Void]
-- Nothing will print for void lines

[ORDER TAGS]
-- Format for order tags
<J00> * {ORDER TAG NAME} | {ORDER TAG PRICE}

[ENTITIES:Table]
-- Table entity format
<L00>Table: {ENTITY NAME}

[ENTITIES:Customer]
-- Customer entity format
<J00>Customer: {ENTITY NAME} | {ENTITY DATA:Phone}

all im getting on the print is

    Main Road, Dinnington,
      Newcastle Upon Tyne, NE13 7JS
      www.thelastdaysoftheraj.co.uk
              01661 59 8181
              01661 59 8484

Table:3

------------------------------------------
- 1 Bhuna Prawn on Puri               3.95
- 1 Chicken Chatt                     3.95
- 1 Chicken Tikka Main                8.95
- 1 Lamb Korai                        8.95
- 1 Nut Pilau                         2.95
- 1 Peshwari Nan                      2.75
==========================================
Drinks:                                 £-
Food:                                   £-
Total:                               31.50
==========================================
            T H A N K   Y O U
            Vat No: 214987385



          Like us on Facebook &
        Please visit us again soon

Am i doing something wrong?

Open the action in the rule so can see your settings.

You might not need to deal with states. Can you check if it works or not?

{TICKET ORDER TOTAL EXP:(ODI=True) AND (MT.FoodDrink=Drink)}
2 Likes

Thanks @emre, this works great.

What is MT for?

MT.<tag name> Order Menu Item Custom tag Equals

From Here:

:smile:

3 Likes