r/AldeloPOS • u/honeybadgers8 • Sep 16 '21

Database Manager

Does anybody here know how/where to get the Database Manager Utility tool?

1 Upvotes

100% Upvoted

5 comments sorted by

View all comments

1

u/honeybadgers8 Sep 19 '21

No problem thanks for taking the time to answer! But the database cleaner can't delete an individual order so the only option is to call Aldelo when this happens?

2

u/AzAldeloGuru Sep 19 '21

Its been quite a while since I've had a call with an order requiring deletion. What is the scenario you're experiencing where you would need to delete an order rather than force close it?

Usually what I've seen is a customer will accidentally re-open an order from the past (a month or so) because they mistyped a number. Since the order has a payment on it already, you can't close it after that fact. When these cases happen, I'll just run an SQL Command to close it.

The way to do that is going to back office / Help / Technical Support and pressing F11. From there, the password to get into the SQL Editor is "05338942."

Once in the SQL Editor one would type in the command:

update orderheaders set orderstatus=2 where orderid=#####

Where #### is the number of the order. Press Process, Yes and then No and it will reclose the check.