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.

Can ISC Software Solutions help?

ISC Software Solutions are UK and Ireland based experts on Microsoft Dynamics GP. If you'd like to speak to someone about support, consultancy, upgrades, implementation, development, GP Elementz add-ons or portals, or anything else Dynamics GP related, you can use the form below.





Your Name (required):
Your Email (required):
Subject:
Enquiry message:

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 *