Is there a way to apply a transaction after it has been rung to a customer account? There are situations where the cashier has rung the sale but later on Customer account is created and we would like to apply the previous sale to the newly created customer account,. Any help is appreciated.
Thx.
MAKE SURE YOU DO A BACKUP FIRST.
UPDATE [Transaction] SET CustomerID = 'xxx' WHERE [Transaction].TransactionNumber = 'yyy'
xxx is the Customer's ID which can be found by using this SQL statement: SELECT ID FROM Customer WHERE AccountNumber = 'zzz'
Rob
Have something to add? Share your thoughts — no account required.
Ask the community — no account required