-
Type: Customer Defect
-
Status: In QA (View Workflow)
-
Priority: Major
-
Resolution: Unresolved
-
Affects Version/s: CFA 2023R3
-
Fix Version/s: CFA 2023R4
-
Component/s: Ordering
-
Labels:None
-
VTask #:VTASK0518428
-
Root cause - Reason:Code defect
-
Source Code ID(s):
-
Root Cause:Removed where condition which is looking based on processing times for entityitems
Multiple Restaurants are reporting that Suggested Order values are low for Key Items. Example: Waffle Fries, Coater, and Icedream Mix.
The SO formulas is accurate but Restaurants are having to increase the ordered number due to low suggestions.
It seems that around 1 day of the Forecast demand is missing and that the suggestion is roughly 2/3 of its usual value.
Example order:
Location 04310 order 6985433.
Range 2.92 days
Potato Waffle Fry Usage 69.15 (avg daily usage 23.68 )
Item Activity daily usage is roughly 28-32 cases per day.
A few other reporting locations:
03623
02234
02874
02175
04048
on the support side we did some investigation and found the for the time interval the forecast should be higher than what Inform is showing in the ordering page.
select SUM(SystemTransactionCount)/30,Sum(ManagerTransactionCount)/30,Sum(RawTransactionCount)/30 from forecasting.InventoryItemMetricDetail with ( nolock) where ForecastId in (select ForecastId from Forecasting.forecast where entityID = 5492 and BusinessDay > '2023-06-05') and InventoryItemId = 883 and IntervalStart between '2023-06-15 05:49:00.000' and '2023-06-19 04:00:00.000'
If we use the intervalStart as 06/16, it returns the same forecast that CFA is saying it is incorrect.
I checked the SP used to get this value
exec MXC_Forecast_GetOrderItemForecastByDateRangeWithProcessingTimes 5492, '2023-06-15 05:49:00.000' , '2023-06-19 04:00:00.000', '1,2'
and it is returning the incorrect amount.
I checked this SP with Sree and she found a BUG in the SP code.
- blocks
-
CFAMX-11540 Production Defects
- Open
- Is Clone Of
-
CFAMX-25995 Patch Back 2023 R3 - Multiple Restaurants are reporting that Suggested Order values are low for Key Items
- In QA