Record Locking Report

Hi Guys,

We have a requirement which I am hoping that someone might have seen before and have a solution.

In essence, we need to be able to produce a report that shows which sales orders are locked by which user and which delivery route.

Currently the only table I can see is the APPLCK table, but the info here does not marry up to the Locked Symbols enquiry (VRYSMB). I tend to see more records in this table and when checking some orders manually they are not locked.

Is there a way to do this, I suspect that this may be maintained in the session which is in Mongo which is not the easiest to report against.

Thanking you in advance!

Cheers