-
Type: Customer Defect
-
Status: Done (View Workflow)
-
Priority: Major
-
Resolution: Closed/Resolved by Caller
-
Affects Version/s: CFA 2020R3
-
Fix Version/s: None
-
Component/s: None
-
Labels:None
-
VTask #:VTASK0430013
- OLD Inventory item - 721 - Topping, Strawberry 4# (OLD)
- Vendor Items - 101227 TOPPING, DICED STRAWBERRY
- NEW inventory Item - 14906 - Topping, Strawberry
- Move Vendor Items - 101227 TOPPING, DICED STRAWBERRY, from 721 to be associated to 14906
This item is still active in the system, and needs to be ordered, so it cannot be discontinued.
When trying to update via the Vendor Item Import, CFA is receiving an error message about Open Orders.
Based on the fact that there is error messaging, saying that there are open orders associated to the item, is it possible to move the Vendor Item from Inventory Item 721 to 14906?
Select * from tbitem with (nolock)
where Description like '%Topping, Strawberry%'
--721
Select * from tbEntityItem with (nolock)
where ItemID = 2076
--14906
Select * from tbEntityItem with (nolock)
where ItemID =4111
Select * from tbVendorItem with (nolock)
where itemid=4111
Select * from tbVendorItem with (nolock)
where itemid=2076
Select * from tbVendorEntityItem with (nolock)
where itemid=2076
Select * from tbVendorEntityItem with (nolock)
where itemid=4111
- is blocked by
-
CFAMX-11540 Production Defects
- Open