Uploaded image for project: 'CFA MX '
  1. CFA MX
  2. CFAMX-25995

Patch Back 2023 R3 - Multiple Restaurants are reporting that Suggested Order values are low for Key Items

    Details

    • Type: Customer Defect
    • Status: In QA (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: CFA 2023R3
    • Fix Version/s: CFA 2023R3
    • Component/s: Ordering
    • Labels:
      None
    • VTask #:
      VTASK0518428
    • Root cause - Reason:
      Code defect
    • Root Cause:
      Removed where condition which is looking based on processing times for entityitems

      Description

      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. 

       

       

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                wesam.el-gendy Wesam El-Gendy
                Reporter:
                wesam.el-gendy Wesam El-Gendy
              • Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:

                  PagerDuty

                  Error rendering 'com.pagerduty.jira-server-plugin:PagerDuty'. Please contact your Jira administrators.