Monthly and Daily Report

V5 Question
1

Hello Everyone Good Morning
i have face of report little Bit Problem
image

Now I make Report For Daily Report For shop. They don’t want like this Because
if too much item sell different to see it. if same item sell same portion they want to add Quantity
not showing one by one line whatever if sell per day they sell same item they want to add Quantity
Also i have problem Topping is showing -600 i dont know why it show ( - ) but Exact Total is correct.
I will Show My Report Code
image
THis The Code I search From Forum

Now Customer Want Me To Do Like This

image
image.png1221×501 13.4 KB

Day By Day Report IF Item Sell Medium it will go to M in (1) sell 2 more it will like (3) please Help me to figure out how to write Code. or we cannot get like this it ok. can u tell me which is best situation for this report problem

2

You might struggle with that layout.
Take a look at my grouped item sales report for a posible alternative.

Your getting a negative for the topping value because your sum is backwards…
Price * Qty - Total…
For what your teying to show you want
Total - Price * Qty

3

yes boss i do what u mention on it i got report
i want to export in excel so it coming like that

image
image.png1366×768 73.4 KB

How am i do like column by column FOr Menu Name, Portion, Quantity , Total

4 
@{REPORT ORDER DETAILS:O.ItemGroup.asc,O.ExactTotal.Sum::{0}:,}
Menu|Portion|Quantity|Total Amount
@{REPORT ORDER DETAILS:O.MenuItemId,O.ExactTotal.Sum.desc:(ODI=True) and (MG=$1):{0}:,}
[$1 Sales:8, 2, 2]

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

[Item Sales:8, 2, 2, 2]
{REPORT ORDER DETAILS:O.ItemGroup,O.ExactTotal.Percent,O.Quantity.Sum,O.ExactTotal.Sum}
>>Total Sales||{REPORT ORDER DETAILS:O.ExactTotal.Sum}

i put this code in at i show very nice i like it but i like to add Order Tag My (Topping) Also in total Amount

5

Hi Brother i saw your Order Group that is very nice
But can u give me advice for report that i want .
example, this my menu
Category Coffee there is
Black Coffee etc.
Black Coffee Have portion
Small Medium Hot i have. also there is menu let
i want to show all menu in report like this
Black coffee
Small
Medium
Hot
If today i sell small it will show sell quantity and amount
if i don’t sell Medium it will show ‘0’
Like This
Black Coffee
Small 1
Medium 0
Hot 0
it will show to all menu that i have in shop. like group order report
how can i do that please reply me please

6

Hello Brother Please Help @JTRT

i Brother i saw your Order Group that is very nice
But can u give me advice for report that i want .
example, this my menu
Category Coffee there is
Black Coffee etc.
Black Coffee Have portion
Small Medium Hot i have. also there is menu let
i want to show all menu in report like this
Black coffee
Small
Medium
Hot
If today i sell small it will show sell quantity and amount
if i don’t sell Medium it will show '0’

Like This
Black Coffee
Small 1
Medium 0
Hot 0
it will show to all menu that i have in shop. like group order report
how can i do that please