Creating specifi sales report

Start here.

As for the cumulative Sales/Cash you’ll either need to use SQL or you can look into using account reporting.

[Sales:1, 1.2, 1, 1, 1, 1, 1, 1]

>Day|Ticket Sales|Discount|Round|Tax|Total|Cash|Credit

{REPORT TICKET DETAILS:T.Date,([T.TotalAmount]-[CA.Discount]-[T.Tax]-[CA.Round]).sum,CA.Discount.sum,CA.Round.sum,T.Tax.sum,T.TotalAmount.sum,PA.Cash.sum,PA.Credit Card.sum:(TS.Status=Paid)}

>Total |{REPORT TICKET DETAILS:([T.TotalAmount]-[CA.Discount]-[T.Tax]-[CA.Round]).sum,CA.Discount.sum,CA.Round.sum,T.Tax.sum,T.TotalAmount.sum,PA.Cash.sum,PA.Credit Card.sum:(TS.Status=Paid)}