Waiter Report to specify Payment manner

[stephanhenning]

I have hijacked a report from a previous post and made it a bit more expansive:

[PAYMENTS BY WAITER:6,6,3,5,4,4,4,4,4,4,4,4,6,3] Waiter|Terminal|Ticket|Date|Time|Gift.Cert|Zapper|Voucher|Account|Cash|Credit|Total|Method|Table {REPORT PAYMENT DETAILS:P.User,P.Terminal,T.TicketNumber,T.Date,T.Time,PA.Gift Certificate,PA.Zapper,PA.Voucher,PA.Customer Account,PA.Cash,PA.Credit Card,T.TotalAmount,P.Type,T.Tables}

N.B : Page size is set to 27cm

It is something that is very useful when waiter cash-up at the end of the day and their cash is wrong.

We have many ways to pay, like “zapper” is app based, just remove the PA.Zapper,PA.Voucher,PA.Customer Account to simplify the report for your needs. And remove [PAYMENTS BY WAITER:6,6,3,5,4,4,4,4,4,4,4,4,6,3] a 4 from this line for every PA.Zapper you remove

Now a little help from the community: notice my table numbers are not showing, what would be the correct wording? I used: T.Tables

[Jesse]

Tables are entities remember so naturally T.Tables won T work since they are just entities. Try TEN.Tables I think but you may want to look that tag up.

[stephanhenning]

following what is in this post:

Custom Report Tags in detail

###Expressions We’ll use expressions to filter results returned by tags. If you are familiar with SQL, you can think these as Where sections. For Example… {REPORT PAYMENT TOTAL:} This tag will display total of all payments that created inside reporting period. As it will total of all cash, credit card or other type of payments we’ll need a <expression> for more precise total. For reading a total of only Cash payments the syntax should be… {REPORT PAYMENT TOTAL:(PT=Cash)} ###Syntax (<Field>=…

"TEN.<entity type> = Ticket Entity Name Equals"

This should be our winner but it still doesn’t report Table Numbers in the report.

[Jesse]

By default it’s All Tables not just Tables try TEN.All Tables

[stephanhenning]

OK got it to work:

EN.Tables

I’ll add that my entity name is “Tables” not “Table” so keep that in mind when you copy text.

[Ollando]

@stephanhenning

[PAYMENTS BY WAITER:6,6,3,5,4,4,4,4,4,4,4,4,6,3] Waiter|Terminal|Ticket|Date|Time|Gift.Cert|Zapper|Voucher|Account|Cash|Credit|Total|Method|Table {REPORT PAYMENT DETAILS:P.User,P.Terminal,T.TicketNumber,T.Date,T.Time,PA.Gift Certificate,PA.Zapper,PA.Voucher,PA.Customer Account,PA.Cash,PA.Credit Card,T.TotalAmount,P.Type,T.Tables}

Hello Everyone, Is it posible that I can Have something that will Give Me what each waiter has made for the Whole Day and not just hourly? Thanks

[JTRTech]

Doesnt normal work period give sales and payments by user?

[Ollando]

Sure it does, But I really wanted a format like this one But should have total of the day. Okay let me try applying The codes for user sales.

[JTRTech]

That report isn’t by hour anyway, it’s individual transactions?
Use that, add .Sum to the field you want colated and take out the ticket stuff like ticket number and table etc

[Ollando]

@stephanhenning

[PAYMENTS BY WAITER:6,6,3,5,4,4,4,4,4,4,4,4,6,3] Waiter|Terminal|Ticket|Date|Time|Gift.Cert|Zapper|Voucher|Account|Cash|Credit|Total|Method|Table {REPORT PAYMENT DETAILS:P.User,P.Terminal,T.TicketNumber,T.Date,T.Time,PA.Gift Certificate,PA.Zapper,PA.Voucher,PA.Customer Account,PA.Cash,PA.Credit Card,T.TotalAmount,P.Type,T.Tables}

Thanks @JTRTech Will Do as wise.