-
Type: Sprint Defect
-
Status: Done (View Workflow)
-
Priority: Major
-
Resolution: Completed
-
Affects Version/s: CFA 2019R1
-
Fix Version/s: CFA 2019R1
-
Component/s: OrderGuide
-
Labels:None
-
TestRail Run Link:
-
Sprint:CFAMX 2019R1 Sprint 6
Both the Vendor Item, Discontinue Date and the Rule End Date, contain NULL Dates. In this case, the VEI table for the item should be updated to NULL. Actual results, the whatever value in the table remained.
Please search item '043514' on the Assign Vendor Items Page: https://m.inform.jatesting.cfahome.com/#/Administration/AssignVendorItems/AssignVendorItems
DECLARE @EntityId bigint = 1287
DECLARE @VendorCode varchar(50) = '043514'
select vei.IntroductionDate
, vei.DiscontinueDate
, vei.DiscontinueDateOverridden
, vei.DiscontinueDateOverrideEnabled
, vei.ItemID
, *
from tbVendorEntityItem vei with (nolock)
where vei.entityid = @EntityID
and vei.VendorCode = @VendorCode
--Vendor Item Intro and Discontinue Dates
select vi.IntroductionDate as 'Vendor Intro Date'
, vi.DiscontinueDate as 'Vendor Disc Date'
, *
from tbVendorItem vi with (nolock)
where vi.VendorCode = '043514'
- blocks
-
CFAMX-997 Caner - Apply Rules - Create Vendor Entity Items
- Closed