WOW , u guy’s rock
i want to say thank u very much for all this work , it work perfect
but the sales by product still don’t work and the item sales by product tag
That will be available with next update. 5.1.51 there was something he added specifically for it to work.
I think you missed an arrow.
3 Likes
btw. you can use Custom Product Tags instead. Assuming you’ll configure a custom tag named Type you can change report like that.
[Sales by Product Tags:1, 1]
{REPORT ORDER DETAILS:MT.Type,O.ExactTotal.Sum}
>Total|{REPORT ORDER DETAILS:O.ExactTotal.Sum}
wow look how you’ve placed them without covering text 
Really precise work.
3 Likes
Report with Product tag,
How to make like this
Sales item Report
Group : Food (this is product tag)
Group Code : Breakfast
Item 1 10 (sum qty) 1000(Total)
item 2
item 3
Total … 1000
Group Code : Soup
Item s1 10 (sum qty) 1000(Total)
item s2
item s3
Total … 1000
Group : Drink
Group Code : Juice
Item j1 10 (sum qty) 1000(Total)
item j2
item j3
Total … 1000
What is sum qty? Is this a report or a ticket?
yes, it report end of period, sum qty is total sales item at the day
What is total then? Isn’t that the same thing?
Total is Total Amount in price
Is it something like that?
[Sale Groups:2, 1, 1]
@{REPORT ORDER DETAILS:MT.Group,O.Quantity.Sum::{0}:,}
>>$1
{REPORT ORDER DETAILS:M.GroupCode,O.Quantity.Sum,O.ExactTotal.Sum:(MT.Group=$1)}
>Total:||{REPORT ORDER DETAILS:O.ExactTotal.Sum:(MT.Group=$1)}
1 Like
Include Ticket Type filter into report expressions as I’ve explained here.
Also don’t miss that comment.
No, Like this
Group : Food
Category : Breakfast
item Qty Amount
Toasted Bagel Jam 3 6.00
Toasted Bagel Cheese 10 20.00
…
Breakfast 13 26.00
Category : Soup
Soup and Cracker 5 15,00
Soup 5 15,00
Group Food 41,00
Group Drink
Category : Beverages
Tea 3 6.00
Iced tea 2 4.00
Beverages 10.00
Category : Juice
Orange Juice 3 9.00
Apple Juice 2 8.00
Beverages 17.00
Group Drink 27.00
Total 68.00
Category your referring to I presume is your menu allocation for the product.
What are your product group settings? This is what that report is returning.
Group is Product Tag
Product tag is Food and Drink
this is Item Sales Report
You can use pivot grids for multi level nested reporting needs.
[!Sale Groups:1,1,1,1,1:0]
>Group|Group Code|Menu Item Name|[N]Quantity|[C]Total
{REPORT ORDER DETAILS:MT.Group,M.GroupCode,O.MenuItemName,O.Quantity,O.ExactTotal}
You can read more about it here.
http://sambapos.com/wiki/doku.php/custom_report_pivot_table_views
2 Likes