Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

edititing database files in aloha

Status
Not open for further replies.

joe20067

MIS
Jan 16, 2010
1
US
If I wanted to edit aloha data base files so that I can remove certain cash transactions that have occured, which files do I need to edit? I need Aloha to still be able to create reports.
 
Not possible to remove trnsactions - the trans.log contains the encrypted transactions then they dump information into the dbf files for reporting during the grind process.
 
MegabyteCoffee ask why would you want to edit cash transactions?
How else are you to skim the restaurants monies when voids, cancelled checks and refunds are traceable.[noevil]

Bo

Remember,
If the women don't find you handsome,
they should at least find you handy.
(Red Green)
 
Exactly!

You gotta wonder sometimes if answering a question just really helps someone that's not supposed to know something in the first place.

I'd hate to see someone use some free advice on one of my sites to bypass company procedures or for theft. Its hard to tell who you could be helping.

MegabyteCoffee.com
 
I think coorsman's 1st post should be deleted. Don't want thieves doing similar to certain files.
 
Stingrae - read my post again, I said it's not possible to delete transactions in the trans.log - it's encrypted.
 
Have we not all had clients with this question? Reality is most blah blah... anyway. I've always thought, it comes down to profit margins to cause an audit etc. If you're claiming a loss they are going to get you. With any POS you have the ability to Void, Manager Comp, etc. Who's to say you don't train employees under a non training number then have a ton of voids. I've had clients where employees were training/playing around, under a real number, and have had to void 20k in one night. Would or could they prove otherwise. While at the same time it is completely legit and innocent. I think it ussually comes down to profit/loss. If you show a loss or low percentage profit in your business, and continue to run, they will get you. I've never cheated in my own business and never would, but why worry about void records; I guess unless it's a repatative daily occurence. What I'm saying is regardless of the POS numbers you can probably still scam if you choose to. Not that I would condone this behaviour. But I've ran into business owners that stick to simple cash registers in order to not have records; or maybe thats their excuse to not spend money on a POS. Either way do the voids etc. make a big difference in an audit? While yes I'm sure they do somewhat but if you have a lot of incompetent / amature employees; then you could or would have a lot of voids. Anyway like I said before, I don't condone this behaviour, but I don't think the POS system can truly regulate and be the deciding factor, even without deleting records. I think it mostly comes down to profit vs loss percentages.
It's a big security risk to delete transactions, as who knows who is trying to do the deleting; as Megabytecoffe was saying / implying. If I'm a server and want to steal, then it would be a gold mine. And therefor this cannot be accomplished. But if such a function existed, it probably should only affect history, not any current transactions. As a POS developer I'm always looking for scams to prevent. Not that I truly think the OP is stealing, or at least not directly from the employer.

Tom
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top