CFA - Testing Transfer 4th UOM

In testing the 4th UOM for the Canadian stores, this user wanted to make sure that the 4th UOM appears on the transfer document. However, could be data, but the user encountered a Requested Operation failed error. This occurred when trying to trainsfer from 1613 to 30001 for item code Chicken, Fillet (1). The following is the data. Please confirm what caused this error. 

System.Data.SqlClient.SqlExceptionArithmetic overflow error converting money to data type numeric.

 

NHibernate.Exceptions.GenericADOException: could not execute query

[ EXEC dbo.qryMMSTransfers_GetItemsForTransfer @p0, @p1, @p2, @p3 ]

  Name:fromEntityId - Value:890  Name:toEntityId - Value:6450  Name:search - Value:%chicken%  Name:limit - Value:100

[SQL: EXEC dbo.qryMMSTransfers_GetItemsForTransfer @p0, @p1, @p2, @p3] ---> System.Data.SqlClient.SqlException: Arithmetic overflow error converting money to data type numeric.

   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)

   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)

   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSetbulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)

   at System.Data.SqlClient.SqlDataReader.TryHasMoreRows(Boolean& moreRows)

   at System.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more)

   at System.Data.SqlClient.SqlDataReader.Read()

   at NHibernate.Driver.NHybridDataReader.Read()

   at NHibernate.Loader.Loader.DoQuery(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies)

   at NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies)

   at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters)

   — End of inner exception stack trace —

   at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters)

   at NHibernate.Loader.Loader.ListIgnoreQueryCache(ISessionImplementor session, QueryParameters queryParameters)

   at NHibernate.Impl.SessionImpl.ListCustomQuery(ICustomQuery customQuery, QueryParameters queryParameters, IList results)

   at NHibernate.Impl.SessionImpl.List(NativeSQLQuerySpecification spec, QueryParameters queryParameters, IList results)

   at NHibernate.Impl.SessionImpl.List[T](NativeSQLQuerySpecification spec, QueryParameters queryParameters)

   at NHibernate.Impl.SqlQueryImpl.List[T]()

   at Mx.Inventory.Services.QueryServices.TransferQueryService.GetTransferableItemsBetweenStores(GetTransferableItemsBetweenStoresRequest request)

   at Mx.Web.UI.Areas.Inventory.Transfer.Api.TransferStoreController.GetTransferableItemsBetweenStoresLimited(Int64 entityId, Int64 toEntityId, Stringfilter, TransferDirection direction)

   at lambda_method(Closure , Object , Object[] )

   at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ActionExecutor.<>c_DisplayClass10.<GetExecutor>b_9(Object instance, Object[]methodParameters)

   at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ExecuteAsync(HttpControllerContext controllerContext, IDictionary`2 arguments,CancellationToken cancellationToken)

— End of stack trace from previous location where exception was thrown —

   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()

   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)

   at System.Web.Http.Controllers.ApiControllerActionInvoker.<InvokeActionAsyncCore>d__0.MoveNext()

— End of stack trace from previous location where exception was thrown —

   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()

   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)

   at System.Web.Http.Filters.ActionFilterAttribute.<CallOnActionExecutedAsync>d__5.MoveNext()

— End of stack trace from previous location where exception was thrown —

   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()

   at System.Web.Http.Filters.ActionFilterAttribute.<CallOnActionExecutedAsync>d__5.MoveNext()

— End of stack trace from previous location where exception was thrown —

   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()

   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)

   at System.Web.Http.Filters.ActionFilterAttribute.<ExecuteActionFilterAsyncCore>d__0.MoveNext()

— End of stack trace from previous location where exception was thrown —

   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()

   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)

   at System.Web.Http.Controllers.ActionFilterResult.<ExecuteAsync>d__2.MoveNext()

— End of stack trace from previous location where exception was thrown —

   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()

   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)

   at System.Web.Http.Filters.AuthorizationFilterAttribute.<ExecuteAuthorizationFilterAsyncCore>d__2.MoveNext()

— End of stack trace from previous location where exception was thrown —

   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()

   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)

   at System.Web.Http.Filters.AuthorizationFilterAttribute.<ExecuteAuthorizationFilterAsyncCore>d__2.MoveNext()

— End of stack trace from previous location where exception was thrown —

   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()

   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)