Got a support request regarding a transfer from one of  our warehouses to another - this is a 130 line transfer and when the end-user attempted to make a change to it and save, he got a popup error which I had never seen before - An error occurred attempting to process inventory commitments for Transfer Order Lines. Please contact customer support for technical assistance.

None of my normal measures were of any help. As i could create a new transfer and save to it with no problem, I backed up the lines from the problematic transfer and created a new transfer, using the same shipping and receiving warehouses, but with no items. Then I inserted the backed-up lines from the other transfer, taking care to use the new transfer order key and generating new transfer order line numbers. That all went off without a problem, but when I tried to make a change and save it, I got the same error. Meanwhile, I was running a trace but it showed nothing useful. The last thing it ran was unsurprisingly the stored procedure spimUpdateTrnsfrOrderInvtCommits before starting the roll back. It showed no errors or messages when starting the rollback.

I removed the lines from my transfer and start adding them back in 10 at a time, and eventually I was able to isolate the problem to one item. We have plenty of this item in quantity, and there are no open cost tier adjustment batches, everything looks in order. I am going to dive into spimUpdateTrnsfrOrderInvtCommits but if anybody has an idea of where I might or should be looking, it would be greatly appreciated.

We are running Sage 500 ERP 2014 January 2015 Update (Version 7.60.5.0) with SQL Server 2008 R2 running behind it.

Thanks much