Z Report for Entire Store

Discussion in 'Microsoft Point Of Sale' started by Alex, Mar 13, 2007.

  1. Alex

    Alex Guest

    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.)
     
    Alex, Mar 13, 2007
    #1
    1. Advertisements

  2. Alex

    Alex Guest

    BTW How is everybody else dealing with audit trail on daily tenders over and
    shorts etc.if you have multiple (10) registers?
     
    Alex, Mar 14, 2007
    #2
    1. Advertisements

  3. Alex

    Akber Alwani Guest

    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.
     
    Akber Alwani, Mar 14, 2007
    #3
  4. Alex

    Alex Guest

    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!
     
    Alex, Mar 15, 2007
    #4
  5. 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" <>
    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.)
     
    Todd Berger [MSFT], Mar 15, 2007
    #5
  6. Alex

    Alex Guest

    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,
     
    Alex, Mar 15, 2007
    #6
  7. Alex

    Marc Guest

    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
     
    Marc, Mar 15, 2007
    #7
  8. Alex

    Alex Guest

    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?
     
    Alex, Mar 15, 2007
    #8
  9. Alex

    Akber Alwani Guest

    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.
     
    Akber Alwani, Mar 17, 2007
    #9
  10. Alex

    Alex Guest

    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.
     
    Alex, Mar 17, 2007
    #10
  11. Alex

    Greg [DRS] Guest

    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
     
    Greg [DRS], Mar 17, 2007
    #11
  12. Alex

    Rafeek Guest

    We can Create such a report using third party report writer like crystal report
     
    Rafeek, Mar 28, 2007
    #12
  13. Alex

    Alex Guest

    That would be great if you could please do this.

    BTW Who is "we"?

    Thank you,
     
    Alex, Mar 28, 2007
    #13
  14. Alex

    Blue

    Joined:
    Nov 10, 2012
    Messages:
    6
    Likes Received:
    0
    Alex, did you find what you were asking for in another thread?
     
    Blue, Nov 14, 2012
    #14
    1. Advertisements

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 (here). After that, you can post your question and our members will help you out.