Solved

Opinion about Editing POS records

Posted on 2001-07-05
8
179 Views
Last Modified: 2012-05-04
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.
0
Comment
Question by:header
  • 2
  • 2
  • 2
  • +2
8 Comments
 
LVL 10

Expert Comment

by:aeklund
ID: 6256076
If the backed is a SQL or ORACLE database then you want to make sure you have primary keys and foreign keys to keep the data integrity.  You might want to right triggers for cascading deletes and updates to keep the data inegrity as well.  This way when you give access to the data on the front end, you shouldn't have to worry about data integrity.
0
 
LVL 5

Expert Comment

by:rkot2000
ID: 6256091
you can try to use triggers to enforce additional rules, such as kill transaction (rollback) if send date or some other flag is on
0
 
LVL 4

Accepted Solution

by:
mcoop earned 100 total points
ID: 6256117
I would consider a couple of alternatives...

first - keep a field whoch records who last modified the record along with the date... (I do this as a matter of course for all user modifiable tables.

or for more proof of changes, when a change is is being made, flag the original record as 'void' but keep it for auditing purposes (the voic flag stops it being reprocessed for billing etc), while a new copy is made and kept alive - whcih will contain the new modified data.

Then if an audit is required of the billing / transaction history, you can go back and recover those 'voided' records to show what happened at what time, and by whom.
0
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
LVL 4

Expert Comment

by:nutwiss
ID: 6256122
"It's sort of a loose system so the records aren't marked as "Invoiced""

add an invoiced field ASAP.
and then check it (as you suggest) before allowing updates.

I don't know how your POS system works particularly, but in this country (UK) your system would need to be auditted regularly to ensure your system matches 'the books'.

Your concerns are justified, so it really would be in your long-term interest to add the functionality outlined.

0
 
LVL 4

Expert Comment

by:nutwiss
ID: 6256136
yup,

mcoops idea is a good one (his comment wasn't there when I submitted mine :)

implementing it shouldn't be much of problem

0
 
LVL 2

Author Comment

by:header
ID: 6256504
mcoop, I think that is a great suggestion.  It also provides documentation on why changes are being made to records and may identify trends.  (If one person continually makes a certain type of error, it can be identified and corrected.)

nutwiss, I have wanted to add an 'Invoiced' field since the beginning (I wish I had) but it hasn't been much of an issue until now.  It will be a good investment to add it now.  This particular company was just audited a few years back and was hit with multiple fines for charging tax on things they should not and not charging tax on things they should be. (A little internal confusion and mis-communication)  Their still recovering (financially) from those fines.  So the more documentation, the better.
0
 
LVL 4

Expert Comment

by:mcoop
ID: 6258760
another hint:

Make the invoiced field an integer - default zero

When an invoice is printed, increment the value - so you can tell when more than one invoice has ben sent for that item.

Alternately, add a table of invoices - with date (and username again).  Link this to the items table one (invoice) to many (items)

This will allow you to re-create a previously issued invoice in the future, as well as picking an item then listing all the invoices it has appeared on.

Still keep the counter idea for the invoice link table - then you can see how many times a specific invoice (of multiple items) has been printed.
0
 
LVL 2

Author Comment

by:header
ID: 6259406
Another great idea mcoop, thanks!
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
How to Add / Edit Windows Menu 4 67
Visual Studio 2005 text editor 10 44
vb6 - Transfer from MSHFlexgrid1 to xls issue 8 54
VBA: loop recent folder and copy txt file. 8 34
When trying to find the cause of a problem in VBA or VB6 it's often valuable to know what procedures were executed prior to the error. You can use the Call Stack for that but it is often inadequate because it may show procedures you aren't intereste…
If you have ever used Microsoft Word then you know that it has a good spell checker and it may have occurred to you that the ability to check spelling might be a nice piece of functionality to add to certain applications of yours. Well the code that…
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question