When you add items to a Purchase Order, Transfer In, or Transfer Out in Microsoft Dynamics RMS Feature Pack 1 (FP1), you receive the following error: 

Error # - 2147217833 The statement has been terminated. (Source: Microsoft OLE DB Provider for SQL Server) (SQL State: 01000) (NativeError: 3621)


This problem can be caused by item having an overly large positive or negative inventory quantity and the new Details view in the Transfer and Purchase Order with FP1 when you try to query the details for the items linked to a supplier, but cannot because while processing the query the quantity is greater than the field size. The overly large quantity can normally be caused by scanning the barcode into the item's quantity field.


To resolve this issue, use the script below as a starting point to find the trouble item. Then update the quantity of the trouble item to a smaller inventory quantity. 

SELECT * FROM Item WHERE Quantity > 10000 OR WHERE Quantity < -10000

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

What affected your experience?

Thank you for your feedback!