Announcements
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
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.
What query did you use to import the gift cards?
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,807 Super User 2024 Season 2
Martin Dráb 229,135 Most Valuable Professional
nmaenpaa 101,156