Error Raising In-Transit Transfer in Microsoft Dynamics GP

Microsoft Dynamics GPI was doing some work for a client the other day who was implementing some new functionality in Microsoft Dynamics GP. One of the areas they were working on was Inventory Control. They were testing that everything was working correctly and tried to raise an In Transit Transfer (Inventory Control area page » Transactions » in-Transit transfer Entry); when they entered the Item Number and hit tab the following error appeared:

Error entering an item

Microsoft Dynamics GP
A get/change first operation failed on table 'IV_TRX_WORK_LINE' failed accessing SQL data.

Clicking More Info returned this:

Error showing varchar conversion fail message

Microsoft Dynamics GP
[Microsoft][SQL Server Native Client 11.0][SQL Server]Conversion failed when converting the varchar value 'ITT0000005 ' to data type int.

The error seemed somewhat unusual, as there is no reason to convert the Document Number to an int. I ran a profile using SQL Server Profiler and found the returned SQL command was the following:


As you can see, the highlighted section is the Document Number from the window, but it is not being wrapped in single quotes which is required when selecting a string of text.

This is a bug in the window which can be reproduced at will; testing in Fabrikam works with an all numeric document Number, but as soon as you change it to alphanumeric you get the same error.

The workaround is to change the Next Document Number for In-Transit Transfer in Inventory Control Setup (Inventory Control area page » Setup » Inventory Control) to all numeric (such as 0000001) and delete any partially entered transfers. Once you’ve done these two things, you’ll be able to raise In-Transit Transfers without further problems:

Inventory Setup showing Next Document Number for In-Transit Transfer

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


Your Enquiry

What should we write about next?

Your Name

Your Email

Suggested Topic

Suggestion Details

3 thoughts on “Error Raising In-Transit Transfer in Microsoft Dynamics GP

  1. Pingback: Comment
  2. Pingback: Comment
  3. Pingback: Comment

Leave a Reply

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