If it can work using the same custom report but just changing the group by date to be group by work period range, that would be best, rather than having to re-create the report in SQL.
i.e. replace T.Date with the work period range.
Haha communicating with tech people is really hard. They pre-assume programmers gets everything wrong lol. Now I doubt if youâre trying to clarify your need or wanting something else 
Is it something different than that? You want monthly report by work period dates right?
Yes. Monthly (or whatever range selected by user) by work period dates.
Sorry for any miscommunication, this is the only request
1 Like
Haha @markjw this is really funny. You donât need to talk like Iâm a robot. I know it should work for whatever range selected. I just wanted to make you feel relaxed. You donât need to mention everything. If it fails we can fix it.
2 Likes
@emre Sorry 
I guess Iâm just too used to being explicit about things when writing so didnât realise!
On next version you can use W.Range instead of T.Date to get a date range data instead of ticket date.
My work periods are broken but you can get the idea. Top part is date grouping and bottom table is work period range grouping.
Hope I got it correctly.
4 Likes
Hey Emre looks great - hope you can post the syntax when you release the Version. Would you also include Customer Account Sales here as well as the last column? Tricky as the Customer payment made on Account previously might of already been shown in SalesâŠ
That great report released by @Jesse here. Sales Report monthly. I only added W.Range field that can be used instead of T.Date for grouping tickets by work period.
You can append any payment type to end of it by including your customer payment type field like PA.Customer Account⊠Of course these payment type names should match to your payment type names.
4 Likes
@emre nice 
Thanks
BTW I notice in your reports, what is âLog Detailsâ ?
1 Like
@emre,@Jesse Rreport not showing All payment types
Report:
[Sales:1, 1.2, 1, 1, 1, 1, 1, 1, 1, 1, 1]
Day|Ticket Sales|Discount|Round|Tax|Total|Cash|Eftpos|Customer Balance|Account|Gift Certificate
{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.Eftpos.sum,PA.Customer Balance.sum,PA.Account.sum,PA.Gift Certificate.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.Eftpos.sum,PA.Customer Balance.sum,PA.Account.sum,PA.Gift Certificate.sum:(TS.Status=Paid)}
This kind of works for me? But two problems. CASH and CREDIT show no money. The total and ticket show the correct amounts. Also, the columns are not correct, they are too narrow. I get part of âTicket Salesâ on one line and the rst of the word on the other.
Hi kendash,
How to Report size was set to 700 please
Hi QMcKay, thank you very much for your advise
Hi Jesse,
I am using this syntax to produce monthly reports (or any selected period) however PA.Cash.Sum always seems to return the total received cash before the change is deducted. meaning the cash and credit card columns equal a figure exceeding the daily totals. Whatâs the easiest way to either show the change given or just have it show the true total received cash for that day?
Many thanks
I donât think Iâve ever heard of someone wanting to track the change. Why would you need that?
But you would need to use P.TenderedAmount with PAYMENT DETAILS report
Honestly, I have no desire to,
Since we set up receiving mixed currencies with any change given out in our base currency, many reports seem to show it.
Is it possible to prevent this from happening with PA.cash.sum in the standard sales report?
We use this report to just list headline data over the month, so itâs very useful
Can you share a sample .csv template of how you imagine this report to look like?
A post was split to a new topic: Need help with reports