Microsoft Dynamics GP In-Transit Transfer Document Locked

Microsoft Dynamics GPWhile 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:

Document is in use error

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 a Dynamics GP Consultant (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 a Dynamics GP Consultant (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.

What should we write about next?





Your Name (required) –
Your Email (required) –

1 thought on “Microsoft Dynamics GP In-Transit Transfer Document Locked

Leave a Reply

Your email address will not be published. Required fields are marked *