Easify Forums

Forums -> Reporting

 Query

Post Reply
Page 1 of 1 1
Posted by nerdcentral

Query

i am looking for a query solutions whereby I can export between 2 dates the following information

Date, CASH, CARD, CHEQUE, TOTAL

Only for paid transactions.

Ideally an SQL Query that I could then export to Excel

Posted by John

Re: Query

Please take a look at the following report, I believe (based on your description) that this will produce the data you are looking for:

"Reports > Finance > Payment Received"


Happy to help - John (Easify Support)

Like our facebook page and always get the latest updates!

Posted by nerdcentral

Re: Query

Would that just give a total or daily breakdown. What I need is the latter

John said:

Please take a look at the following report, I believe (based on your description) that this will produce the data you are looking for:

"Reports > Finance > Payment Received"

Posted by John

Re: Query

For a daily break down you can enter a date range that only spans a single day.

Alternatively you can use the "End of Day (Z) Report" for a list of today's Payments Received.


Happy to help - John (Easify Support)

Like our facebook page and always get the latest updates!

Post Reply
Page 1 of 1 1

Easify Website V 5.0    © 2024 Easify Ltd ® All rights reserved.     Privacy Policy