This isn't a technical question, rather one of opinion. I have just installed a POS system that acts as a billing system for a Golf Country Club. They are having trouble with needing to edit/delete the reciept records due to putting them under the wrong member, wrong item #, and a million other things. I want to give access to the office personel to be able to edit/delete records at will so the bills can be correct without having to make correcting entries all the time. I also do not want to sacrifice the integrity of the system. My question is how do I balance the two out and does anyone have any suggestions?
It's sort of a loose system so the records aren't marked as "Invoiced", if they were I would only allow them to change non-invoiced records. What worries me most is that someone could change a record that has already been sent as a bill to someone.