Moving an old transaction from one account to another.

Jun 11, 2008 3 Replies

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


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.

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

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

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required