When trying to recall transactions (F11) for either a return or a void, I get the error:
Run-time error'-2147467259 (80004005)':
Transaction (process ID 65) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
The Process ID changes depending when its run. This only happens when many POS stations are highly active, and we've accumulated a good number of transactions. I suspect this actions calls some type of cursor, and the cursor hits an area of the database that has a lock on it.
What are my options, what can I do to resolve this problem?