Microsoft Dynamics GP In-Transit Transfer Document Locked

While I was looking at the problem raising In-Transit Transfers I needed to delete all orders with alpha numeric Document Numbers, but was getting an in use error on one of them:

I double checked to make sure the user was not really locking the record, and, as I’m not aware of an unlock method in Microsoft Dynamics GP itself, I made a quick trip to SQL.

The following query will show the details for the order you’re trying to open (change the highlighted section to your Document Number):

/*
Created by Ian Grieve of azurecurve | Ramblings of an IT Professional (http://www.azurecurve.co.uk)
This code is licensed under the Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International (CC BY-NC-SA 4.0 Int).
*/
//Select locked record in Service Transfer Header (SVC00700)
SELECT
	*
FROM
	SVC00700
WHERE
	ORDDOCID = 'ITT0000005'

This query will unlock the record (change the highlighted section to your Document Number):

/*
Created by Ian Grieve of azurecurve | Ramblings of an IT Professional (http://www.azurecurve.co.uk)
This code is licensed under the Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International (CC BY-NC-SA 4.0 Int).
*/
//Remove lock from record in Service Transfer Header (SVC00700)
UPDATE
	SVC00700
SET
	USERID = ''
	,STATUS = 0
WHERE
	ORDDOCID = 'ITT0000005'

With the record unlocked, I was able to delete it.