Can someone please help with the following report. I will compensate for your time using Paypal or any other method of payment. I think this report should help other people as well.
Thank you very much and happy New Year!!!
@na1978
Something like this?
Yes, your report is exactly what I was looking for.
As far as user: Does it pull currently logged user only or does it displays all users.
Best regard and thank you in advance.
It shows the user that close the ticket
I can prepare and send it to you
Do you have database tools module?
Great. Thank you. I do have Database tools installed.
@pizzaeilat4 it would benefit the community if you could share the syntax you used.
Yes, of course
[transactions Details:3,2,2,2,2,2,2]
>Number|Date|Time|User|Total|Payment Type
{REPORT PAYMENT DETAILS:T.TicketNumber,T.Date,T.Time,T.User,TN.TotalAmount,P.Type:(TS.Status=Paid) AND (TY=Ticket) AND (TU={SETTING:CURRENTUSER})}
>CASH:|{ACCOUNT TOTAL:cash}
>CREDIT CARD:|{ACCOUNT TOTAL:credit card}
>TOTAL:|{ACCOUNT TOTAL:Payment Accounts}
5 Likes
@na1978
I updated the Templet for the report So It displays only the current user Sales As requested by you
[transactions Details:3,2,2,2,2,2,2]
>Number|Date|Time|User|Total|Payment Type
{REPORT PAYMENT DETAILS:T.TicketNumber,T.Date,T.Time,T.User,TN.TotalAmount,P.Type:(TS.Status=Paid) AND (TY=Ticket) AND (TU={SETTING:CURRENTUSER})}
>CASH:|{ACCOUNT TOTAL:cash}
>CREDIT CARD:|{ACCOUNT TOTAL:credit card}
>TOTAL:|{ACCOUNT TOTAL:Payment Accounts}
2 Likes
Thank you. It is working now. I need the Cash, Credit Cards Total from CurrentUser. The servers are collecting payments and I will use this report collect payments from servers.
Ok @na1978 I’ll check that
@na1978 All from current user now
[transactions Details:3,2,2,2,2,2,2]
>Number|Date|Time|User|Total|Payment Type
{REPORT PAYMENT DETAILS:T.TicketNumber,T.Date,T.Time,T.User,TN.TotalAmount,P.Type:(TS.Status=Paid) AND (TY=Ticket) AND (TU={SETTING:CURRENTUSER})}
>CREDIT CARD:|{REPORT PAYMENT TOTAL:(PT=Credit Card) AND (TU={SETTING:CURRENTUSER})}
>CASH:|{REPORT PAYMENT TOTAL:(PT=Cash) AND (TU={SETTING:CURRENTUSER})}
>TOTAL:|{REPORT PAYMENT TOTAL:(TU={SETTING:CURRENTUSER})}
Regards.
@Jesse and other that need server reports.
Thanks to @pizzaeilat4 we created two reports.
Detailed Server Report–>All server transactions for current Work Period and Current logged user.
[Server Sales Details:3,2,3,2,2]
Date:|{DATE}
Server:|{SETTING:CURRENTUSER}
Time|T.No.|Payment|Total
{REPORT PAYMENT DETAILS:P.Time,T.TicketNumber,P.Type,TN.TotalAmount:(TS.Status=Paid) AND (TY=Ticket) AND (TU={SETTING:CURRENTUSER})}
.
C.C: |||${REPORT PAYMENT TOTAL:(PT=Credit Card) AND (TU={SETTING:CURRENTUSER})}
Cash:|||${REPORT PAYMENT TOTAL:(PT=Cash) AND (TU={SETTING:CURRENTUSER})}
G.C:|||${REPORT PAYMENT TOTAL:(PT=Gift Card) AND (TU={SETTING:CURRENTUSER})}
TOTAL:|||${REPORT PAYMENT TOTAL:(TU={SETTING:CURRENTUSER})}
Subtract|Gift Card:|
Subtract|C.C Total w/Tips:|
Over|Short
Server Report-Totals–>Total Payments by tender type for Work Period and Current logged user
[Server Sales Details:3,2,3,2,2]
Date:|{DATE}
Server:|{SETTING:CURRENTUSER}
C.C: |||${REPORT PAYMENT TOTAL:(PT=Credit Card) AND (TU={SETTING:CURRENTUSER})}
Cash:|||${REPORT PAYMENT TOTAL:(PT=Cash) AND (TU={SETTING:CURRENTUSER})}
G.C:|||${REPORT PAYMENT TOTAL:(PT=Gift Card) AND (TU={SETTING:CURRENTUSER})}
TOTAL:|||${REPORT PAYMENT TOTAL:(TU={SETTING:CURRENTUSER})}
Subtract|Gift Card:|
Subtract|C.C Total w/Tips:|
Over|Short
.
2 Likes
@na1978
I’ve moved the topic to custom report category.
Thanks
1 Like
Hello! I am curious if it would be possible to run all of these reports but for all users? I would run from the admin login so servers cant access this info.
I edited the line (TU={SETTING:CURRENTUSER})} to reflect (TU={SETTING:ALLUSERS})}
But it failed. Any thoughts?
Thanks
Ray
ALLUSERS is not correct syntax. Instead try (TU= )
Notice there is a space after =
PS. ALLUSERS does not exist.
However to run it for all users you might want to change it up.
Can you explain more of how you want the report to look?
Here is a copy of the report provided from their existing system:
Shows Tables served
How those tables paid
Open, Closed, Gross and Total sales
Event log
I see that but it shows it per User and not all users… I was asking how do you want it to look for all users?
You got it. The end result produces printouts for each User, however it is one report function they select in their POS. I was wanting to combine them to reduce paperwork and reprints.
Regarding how we would want the look, I would say formatted similar to the Work Period Report. I apologize, I have never worked with POS systems before so no previous experience to reference.
Ray
Another reason I want to be able to print for all users as an admin is because we did not setup the ability for their user ID’s to access reporting.
Ok maybe I am confused by what you mean… do you want it to show statistics for all users… or do you want each individual user to be printed on one long report.