In-Transit Inventory Transfers Locked

By - December 19, 2017

Have you ever had to modify or delete an In-Transit Inventory record that was locked in the editing status or another status that would not allow you to delete it?  You probably figured it would be easy enough to go to the Table Resources page in Microsoft Dynamics GP and find the associated Inventory table and change the status through an update script in SQL.

However, you’ll find that the records are NOT stored in the Inventory tables.  The tables in question are under the Field Service module:

SVC00700 & SVC00701

Both tables have a status field.  However, the static values are not listed in the field properties and not easy to discern by viewing the tables in SQL.

Below is a list of statuses for these documents if you need to modify them but are unable to through the application.

0 = Open
1 = Picked
3 = Partial Shipped
4 = Shipped
5 = Partial Received
6 = Received
99 = In Use

RSM offers access to Certified Microsoft Professionals, help desk and phone support, knowledge and experience with third-party products and dedicated account management.  To learn more about who we are, go to or contact our professionals at or by phone at 855.437.7202

by Nancy Hogan for RSM

Receive Posts by Email

Subscribe and receive notifications of new posts by email.