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 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.

Can ISC Software help?

ISC Software Solutions are UK and Ireland based experts on Microsoft Dynamics GP. If you would 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

Your Email

Subject

Your Enquiry

What should we write about next?

Your Name

Your Email

Suggested Topic

Suggestion Details

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

  1. Pingback: Comment

Leave a Reply

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