| Description |
This issue relates to i21 Help Desk ticket. Click the link below to go to Help Desk ticket.
[HDTN-234746 - Inventory and GL Mismatch Error - BS-328 Discrepancy of 3.13 - Issue After upgrade|https://helpdesk.irely.com/iRelyi21live//#/HD/Ticket/?ticket=HDTN-234746]
Steps:
1. Log in to customer environment db: testTE
2. Run the below script
declare @p4 nvarchar(50)
set @p4=N''
declare @p5 int
set @p5=NULL
exec sp_executesql N'Exec uspMFCompleteBlendSheet @strXml,@intLotId OUT,@strLotNumber OUT',N'@strXml nvarchar(1523),@strLotNumber nvarchar(50) output,@intLotId int output',@strXml=N'13423991000060106037/30/2019 12:00:00 AM100353.524003.52400True100366.523896.52389True',@strLotNumber=@p4 output,@intLotId=@p5 output
select @p4, @p5
Issue:
3. The following error message is displayed
Msg 50000, Level 16, State 1, Procedure uspMFCompleteBlendSheet, Line 531
Inventory and GL mismatch for S-1. Discrepancy of -19.88 is found for Consume. See Post Preview for details.
Acceptance: Should be able to post blend.
|