show all the delete items that has been delete from the pos rsms transactions, and who delete and the time and the transaction number. that way if somebody wants to steal the owner nows who is deleting and to whom.
delete item report
Apr 05, 2005
3 Replies
You could disable the deletion of items and only allow to certain individuals. i.e. the owner
Rob
You should not delete items, or cashiers, or sales reps, or anything from RMS. All of this data is linked together on a transaction, so it's going to cause confusion if you ever want to run reports that are related to the stuff you delete. I usually disable all the "Delete" keys for everybody except the Administrator account.
Items can be marked "Inactive". However it would be nice if Cashiers and Sales Reps had this option as well.
Also, items cannot be "deleted" from a transaction, they are either voided or returned, which is done on a new transaction. And manually adjusting the inventory causes an entry in the item movement history. There is always a trail to follow. It's very difficult for someone to hide their tracks unless they can log in directly to the SQL server (is your sa password set?) and know how and what SQL commands to run.
what other operations, aside from delete, should be reserved for the admin only? which rights do you guys usually grant to your cashiers? i understand it depends on the business, but i would like to start with tighter security and grant permissions later, as needed and upon study of the potential consequences.
thanks,
Join the Discussion
Have something to add? Share your thoughts — no account required.
Didn't find your answer?
Ask the community — no account required