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