Deliverer Total

markjw · June 11, 2019, 11:09am

always important

Jesse · June 11, 2019, 1:09pm

Sorry long bathroom break… ill show you something in just a bit.

Jesse · June 11, 2019, 1:31pm

Not my prettiest report but try this:

[Users:3,3, 2]
@{REPORT PAYMENT DETAILS:P.User,P.Amount.sum:(TS.Status=Paid):{0}}
@{REPORT PAYMENT DETAILS:P.User,P.Type,P.Amount.sum:(TS.Status=Paid):{1}}
>User|Type|Total
{REPORT PAYMENT DETAILS:P.User,P.Type,P.Amount.sum:(TS.Status=Paid) AND (TU=$1)}
>Totals:|{REPORT PAYMENT DETAILS:P.User,P.Amount.sum:(TS.Status=Paid) AND (TU=$1)}

m7mdordony · June 11, 2019, 9:40pm

I Just Tried this its not work

ing

markjw · June 12, 2019, 12:27am

[Ticket Sales by Driver:5, 2, 3, 3, 3, 3]
>Driver|No.|Cash|Card|Del Chg|Due
{REPORT TICKET DETAILS:EN.Deliverer,T.TicketNumber.count,PA.Cash Delivery.sum,PA.Card.sum,CA.Delivery Charge.sum,[PA.Cash Delivery.sum]-[CA.Delivery Charge.sum]:(TCET=Deliverer)}
>TOTAL|{REPORT TICKET DETAILS:T.TicketNumber.count,PA.Cash Delivery.sum,PA.Card.sum,CA.Delivery Charge.sum,[PA.Cash Delivery.sum]-[CA.Delivery Charge.sum]:(TCET=Deliverer)}

This is specific to my setup, so you will need to modify it.

On my setup:

Cash Delivery is the cash payment type
Card is the credit card payment type
Delivery Charge is the calculation type for the delivery charge.

The following is the same report modified to default payment types. NOTE you will still need to add the Delivery Charge calculation type. Please note I have not tested this amended report, but the one above works.

Using Cash, Credit Card payment types.

[Ticket Sales by Driver:5, 2, 3, 3, 3, 3]
>Driver|No.|Cash|Card|Del Chg|Due
{REPORT TICKET DETAILS:EN.Deliverer,T.TicketNumber.count,PA.Cash.sum,PA.Credit Card.sum,CA.Delivery Charge.sum,[PA.Cash.sum]-[CA.Delivery Charge.sum]:(TCET=Deliverer)}
>TOTAL|{REPORT TICKET DETAILS:T.TicketNumber.count,PA.Cash.sum,PA.Credit Card.sum,CA.Delivery Charge.sum,[PA.Cash.sum]-[CA.Delivery Charge.sum]:(TCET=Deliverer)}

m7mdordony · June 12, 2019, 3:58pm

@markjw Thank you very much, i have one problem i would be grateful if you helped me with.
While choosing a table for the reservation, i have a problem selecting some tables (not all)
For example in the picture you can see i selected table 3, trying to select table 4 doesnt work ( i placed a white mark next to it because the curses is not visible here)
Note; all tables now are empty.