Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics RMS (Archived) / Selling Gift Certifica...
Microsoft Dynamics RMS (Archived)

Selling Gift Certificates - they dont appear on Z report

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

I have recently set up 'gift certificate' as an item in POS using the item type - voucher. I have noticed that when a gift certificate is initially sold, the transaction does not show up on the Z report for that day. This means there is a payment in the cash drawer that is not accounted for.

For example, we sell a $50 certificate, record the serial number and the customer pays $50 cash. At the end of the shift, that drawer will be counted as $50 over.

Have I got something wrong in the set up.

The redemption part works fine and the report in Manager for all outstanding vouchers makes sense.

Any suggestions?

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Selling Gift Certificates - they dont appear on Z report

    That solved the problem. Thank you so much!

  • Verified answer
    RMS Wizard Profile Picture
    RMS Wizard 1,205 on at
    RE: Selling Gift Certificates - they dont appear on Z report

    Most likely RMS was upgraded to Feature Pack 1 or higher from an earlier release, but the X/Z report template was not updated at that time.
    To resolve this issue perform the following steps.

    1. Run Store Operations Manager, Database, Registers, Receipt Formats, and select the format in use by the register.
    2. Select Properties and click the X icon in the Report entry at bottom to clear the current template.
    3. Click the magnifying lens icon and select the template labeled XReport.xml.
    4. Click OK to save change. 
    5. Open POS on any registers and run a Z report to clear the current batch using the old template.

    X/Z reports moving forward will now show a separate line item for Vouchers (below Deposit Made).
    If additional receipt formats are in use at any registers you should repeat steps 1-4 for those formats.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Selling Gift Certificates - they dont appear on Z report

    I have figured it out by doing a test entry with no other transactions on the register. I sold a $50 gift certificate for cash. It doesn't record as a sale, which makes sense as the sale will come when the customer returns to redeem the voucher. It is recorded in the total incoming to the register on the Z report but not as a line entry. So it is not clear where the $50 has come from. It would be better if along with Sales, Returns, Tax etc, there was a line for Vouchers to avoid any confusion.

    Thank you for your help.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Selling Gift Certificates - they dont appear on Z report

     Hello Rachel,

    Are you using RMS to manage vouchers, or are you using an add-in, such as the ones offered by Retail Realm, Mercury Payments or Heartland, to manager your gift cards?

    Please note that RMS does not count gift cards as sales, but as liabilities. However, the Z-report should calculate this into its calculations, so the registers should not be over by the amount of the cards.

    Thank you,

    Scott Wardzinski

    Microsoft Dynamics RMS & POS Support Engineer

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Selling Gift Certificates - they dont appear on Z report

    Yes it is version 2.0.2000. I must be doing something wrong as it definitely isnt recorded as a sale in the Z read. Everytime we have sold a certificate the register has been over by the exact amount of the certificate. Accountant (who is not familiar with RMS) cannot figure it out either.

  • NickZnavor Profile Picture
    NickZnavor 715 on at
    RE: Selling Gift Certificates - they dont appear on Z report

    what version are you running? I have  tested this on 2.0.2000 and it seems to work correctly. Shows on the z report under vouchers and also in cash sales/total sales on z report as 50.00

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans