Z Report for Entire Store


A

Alex

I'm in need of a "store wide" Z report that list all the individual Z
reports for a time frame (most a day) as well as a grand total for all the Z
report line items.

In other words: all the tender types from each register as well as a grand
total (I.E. register and all register totals for cash, Amex, Visa,
MasterCard, layaways etc.)
 
Ad

Advertisements

A

Alex

BTW How is everybody else dealing with audit trail on daily tenders over and
shorts etc.if you have multiple (10) registers?
 
A

Akber Alwani

HI Alex, you can accomplish the same results in Tender Summary Report which
list you by register, by tender and whateso ever is your require grouping.
The report is avaiable in Misc. > Tender Summary.

If you need any help let me know.
 
A

Alex

This gives me some of the information that I need, but it doesn't give me
anything related to layaways, refunds, etc I need to get a consolidated Z
report for all registers for an entire day (including all information that's
on the register Z report. The only thing I don't really need is
department/category, or hourly sales totals.

I also like to get Taxable, Non Taxable, and Tax Exempt information.

Any help would be appreciated!
 
T

Todd Berger [MSFT]

Good afternoon Alex,

Thank you for posting your report question.

I would recommend that you take a look at the Register Analysis (Manager |
Utilities | Crystal Reports) and Sales Tax Analysis (Manager | Reports |
Sales) reports to see if they provide information you need.

Please let me know if this helps.

Todd Berger
Microsoft Online Partner Support

======================================================
PLEASE NOTE: The partner managed newsgroups are provided to assist with
break/fix issues and simple how to questions.
 
We also love to hear your product feedback!
Let us know what you think by posting
from the web interface: Partner Feedback
from your newsreader: microsoft.private.directaccess.partnerfeedback.
We look forward to hearing from you!
======================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from this issue.
======================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================


--------------------
From: "Alex" <Alex@no.com>
Subject: Z Report for Entire Store
Date: Tue, 13 Mar 2007 17:30:19 -0400

I'm in need of a "store wide" Z report that list all the individual Z
reports for a time frame (most a day) as well as a grand total for all the
Z
report line items.

In other words: all the tender types from each register as well as a grand
total (I.E. register and all register totals for cash, Amex, Visa,
MasterCard, layaways etc.)
 
A

Alex

This gives me quite a few things that I was looking for, but unlike a Z
report it doesn't give me any type of Tender information. I also need
numbers for Taxable Sales, Non Taxable Sales, and Tax Exempt Sales.

It would be great to have all the above information per Register with a
grand total at the top or bottom.

P.S. Can you tell me how to add the Taxable Sales, Non Taxable Sales, and
Tax Exempt Sales to the Z reports?

Thank you,
 
Ad

Advertisements

M

Marc

If you are handy with Excel, this is what I do:

Export the sales tax analysis report to a delimted file.
Export the Crystal Reports Register analysis report to an Excel file.

You can then write a little macro (or maybe record it) to copy/paste from
the sales tax export (for Taxable sales, Non Taxable sales and sales tax) to
the Register Analysis report.

It sure would be nice to have it all in one report though!

Marc
 
A

Alex

Marc,

Thanks for your suggestions, but this is something that needs to be done
every night and would be to time consuming/prone to errors/complicated for
the closing managers.

Does anybody else have a solution for this?
 
A

Akber Alwani

Dear Alex,
would you mind to send me the layout of your report what exactly your
desires are I will check if similar I have I will give you.
 
A

Alex

As I mentioned in my original post I would like to be able to generate a
store wide Z report with all the individual register Z reports and a grand
total for the same. I would also like to have the numbers for taxable sales,
non taxable sales and tax exempt.

Example. If I used 10 registers yesterday and Zed them out at the end of the
day, I would like to have one report that list each one of the 10 Z reports
and a grand total for all of them (plus all the above mentioned tax
information). the register analysis report doesn't have enough detail and
doesn't list tender types etc.
 
G

Greg [DRS]

Is this close to what you are looking for?
TenderView with enhanced EOD/EOM reports:
http://www.digitalretailer.com/AddinPDFs/TenderViewPDF.pdf
Maximize your browser window to view the details.

The brochure shows the summary report for all registers, but batch detail
would show each register. We could add another row for the taxable and
non-taxable entries you are looking for.

There is an End of Day version and an End of Month version. EOD defaults to
today's closed activity. EOM defaults to last month. You can enter a date or
date range if you'd like another date or period reported.

TenderView itself allows you to view and balance your cash drawers faster
and provides an X/Z report option to a full size printer.

Greg
Digital Retail Solutions
www.digitalretailer.com/RMSaddins
 
Ad

Advertisements

R

Rafeek

We can Create such a report using third party report writer like crystal report
 
A

Alex

That would be great if you could please do this.

BTW Who is "we"?

Thank you,
 
Ad

Advertisements

Joined
Nov 10, 2012
Messages
6
Reaction score
0
Alex, did you find what you were asking for in another thread?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Z Report shows zeros for an entire shift 1
Performing Z Report Delete Entire Database! 2
store name on z report 1
Store name on Z report 4
Store Names on X and Z Reports 3
Z Report ? 1
Z reports 3
Z Reports 4

Top