Sales Report filtered by time, Z Report filtered by date

Mar 01, 2008 5 Replies

Does anyone have any Z summary reports that can be filtered by day, week, etc



Also does anyone have a sales summary report that can be filtered by date and time. (Our liquor store is open untill 1 AM and I can't get the broken out sales over the "two day" period once sales has started on the next day?



Thank you so much in advance.


There is a combined Z report on the Jean Holland web site (I believe) that does exactly what you want it to do.

In regards to (sales) reports by date and time: I asked the same question a week or so ago in this NG but didn't get any solutions or work around. The only way that I think this will work is to subtract several hours (or in your case 1 hour) from the transaction time in order to get the actual transactions for a particular business date(s).

Thanks Alex but that Z report still does not allow filtering by date. It seems like both of these request would be needed by alot of people?

Anyone who is ever open past midnight would need the sales...

Thanks for your help and when I find one, I will shout back!

Jay

"Alex" wrote:

Jay,

The Z report does allow filtering by date (but not by time). There is a field/column with the batch closing date and time, with some date/time manipulation you should be able to filter for both date and time.

Thanks Alex but I am looking for a Z Summary Report that will filter by date, not the single z report...

I do appreicate your help...

Jay

"Alex" wrote:

That is the report that I was talking about it's a combination of all Z reports for a date or date range. I'm pretty sure I downloaded the (original) report from the Jean Holland web site and made a bunch of modifications.

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required