Hi Samba great team.
Is it possible to have item sales report as it is on the computer and departmental sales report? I purchased samba v5 and it’s working like charm in 4 departments, butchery, hotel, bar and rooms.
It’s possible, you will have to create a ticket type for each department and filter report by Ticket Type.
Checkout this post
Grouping Item Sales report by ticket type might be a little tricky. This is the report you need.
[Sales:5, 2, 2,1]
@{TICKET TYPE LIST}
@{REPORT ORDER DETAILS:O.MenuItemName,O.ExactTotal.Sum.desc:(ODI=True):{0}:,}
>>Ticket Type|| $1
>{REPORT ORDER DETAILS:O.MenuItemName,O.Quantity.Sum.desc,O.ExactTotal.Sum.desc:(ODI=True) and (TY=$1) and O.MenuItemName="$2"}
{REPORT ORDER DETAILS:' '+[O.PortionName],O.Quantity.Sum.desc,O.ExactTotal.Sum.desc:(ODI=True) and (TY=$1) and O.MenuItemName="$2":2}
T…
Thanks for the reply, please note am asking about the report on metrik.
how did you set your rooms,i will be interested. You can run a departmental report if you want to see the sales in each department
Hey vits
One method is to feed the departments used into a @Parameter List and then pipe them into the {REPORT ORDER DETAILS:x} tag:
@{REPORT TICKET DETAILS:T.Department,T.TotalAmount.sum::{0}:,}
>Dept: $1
{REPORT ORDER DETAILS:O.User,O.ExactTotal.Sum:(DE=$1):{0}|${1}:}
That above is user sales per department.
I have not used tags much so no help there.
Jesse
May 29, 2021, 1:42pm
6
Thank you for clarifying that. Please try to be specific with questions otherwise it’s impossible for us to provide useful help.
Metrik reports do not sync with the reports in SambaPOS. We will improve Metrik but no eta right now as we have several projects.