Hi Guys, Need help here. I bought the lisence & moved to V5 yesterday. I just realized that the default WORK PERIOD report & ITEM SALES report is a bit different than the default report from V4 on V5’s WORK PERIOD REPORT i couldn’t see the (SETTLED BY USER) report like V4 used to have. Example o…

Yeah that was close :slight_smile: Can you try this one? [User Sales:1, 1] {REPORT ORDER DETAILS:O.User,O.ExactTotal.Sum} @{REPORT PAYMENT DETAILS:P.User,P.Amount.Sum::{0}:,} [Settled by $1:1, 1, 1] {REPORT PAYMENT DETAILS:P.Name,P.Amount.Percent,P.Amount.Sum:(PU=$1)} >Total Income|{REPORT PAYM…

Default user report is here. [image] User Sales by Payment Type V5 Question [User Sales:1, 1] {REPORT ORDER DETAILS:O.User,O.ExactTotal.Sum} @{REPORT PAYMENT DETAILS:P.User,P.Amount.Sum::{0}:,} [Settled by $1:1, 1, 1] {REPORT PAYMENT DETAILS:P.Name,P.Amount.Percent,P.A…

I think changing last part of the report like that will do the job. [Sales:2, 1, 1] {REPORT ORDER DETAILS:O.Description,O.Quantity.Sum.desc,O.ExactTotal.Sum.desc:(ODI=True)} I’ve changed O.MenuItemName with O.Description.

Dear @emre , The default work period report works great, Thanks! On the other hand, [Sales:2, 1, 1] {REPORT ORDER DETAILS:O.Description,O.Quantity.Sum.desc,O.ExactTotal.Sum.desc:(ODI=True)} This USER SALES REPORT code works as well, but it creates different style of reports. This is preview o…

Is it close to what you want? [Sales:5, 2, 2,1] @{REPORT ORDER DETAILS:O.MenuItemName,O.ExactTotal.Sum.desc:(ODI=True):{0}:,} >{REPORT ORDER DETAILS:O.MenuItemName,O.Quantity.Sum.desc,O.ExactTotal.Sum.desc,O.PortionName.dcount:(ODI=True) and O.MenuItemName="$1":{0}|{1}|{2}::$4>1} {REPORT ORDER DETA…

Dear @emre I found another weird issues. I use this code from Kendash that you gave me for the settled by user report. [User Sales:1, 1] {REPORT ORDER DETAILS:O.User,O.ExactTotal.Sum} @{REPORT PAYMENT DETAILS:P.User,P.Amount.Sum::{0}:,} [Settled by $1:1, 1, 1] {REPORT PAYMENT DETAILS:P.Name,P.Am…

It looks like its only Cash Payment Type thats messed up. So we need to find out why.

[image] kelvin: On the other hand, This one works great. The V4’s version report is more cleaner, but this one works functionally well. Version 4 was not coded the same it was Hard Coded reports. So he cannot just provide Report Code for it. The report Syntax we are using in Version 5 didnt…

One thing I spot is the User Sales are the same between both reports. Settled By is different for Cash. So I am wondering if its showing original creator of ticket and not the user that settled. I will look at it closer and let you know what I find.

This is not related but it kind of is. I find it odd that people used version 4 and constantly complained because they could not change the reports and wanted something different. Version 5 it seems people want the old reports and now that they have ability to change them they are reluctant and wa…

@emre I see what has happened here. There is a mistake with the report. Its showing Settled by whoever created the ticket. So I tried changing it as follows: [User Sales:1, 1] {REPORT ORDER DETAILS:O.User,O.ExactTotal.Sum} @{REPORT PAYMENT DETAILS:P.User::{0}:,} [Settled by $1:1, 1, 1] {REPORT P…

Different default report on v4 & v5