A cashier rung in a transaction under the wrong customer. Since we have warranty for these items - would like to be able to sql the transaction # to the proper customer. OR is it simpler to refund and resale! I have several of these to do unfortunately...
Thanks Dan
We return and resell. The downside is that it messes with the sale dates.
"Dan-902" wrote:
the sql command on the store database would look something like this:
update [transaction] set customerid(select id from customer where accountnumber='000580003211') where transactionnumber6957
If you need the pr> A cashier rung in a transaction under the wrong customer. Since we have
Matt
Thanks
That's what I needed and will try it after doing a full backup.
How about changing a sales rep on the receipt? My employees constantly ring the sale under the wrong sales rep! I don't care about the receipt as long as it is changed when the data is pulled to the reports.
same idea, a store database sql fix could look something like this:
update transacti> How about changing a sales rep on the receipt? My employees constantly ring
Have something to add? Share your thoughts — no account required.
Ask the community — no account required