Description |
This issue relates to i21 Help Desk ticket. Click the link below to go to Help Desk ticket.
[HDTN-231973 - Deli Recipes|https://helpdesk.irely.com/iRelyi21live//#/HD/Ticket/?ticket=HDTN-231973]
This issue relates to i21 Help Desk ticket. Click the link below to go to Help Desk ticket.
[HDTN-232028 - Can't delete item|https://helpdesk.irely.com/iRelyi21live//#/HD/Ticket/?ticket=HDTN-232028]
#1 Can't delete item
Duplicated an item.
Tried to delete the UOM. Referential integrity error from tblICItemStockUOM table.
!pastedImage_d120513_0.png|height=568,width=1072!
Tried to change the UOM to another one. Unit Qty resets to zero and not able to change it even when Stock Unit check box is unchecked and rechecked
!pastedImage_d120513_1.png|height=460,width=1048!
Work around:
Deleted from the backend.
select iu.* from tblICItem i
join tblICItemUOM iu on i.intItemId = iu.intItemId
where i.strItemNo = '2POPCORN'
delete from tblICItemStockUOM
where intItemUOMId = 37012
delete from tblICItemUOM
where intItemUOMId = 37012
#2 Another related issue -
Opened an existing item
!pastedImage_d120513_2.png|height=516,width=1512!
Added another UOM "Each"
Tried to make that the Stock Unit. But Stock Qty will not be set to 1. Unable to save the record.
!pastedImage_d120513_3.png|height=524,width=1472!
|