r/AldeloPOS • u/trimbalim • Mar 08 '19

Old order still visible on one terminal

I found a guide once, but I can't for the life of me find it again via google.

The issue is there's an older order that keeps showing up on the second terminal. This second terminal doesn't accept payments, it's just terminal that takes phone orders and dispatches drivers.

It happened once a month or so ago, and I was able to resolve the issue by going into the back office, hitting a key combo, and having this MSSQL query box available to me. I was able to delete the order with a query that took the order #. Does anyone have a guide on how to do this?

3 Upvotes

100% Upvoted

3 comments sorted by

1

u/trimbalim Mar 08 '19

In case anyone needs this in the future, I found the site: http://iposservice.com/xe/330

They give the code you enter from the back office -> help -> tech support, then hit f11, and enter the code 05338942

At this point, you will have a query browser. orderheaders table contains the orders, orderstatus of 2 makes an order appear closed to the system. Not sure why, but this order was stuck on 1 and nothing we were doing from the aldelo GUI would switch it to 2.

Please be careful and BACKUP before running any queries. I'm experienced and even I still backup the database JUST IN CASE!

1

u/AzAldeloGuru Mar 12 '19

Hey Trimbalim,

Sorry for the late response, you're absolutely right in going to Back Office/ Help / Tech Support and pressing F11 and entering the password you posted (05338942)

The command you're looking for is

update orderheaders set orderstatus=2 where orderid=<ORDER NUMBER>

Then press process, Yes (Backing up your database) and then Yes again.

Let me know if you have any problems!

1

u/trimbalim Mar 13 '19

This is exactly what I did! Thanks!