web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
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

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

I have the same question (0)
  • NickZnavor Profile Picture
    NickZnavor 715 on at

    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

  • Community Member Profile Picture
    Community Member on at

    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.

  • Community Member Profile Picture
    Community Member on at

     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 on at

    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.

  • Verified answer
    RMS Wizard Profile Picture
    RMS Wizard 1,205 on at

    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 on at

    That solved the problem. Thank you so much!

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics RMS (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans