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
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.