Help with Report for Item Sales grouped by Menu item Group but with portion breakdown

V5 Question
61

HI team,at last i managed to get this report,it works fine but the only Problem is when i add more items.I want a particular group of people to view a report of what have been sold in their respective department.
Example Bar section,i don’t want them to view what has been sold on the kitchen department
My biggest problem is when i add more items to be grouped on the above sale report,this tag dont give the cumulative total of the selected items.Kindly assist

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

Kindly help with the cummulative total??

63

Show what you have…

64 
@MAIN FISH,MAIN GOAT,MAIN KUKU,ACCOMPANIMENTS,MAIN VEG,WARM DRINKS
@{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=MAIN FISH) OR (MG=MAIN GOAT) OR (MG=MAIN KUKU) OR (MG=ACCOMPANIMENTS) (MG=MAIN VEG) OR (MG=WARM DRINKS)}
65

Why not just

Total|{REPORT ORDER DETAILS:O.ExactTotal.Sum:(ODI=True)}

1 Like
66

See reply to your other post.

@Posflow because his groups arent dynamic that would likely give an incorect figure if a group exists thats not listed.

67

I see. But from what I understood in the other post he wanted to split into Restaurant & Bar not group codes.

68

Al just make 2 separate repoprts one for Bar and the Other for Restaurant.
The do the addition manually.

69

What other option is availlable?

70

You the Product Tags and use the script I sent you before.

71

Are you using separate departments for Bar and Restaurant?

72

I Need to Create a Report Anyone can help me
Example:
Sp01

1st Line: Product Name
2nd Line: Portion Name, Sale Quantity & Toatal Sale

73

Try https://kb.sambapos.com and scroll down to reports section.

74

Jesse Thanks For Your Reply I Try But I can’t Creat Report

@{REPORT ORDER DETAILS:MT.Product Sales Categories,O.ExactTotal.Sum::{0}:,}
@{REPORT ORDER DETAILS:O.MenuItemName,O.ExactTotal.Sum.desc,O.Quantity.Sum:(ODI=True):{0}:,}
[$1 Sales:3, 2, 2, 3]
>{REPORT ORDER DETAILS:O.MenuItemName,OS.NewBook GLA,O.Quantity.Sum.desc,O.ExactTotal.Sum.desc:(ODI=True) and O.MenuItemName="$2" and (MT.Product Sales Categories=$1)}
{REPORT ORDER DETAILS:'        '+[O.PortionName],O.Quantity.Sum.desc,O.ExactTotal.Sum.desc,'':(ODI=True) and O.MenuItemName="$2" and (MT.Product Sales Categories=$1) and O.PortionName!="Normal"}

Sp

75

Sp03

This is The Final Out Put I need

76

Done :smiley:

@{REPORT ORDER DETAILS:MT.Product Sales Categories,O.ExactTotal.Sum:(MT.Product Sales Categories=Bar):{0}:,}
@{REPORT ORDER DETAILS:O.MenuItemName,O.ExactTotal.Sum.desc,O.Quantity.Sum:(ODI=True):{0}:,}
[$1 Sales:3, 2, 2, 3]
{REPORT ORDER DETAILS:O.MenuItemName.desc,’ ‘:(ODI=True) and O.MenuItemName=“$2” and (MT.Product Sales Categories=$1)}
{REPORT ORDER DETAILS:[O.PortionName],O.Quantity.Sum.desc,O.ExactTotal.Sum.desc,’':(ODI=True) and O.MenuItemName=“$2” and (MT.Product Sales Categories=$1)}

3 Likes
77

Great job! Reports always were tedious but I loved it once I finally got one right.

1 Like