Unable to post the work order due to mismatch in WIP

Issue No: MFG-4130
Created 12/11/2019 12:07:40 PM
Type Bug
Priority Blocker
Status Closed
Resolution Fixed
Fixed Version 19.1
Description This issue relates to i21 Help Desk ticket. Click the link below to go to Help Desk ticket.   [HDTN-239529 - Creston - i21 Work Order Cycle Count Posting Error|https://helpdesk.irely.com/iRelyi21live//#/HD/Ticket/?ticket=HDTN-239529]     {quote}On today's work order (WO-1183), I had to re-open the work order, reverse the cycle count, reverse the consumption and correct it.   I added the corrected amount via bulk produce, started the cycle count, Emptied it out and then tried to post the adjustment and received this error message. I have done this numerous times before and have never hand an issue.   {quote}   Zeeland user getting error 'Mismatch in debit and credit amount for WIP account.' while posting the work order.     Please run the below script in Zeeland live database.   exec sp_executesql N'uspMFPostWorkOrder @strXML',N'@strXML nvarchar(max)',@strXML=N' 1183 False 1 '   !pastedImage_d128049_0.png|height=440,width=717!