-
Type: Customer Defect
-
Status: In Functional Review (View Workflow)
-
Priority: Major
-
Resolution: Unresolved
-
Affects Version/s: None
-
Fix Version/s: CFA 2022R5
-
Component/s: Reports
-
Labels:None
-
Root cause - Reason:Code defect
-
Root Cause:code change
in sp_suggestedorderexport.sql , The WHERE clause is using ipo.orderdate, which is the immutable "created date" of the order. The SP returns orders from a date range. This means that if an order is created on 9/1 and updated on 9/10 and we hit the SP with a date range of start>=9/9 and end<=9/10, this order will not be included... ie we might have the original order, but never update it.
CFA believes the fix is changing orderdate to ipo.lastupdatedate, but I wanted Fourth to confirm that this will work.
- blocks
-
CFAMX-11540 Production Defects
- Open