Voucher Import success!!

(0) Share

Report

Posted on by mark.h

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

All responses (3)

Answers (0)

Suggested answer

mark.h 65 on at

Like (0)

Report

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

Like (0)

Report

RE: Voucher Import success!!

What query did you use to import the gift cards?
Community Member Microsoft Employee on at

Like (0)

Report

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