Hi,
I have a client whose Inventory Reconcile is not working. When the reconcile is run, a message is received "Item was in use and could not be reconciled". I have cleared the activity, sy00800, sy00801 and temp tables as well as restarting the SQL service. I have also checked that there are no allocated quantities for the items. If I try to update the item quantities in SQL by updating the iv00102 table, I receive the following message:
Msg 2601, Level 14, State 1, Procedure IFC_tuidIVItem, Line 38
Cannot insert duplicate key row in object 'dbo.IVItem' with unique index 'PKidfItemID'. The duplicate key value is (TL000007 , <NULL>).
The statement has been terminated.
There are no duplicate item numbers in the system.
I have also used the SQL Maintenance and selected all the boxes (drop procedure, create procedure etc.) and then ran check links and reconcile. I tried the PSTL IV Reconcile but this did not fix it either.
Help please !
*This post is locked for comments