Skip to main content

Notifications

Microsoft Dynamics RMS forum

Voucher Import success!!

Posted on by 65

We have used Mercury for gift cards for 6 years.  They have recently dropped adult business so I had to start using vouchers in the RMS v2.1006 . I have successfully imported Gift cards into HQ from a flat file with sql 2008 r2 M studio and I am able to check balances at store locations and run reports on HQ.  I imported all vouchers into one storeID and this is My problem since they have been inserted into HQ. When I activate a new card at the POS it works but when I run HQ voucher summary and detail report I see voucherID of 4.  I imported 900 rows into a store. I need the new card to have a voucherID of 901. Which table do  I set the SOpos voucherID higher so they dont conflict with HQ voucherID?  Thanks in advance for any suggestions!!

*This post is locked for comments

  • Suggested answer
    mark.h Profile Picture
    mark.h 65 on at
    RE: Voucher Import success!!

    no query is required. Its basically importing into sql server using wizard and your csv file that has your GC's data. Its definitely not an easy task for a 1st timer or someone that doesn't understand the tables Vouchers use .  If you can work with a partner it might save you a some frustration.I have been using the software for over 5 years and felt pretty comfortable I could do it but it was a pain.  3 days of testing before deploying and then still had some unexpected issues that worked out with some tweaking.  Studio management and its features for me was a must have.  I have explained the basics that points you in the right direction if you proceed to try and do it yourself test on none live db and watch you tube videos how to import into 2008 sql server r2 with studio management.  That is the key to import but it has its own issues to get the field types correct for the tables. I hope this helps.  

  • cdk Profile Picture
    cdk 10 on at
    RE: Voucher Import success!!

    What query did you use to import the gift cards?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Voucher Import success!!

    There is no way to change the IDs.

    The Store ID's will not always match the Headquarters ID, and this is to be expected.

    In store databases, there is a column called HQID, which will be the same as the ID in Headquarters. There is no need to change the store IDs for each is unique.

    Thank you,

    Scott Wardzinski

    Microsoft Dynamics RMS & POS Support Engineer

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

News and Announcements

Give Back to the Community this Month

Quick Links

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,807 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,135 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans