Moving an old transaction from one account to another.

I have a *very* strange situation here...

Once upon a time, Mr. Pat Smith married Ms. Pat Jones. The Mrs. Pat Smith was a cute oddity for the duration of the marriage. Sadly, the marriage ended. Mrs. Smith did not change her last name back to Jones...

Now we have two people in town with the same name. 'Pat Smith'. Mr. Pat Smith bought a mattress set. In RMS, the mattress is on Mrs. Pat Smith's account. This probably would have gone unnoticed for along time, possibly forever, except for the unfortunate demise of the mattress under warranty. Now we need to return the mattress and sell a new one. If possible, we'd like to correct our previous error and get the entire customer history straightened out.

Is it possible to move a single transaction from one account to another?

Tom

Reply to
Terrible Tom
Loading thread data ...

two options here... #1 (the safe way) you can void the incorrect transaction and resell the mattress under the correct customer. This will just have incorrect dates, but at least purchase history items are corrected. #2 (the risky way, or lots of testing) get your RMS partner or RMS computer geek to run some SQL statements for you to switch the customerID for the incorrect transactions in the [Transaction] table.

Reply to
Andy Miller - Boise, Idaho

I don't mind using SQL to solve the problem, I just want to make sure that I update *all* of the tables that need to be updated.

Tom

Reply to
Terrible Tom

Yeah, I think you need to update more than the CustomerID. I think you have to do something with the balances also.

Reply to
Jason

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.