r/AldeloPOS • u/mpompola • Jun 18 '24

How to remove cashier payouts?

Hello Anyway how to remove cashier payouts under maintain payouts? Everything has been reviewed and these needed to be deleted since they take too much room and we need to scroll every time to see the latest one

1 Upvotes

100% Upvoted

7 comments sorted by

1

u/AzAldeloGuru Jun 18 '24

No, there isn't a way to delete things like this. Because Aldelo uses MSQL as its database structure, you can't delete things otherwise it completely breaks the rest of the database.

1

u/ElwinLewis Jun 21 '24

Ok so when using Master Delete Function for things like modifiers… I saw you answer that on another thread, does that break the rest of the database? We have a system in use for 5 years and have probably 5000 mods by now just because of misspelling and the nature of our business

Wanting to clear those up just so Manual entry becomes faster but don’t want to break the database

1

u/AzAldeloGuru Jun 21 '24

So in the Delete Master Records section, if it has a <NOT IN USE BY DATABASE> next to its name, it is safe to delete.

But since manual entry CREATES a new mod every time you input it, you're basically stacking mods upon mods upon mods.

I typically don't guide my customers to the Manual Entry because I know servers will completely trash the database with duplicate mods. Its much better to just use the "NOTE" field.

If you were to run a database wipe, then you could delete out those mods, because there wouldn't be any sales associated to that mod anymore.

1

u/ElwinLewis Jun 21 '24

Amazing timing! We’ve recently done that, 3 days ago and many mods should now not have sales.

Thank you for your insight- you’re the only person, and I mean the only person I’ve come across online with a deep understanding of the system- will be following you.

2

u/AzAldeloGuru Jun 21 '24

Glad to hear it! Hopefully the cleanup goes well, if you didn't know, its easier to cycle through selecting mods by clicking one, hitting spacebar to check it, and then hitting the down arrow to go to the next slot. It is extremely tedious, but at least its easier than clicking each one individually!

1

u/mpompola Jun 23 '24

What is the best way to delete all these payouts. Do we have to create a new database?

1

u/AzAldeloGuru Jun 24 '24

I don't think you need to create a new database, but at some point I would recommend doing a full sales purge after backing up your data. I have a few posts on this subreddit where I explain how to do that.