-
Type: Customer Defect
-
Status: Done (View Workflow)
-
Priority: Major
-
Resolution: Unresolved
-
Affects Version/s: CFA 2020R4.1
-
Fix Version/s: CFA 2021R2
-
Component/s: Imports
-
Labels:None
-
Root cause - Reason:Bad data
Vendor Item Import erroneously updates entity item's StocktakeUnit1ID and ReportingUnitID
In Production, after I4 runs:
- store 04437 - Elkin FSU
- Item 'CUP, 32 OZ CFA' StocktakeUnit1ID and ReportingUnitID get set to '25/20 Ct Sleeve Case' UOM instead of '25/16 Ct Sleeve Case' UOM
select* from tbvendoritem with (nolock)
where vendorcode='032671'
--256 QCD 25/16 Ct Sleeve Case
select StocktakeUnit1ID, StocktakeUnit2ID, ReportingUnitID, * from tbentityitem with (nolock)
where itemid=225 and EntityID=4976
--217 25/20 Ct Sleeve Case
select* from tbvendorentityitem with (nolock)
where entityid=4976 and ItemID=225 and vendorcode='032671'
--25/16 Ct Sleeve Case
Note: this store only has one vendor item assigned for this inventory item. Based on this fact (that there is only one vendor item assigned) and the UOM in the Import file is 25/16 Ct Sleeve Case, it is expected that the ReportingUnitID and StockTakeUnit1ID of the entity item be set to 25/16 Ct Sleeve Case, but it is in fact being set to 25/20 Ct Sleeve Case (217).
Note 2: When using the MMS Maintain Order page, and clicking on Save, the UOM gets set correctly to 25/16 Ct Sleeve Case UOM.