I have now looked at how it was done last fall. And I see nothing wrong from a techncial standpoint. Bas wrote an excellent subsystem to enter the CC transactions, generate the numbers AND email the buyers with their numbers and produce sales-reports as necessary. I have actually checked the numbers that were generated and they were unique. That leaves only a few places that things could have created numbering problems.
Some simple rules that should help and these shouldn't be coming from me, but I''ll state what I feel they must be.
There does not seem to be any reason for the numbers to be entered into quicken or generated by quicken. Any receipt sent from quicken MUST NOT have any ticket numbers on it, only dollar amounts.
- The physical numbers that were placed in the jar were not the same as the system generated. Wrong roll, started with wrong number, etc.
- The tickets that were sold at the picnic were from a different roll and the was an overlap.
- When there was no winner present, the wrong report was used to figure out who a number was sold to. I mention this, because someone said that barbara had to enter the numbers into quicken or something like that.
Some simple rules that should help and these shouldn't be coming from me, but I''ll state what I feel they must be.
- There must be only one ticket roll and it must be treated as though it was money, Because it is.
- That roll must stay in a single person's possession from the day we start selling tickets until the end of the drawings (and probably a few more days just in case).
- The day before the raffle selling starts, the roll holder (a new position of staff :rotflm:??) will inform whoever on staff is going to be responsible for the technical side., Webmaster or Admin) of the first ticket number on the roll to be used.
- After online sales are closed, the technical person will inform the roll holder of the last number sold.
- The roll holder will then take all the ticket stubs from the first sold to the last sold and place the appropriate half in the pick jar. The other half of those tickets should be destroyed.
- The technical person will generate the final online sales report in hard copy and bring it and several copies to the picnic.
- At the picnic, raffle sales will proceed using normal raffle procedures, but all tickets must come from the same roll that has been in the custody of the roll holder.
- Only the Sales report generated on our server will be used to determine who bought a winning ticket that was sold on line.
There does not seem to be any reason for the numbers to be entered into quicken or generated by quicken. Any receipt sent from quicken MUST NOT have any ticket numbers on it, only dollar amounts.