Share
Report
195We closed one of our retail stores in 2007, but we still had the license for the store in Headquarters. We have all of the sales transaction history for that store. For the record, it was store number 201.
Now fast forward 18 months to now. We are preparing to open a new store, and we would like to use this store license. We would like this store to be store number 501.
We don't necessarily want to lose the transaction records for old store 201, but if we somehow renumber the store, we don't want all those transaction records to be part of store 501.
Is it sufficient for me to go through SQL Server and change the StoreID field for the store in question from 201 to 501? I was thinking of doing that, then creating a new StoreOps database, numbering that one 501, and do a Synchronize Store worksheet.
I seem to recall someone posting an answer to this one several months to a year ago, but I can't seem to find it in the post history in the Google group. Was there a Microsoft KB article about this?
*This post is locked for comments
All responses (
Answers (
