-
Type: Customer Defect
-
Status: Need More Info (View Workflow)
-
Priority: Major
-
Resolution: Unresolved
-
Affects Version/s: CFA 2022R4
-
Fix Version/s: None
-
Component/s: Reports
-
Labels:None
-
VTask #:VTASK0502640,VTASK0512581
CFA reported that the IAR is showing less theoretical usage than what reported as daily sales in Item activity page
For store 00199 they ran the IAR report with date rang '2022-08-31 17:10:00.000' to '2022-09-30 22:55:00.00'
The IAR theoretical usage for Item ID = 18 is 108.93
While if we calculate the daily sales (Daily Sales) under the item activity page from 09/01 to 09/30 is 113.22
I checked the DSB table to see the sales qty and I found that we are skipping 09/01.
select salesQty/36, * from tbDailySTockBalance with ( nolock) where entityid = 124 and businessday between '2022-08-31 17:10:00.000' and '2022-09-30 22:55:00.00' and ItemID = 18
Please investigate why the IAR not including 09/01.
- blocks
-
CFAMX-11540 Production Defects
- Open