Store Exchange started at 6/4/2010 2:23:41 PM
190000: Store "BUF", Cannot save the data (Error -193: Primary key for table 'CustomerKeywords' is not unique (23W01) Record ID 5516984177615864069 Record ID 5516984177615864069) File: s0501772.qbt
Store Exchange stopped at 6/4/2010 2:23:41 PM
Calling support is going to be your best bet because there is something wrong with the file in which it seems the customers are not syncing correctly. This will get escalated to the data services team who will correct the file.
I have had this happen now 3 times!!!!! I have had to upload my remote store data files to Intuit and it has taken anywhere from 4 to 11 days to get the files fixed and returned. to me. In the mean time, anything that happens from the time intuit has your file to the time you restore the data files, has to be manually re-input. That includes any sales, customers added, inventory received........major pain.
I just had it happen again last night after I spent the day cleaning the customer files on the headquarters store.
There has got to be a fix for this! There simply must be a better way?!? I have no answers either except that I have had to have the file escalated THREE times for the same problem.
You ought to send a bill to Intuit for doing their job for them. :-)
Good Luck on this one
Thank you for the well wishes! I had TREMENDOUS luck!!!! I fixed it!
Congratulations Jorgina!! A job well done!! Anything that will keep from sending the books is a help.
I HAVE NEWS!!!!!!!!!! I just fixed it myself. Not saying its fool proof but this is what I did.
BACK-UP your remote store data files
1 - store exchange - send from remote(s) to HQ. and receive in HQ.
2 - go to customer list in the remote stores and highlight all customer records, right-click, and "Delete customer(s)". You have to validate "YES" that you want to do it and it will delete all files where the customer does not have a balance on their account.
3 - In the HQ, select "file", "utilities", "resend files". It does a "file send" but resends customer data history that you do not get if you do just a "file send" so you have to do follow this sequence and not just a "file send".
4 - Do a "file receive" in the remote stores.
AND, after doing this, I didn't get the error messages anymore! My files received in both remote stores! My customer history was still present in the remote stores!
AND - ADDED BONUS - no 3 to 10 day wait from intuit.
I just did this this morning. I don't know if there are any repercussions. But, I have a back-up so, we shall see!!! I am just ecstatic that I figured this out! I have had to upload my files 3 times in the last year and a half and it is a major pain re-entering the activity that took place between the time you upload and the time you get your files back.
I hope this work-around actually works! It appears it has for me and if it sounds like I'm gloating......I SO AM!!!!!!
hello Jorgina and Arpeija,
did you have any repercussions with regards to this solution?
What method did you use to send your mailbags between stores?
Jorgina,
Me and my company must reply to your post and say thank you very much. We have encountered this problem several times as well and have always done the procedure through mailing our flash drives to intuit and so forth.........yes 3 to 10 days time every time......
So, of course we were willing to try your suggestion..............and it worked perfectly...... We have four remote locations and it worked at all locations..........
GLOAT, GLOAT, AND GLOAT SOME MORE...............YOU HAVE EVERY RIGHT TO :)
THANK YOU FOR POSTING YOUR YOUR OUTCOME!!!!!!!!!!!!!!!
