| Description |
This issue relates to i21 Help Desk ticket. Click the link below to go to Help Desk ticket.
[HDTN-227436 - i21 RFQ for CCB - 16 Jan 2019 - RITM0087013: Mapping Blocked Stock onto i21 via stock feed IDoc E1MD|https://helpdesk.irely.com/iRelyi21live//#/HD/Ticket/?ticket=HDTN-227436]
Getting 'Negative stock quantity is not allowed' error while processing the stock feed from SAP in i21
Following is the query which is running in the integration script in JDE Live:
*1. Item '49600235'*
BEGIN TRAN
EXEC [uspICAdjustStockFromSAP] @dtmQtyChange = NULL
,@intItemId = 945
,@strLotNumber = 'FIFO'
,@intLocationId = 1
,@intSubLocationId = 37
,@intStorageLocationId = NULL
,@intItemUOMId = NULL
,@dblNewQty = 659457.36000000000000000000
,@dblCost = NULL
,@intEntityUserId = NULL
,@intSourceId = 1
ROLLBACK TRAN
!pastedImage_d112839_0.png!
*2. Item '49600005'*
BEGIN TRAN
EXEC [uspICAdjustStockFromSAP] @dtmQtyChange = NULL
,@intItemId = 891
,@strLotNumber = 'FIFO'
,@intLocationId = 1
,@intSubLocationId = 37
,@intStorageLocationId = NULL
,@intItemUOMId = NULL
,@dblNewQty = 129551.00000000000000000000
,@dblCost = NULL
,@intEntityUserId = NULL
,@intSourceId = 1
ROLLBACK TRAN
!pastedImage_d112839_1.png!
|