| Description |
*1.* Exec [uspICAdjustStockFromSAP] @dtmQtyChange = NULL
,@intItemId = 1093
,@strLotNumber = 'FIFO'
,@intLocationId = 1
,@intSubLocationId = 216
,@intStorageLocationId = NULL
,@intItemUOMId = NULL
,@dblNewQty = 12000
,@dblCost = NULL
,@intEntityUserId = null
,@intSourceId = 1
{color:#ff0000}Msg 50000, Level 11, State 1, Procedure uspICRaiseError, Line 87 [Batch Start Line 97]
Invalid Lot.{color}
If Lot is not there, the SP has to create Lot
*2.* Exec [uspICAdjustStockFromSAP] @dtmQtyChange = NULL
,@intItemId = 1197
,@strLotNumber = 'FIFO'
,@intLocationId = 1
,@intSubLocationId = 176
,@intStorageLocationId = NULL
,@intItemUOMId = NULL
,@dblNewQty = 20060
,@dblCost = NULL
,@intEntityUserId = null
,@intSourceId = 1
{color:#ff0000}Msg 50000, Level 11, State 1, Procedure uspICRaiseError, Line 87 [Batch Start Line 74]
Negative stock quantity is not allowed for 49697510 in Utrecht and L905.{color}
{color:#ff0000}{color}
*3.*
Exec [uspICAdjustStockFromSAP] @dtmQtyChange = NULL
,@intItemId = 890
,@strLotNumber = 'FIFO'
,@intLocationId = 1
,@intSubLocationId = 37
,@intStorageLocationId = NULL
,@intItemUOMId = NULL
,@dblNewQty = 315190
,@dblCost = NULL
,@intEntityUserId = null
,@intSourceId = 1
{color:#ff0000}--Does not update Quantity in i21{color}
{color:#ff0000}Note: Please refer Attached image{color}
{color:#ff0000}{color}
{color:#ff0000}{color}
Exec [uspICAdjustStockFromSAP] @dtmQtyChange = NULL
,@intItemId = 890
,@strLotNumber = 'FIFO'
,@intLocationId = 2
,@intSubLocationId = 270
,@intStorageLocationId = NULL
,@intItemUOMId = NULL
,@dblNewQty = 0
,@dblCost = NULL
,@intEntityUserId = null
,@intSourceId = 1
{color:#ff0000}Msg 50000, Level 11, State 1, Procedure uspICRaiseError, Line 87 [Batch Start Line 93]
Unable to find an open fiscal year period to match the transaction date.{color}
All the errors are in JDE LIVE environment.
|