Custom sales report

V5 Question
1

I put both food and alcohol menu items together but i want the a custom report to show them diffrently.
Either by menu item or group.
Kindly Help

samba image for report
samba image for report699×330 10.4 KB

2

Try the search… posted a grouped item sales report a while back. Note however it does have a bug if you use comma or special characters in names.

3

Use item tags and use {REPORT ORDER DETAILS:M.Tag,O.ExactTotal.sum}

4

Hello,

I have put both bar and restaurant items in the same menu but i want the sales report to show them separately with separete totals too.
Possibly to have 2 sales reports BAR and RESTAURANT.

thanks

5

Or is there a way i can specify on the code which menu name or group to display on a report?

6

how kindly clarify.
Thanks

7

Not by menu group but by product group or menu item tag.
As shown above and mentioned try searching…

8 
@Breakfast,Deserts,Wraps,Whisky,Vodka
@{REPORT ORDER DETAILS:O.MenuItemName,O.ExactTotal.Sum.desc:(ODI=True):{0}:|}


[$1 Sales:8, 2, 2,2,2]
>{REPORT ORDER DETAILS:O.MenuItemName,O.Quantity.Sum.desc,O.ExactTotal.Sum.desc:(ODI=True) and O.MenuItemName="$2" and (MG=$1)}
{REPORT ORDER DETAILS:'        '+[O.PortionName],O.Quantity.Sum.desc,O.ExactTotal.Sum.desc:(ODI=True) and O.MenuItemName="$2" and (MG=$1) and O.PortionName!="Normal"}
>>Total $1|{REPORT ORDER DETAILS:O.Quantity.Sum,O.ExactTotal.Sum:(ODI=True) and (MG=$1)}

>Total|{REPORT ORDER DETAILS:O.ExactTotal.Sum:(ODI=True) and (MG=Breakfast) OR (MG=Deserts) OR (MG=Wraps) OR (MG=Whisky) OR (MG=Vodka)}
9

The above by @muthoga worked for me but it does not give the cummulative total.

10

I think that came from a report I put together…

By cumulative you mean the last line?

Works for me HOWEVER I’m pretty sure that last line will not work as expected.
Pretty sure what you want is something like this;

>Total|{REPORT ORDER DETAILS:O.ExactTotal.Sum:(ODI=True) and ((MG=Breakfast) OR (MG=Deserts) OR (MG=Wraps) OR (MG=Whisky) OR (MG=Vodka))}

Notice the extra brackets. other wise it would be
ODI=True AND Breakfast
OR Dessert
OR Wraps
etc
ie. it would include voided (ODI=False) desserts etc onwards.

But other than that works for me…
image

Although dont have any bottles or breakfast sales today.

11

Thanks. I have added the brackets.

12

How can i meke the last line work?

13

It works for me…