Help with User specific report by product tag

V5 Question
1

Hey all,

I’m hoping someone can help me solve this little problem that I have having with a report.

My goal is to have a report that breaks down a Server’s settled sales according to the Product Tag.

For example:
FOOD - $150
PIZZA - $200
BEER - $100
LIQOUR - $100

I can currently create a report that breaks down the tags according to what the Server has submitted. However, I would like the report to show what each server has settled (collected payment for.)

This is that report;

[Sales by Product Tag:1,1]
Server:|{SETTING:CURRENTUSER}
{REPORT ORDER DETAILS:M.Tag,O.TotalPrice.Sum:(OU={SETTING:CURRENTUSER})}

Replacing O.TotalPrice.Sum with O.ExactTotal.Sum seems to yield the same result.

For those wondering, this is a report that will be used to help calculate how much money in FOOD and PIZZA is collected by a server so they can tip out the kitchen staff.

Thank you in advance for any help.

2

I see that PA (ticket contains a payment) can be used as an expression with REPORT ORDER. Is there a way to include PA into the syntax?

3

try (PU={SETTING:CURRENTUSER})

4

I end up losing all numeric value in the table if I change it to PU. From my understanding, PU is supported by REPORT PAYMENT but it is not supported by REPORT ORDER