-
Type: Customer Defect
-
Status: Done (View Workflow)
-
Priority: Major
-
Resolution: Closed/Resolved by Caller
-
Affects Version/s: CFA 2022R5
-
Fix Version/s: None
-
Component/s: Reports
-
Labels:None
-
VTask #:VTASK0503342
The team has a question about the Suggested Order SP:
We expect the SP and query in the attached file to have no rows with a NULL Line ID, but the query returns over 100k instances of this field being NULL.
Example of one record:
(6215108, 7228761, null, 00316, 2022-11-04 07:34:55.383, MCLANE, 21586, 2022-11-04 07:34:55.383, null, null, null, 2022-11-03 07:10:51.533, 2022-11-09 05:30:00, FALSE, FALSE, Placed, Suggested Values Used, 4.93, null, raquel.garciarosas1, raquel.garciarosas1, null, null, 101417, BAG, SIDE SALAD/WRAP C, 0.00, 0.49000000000000005, 1, null, 0, 0, 0, null, null, null, t, null, null, null, 2022-11-04 08:35:00, null)
- blocks
-
CFAMX-11540 Production Defects
- Open