Description |
This issue relates to i21 Help Desk ticket. Click the link below to go to Help Desk ticket.
[HDTN-240540 - Inventory Items - Not all items converted packages/unit of measure|https://helpdesk.irely.com/iRelyi21live//#/HD/Ticket/?ticket=HDTN-240540]
SP - uspICDCItemMigrationPt
#1 few pricing levels were not imported and there is no duplicate check
--correct script for price level 2
--should not check this. Price levels can have same price
--and ptitm_prc2 <> ptitm_prc1
and not exists (select 1 from tblICItemPricingLevel l where l.intItemId = inv.intItemId
and iloc.intItemLocationId = l.intItemLocationId and l.strPriceLevel = PL.strPricingLevelName)
!pastedImage_d128784_0.png|height=730,width=1197!
--Correct script for price level 3
--should not check this. Price levels can have same price
--and ptitm_prc3 not in (ptitm_prc1,ptitm_prc2)
and not exists (select 1 from tblICItemPricingLevel l where l.intItemId = inv.intItemId
and iloc.intItemLocationId = l.intItemLocationId and l.strPriceLevel = PL.strPricingLevelName)
!pastedImage_d128784_1.png|height=754,width=1294!
|