Basically I’m trying to create a report where It shows all Cash payment tickets for the day and all Card payments for the days separately. Below is what I got so far
>Cash Payments
{REPORT PAYMENT DETAILS:P.Time,T.Id,P.Type,TN.TotalAmount:(TS.Status=Paid) AND (TY=Ticket) AND (PT=Cash) AND (TU={SETTING:CURRENTUSER})}
Total Cash:|||${REPORT PAYMENT TOTAL:(PT=Cash) AND (TU={SETTING:CURRENTUSER})}
>Credit Card Payments
{REPORT PAYMENT DETAILS:P.Time,T.Id,P.Type,TN.TotalAmount:(TS.Status=Paid) AND (TY=Ticket) AND (PT=Credit Card) AND (TU={SETTING:CURRENTUSER})}
Total Credit Card:|||${REPORT PAYMENT TOTAL:(PT=Credit Card) AND (TU={SETTING:CURRENTUSER})}
TOTAL:|||${REPORT PAYMENT TOTAL:(TU={SETTING:CURRENTUSER})}
Yep that is exactly what I needed.
Thanks for that, but could you explain how you filtered that?
I mean looking at code, I can understand all the lines up to [quote=“emre, post:3, topic:13927”]
{REPORT PAYMENT DETAILS:P.Time,T.Id,P.Type,
[/quote]
but then
is where I got only a little confused. that entire line, is that connected to TN.TotalAmount:(TS.Status=Paid)?
Um I an issue, after creating the report, how come it won’t show previous data?
I just made that report on a backup database with data already in it and all I got was
[Card Sale Tickets:1,1,1,1]
>>Time|Ticket ID|Payment Type|Total
{REPORT PAYMENT DETAILS:P.Time,T.Id,P.Type,TN.TotalAmount:(TS.Status=Paid) AND (TY=Ticket) AND (PT=Cash) AND (TU={SETTING:CURRENTUSER})}
>Total Cash:|||${REPORT PAYMENT TOTAL:(PT=Cash) AND (TU={SETTING:CURRENTUSER})}
I even tried the one you helped me with and still just get
You are filtering also on (TU={SETTING:CURRENTUSER}), so you need to ensure that the logged in User actually Settled Tickets in the period that you are reporting.
Maybe add the User to the Report so you can see who you are reporting for, or remove the (TU={SETTING:CURRENTUSER}) filter if you don’t care about the User.
[Ticket Payments:1,1,1, 1]
>>{SETTING:CURRENTUSER}
>>Time|Ticket ID|Payment Type|Total
>Cash Payments
{REPORT PAYMENT DETAILS:P.Time,T.Id,P.Type,TN.TotalAmount:(TS.Status=Paid) AND (TY=Ticket) AND (PT=Cash) AND (TU={SETTING:CURRENTUSER})}
Total Cash:|||${REPORT PAYMENT TOTAL:(PT=Cash) AND (TU={SETTING:CURRENTUSER})}
>Credit Card Payments
{REPORT PAYMENT DETAILS:P.Time,T.Id,P.Type,TN.TotalAmount:(TS.Status=Paid) AND (TY=Ticket) AND (PT=Credit Card) AND (TU={SETTING:CURRENTUSER})}
Total Credit Card:|||${REPORT PAYMENT TOTAL:(PT=Credit Card) AND (TU={SETTING:CURRENTUSER})}
TOTAL:|||${REPORT PAYMENT TOTAL:(TU={SETTING:CURRENTUSER})}
Administrator is the only user at this stage so whether it’s there or not I think shouldn’t really matter.
however I just tested your template on the one that wasn’t showing the tickets and it still hasn’t changed.
It shows total, but not ticket. It’s acting weirdly. I thought I’d reinstall samba again and test this on a remote workstation. It works on the original system I did this on, but not on the workstation either.
Some tickets may have mixed payment method, card and cash.
What syntax could we use to filter that? to show tickets that had more than 1 payment method used.?
Ahh thanks for that clarification. Well that makes a lot of sense to why it wasn’t showing any tickets. Because I had 2 departments and ticket types. So i suppose by removing that specific filter it showed all ticket types. sweet.