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

CLONE 2020R3.1 - Suggested ordering is suggesting huge amounts

    Details

    • Type: Customer Defect
    • Status: Done (View Workflow)
    • Priority: Major
    • Resolution: Done
    • Affects Version/s: CFA 2020R2
    • Fix Version/s: CFA 2020R3.1
    • Component/s: None
    • Labels:
      None
    • VTask #:
      VTASK0429158
    • SCRUM Team:
      Watchmen
    • Root cause - Reason:
      Code defect
    • Sprint:
      System Health 2020R4 Sprint 6

      Description

      Store 03769

       Unknown high manager edit forecast for inventory items
      Escalation Notes: For location 03769 on 8/18 we are seeing extremely high manager edits on the forecasts for inventory/ingredient items such as Chicken Filets and Waffle Fries, but are unable to identify any actual manager edits to dollars or sales items for that day that would cause this inflation. ANy help you can offer in regards to why this edit is appearing would be helpful!

      Notes from Will Englefield

      I did some digging into this, and I haven't been able to pin down what happened But y'all are smarter than me, so it shouldn't be aproblem for you to find the issue!

      // Find ForecastId
select version, ManagerTransactionCount, ManagerSales,* from Forecasting.forecast with(nolock)
where EntityId = 4157
and BusinessDay = '2020-08-18'
// ForecastId = 6503527
// Note Version is 19, lots of tweaks...
Raw Count = 1373
System Count = 1377
Manager Count = 1573

Raw Sales = 17146
System Sales = 18646
Manager Sales = 21109

      // Get details of Filets (ItemId = 16)

declare @forecastid	INT='6503527'
declare @itemid		INT='16'

select sum(RawTransactionCount) from Forecasting.InventoryItemMetricDetail with(nolock)
where forecastid = @forecastid
and InventoryItemId = @itemid
select sum(SystemTransactionCount) from Forecasting.InventoryItemMetricDetail with(nolock)
where forecastid = @forecastid
and InventoryItemId = @itemid
select sum(ManagerTransactionCount) from Forecasting.InventoryItemMetricDetail with(nolock)
where forecastid = @forecastid
and InventoryItemId = @itemid

// RawTransactionCount = 136.51
// SystemTransactionCount = 152.80
// InventoryItemId = 1,750.98 -- This is way higher

      // Get details of Waffle Fries (ItemId = 883)

declare @forecastid	INT='6503527'
declare @itemid		INT='883'

select sum(RawTransactionCount) from Forecasting.InventoryItemMetricDetail with(nolock)
where forecastid = @forecastid
and InventoryItemId = @itemid
select sum(SystemTransactionCount) from Forecasting.InventoryItemMetricDetail with(nolock)
where forecastid = @forecastid
and InventoryItemId = @itemid
select sum(ManagerTransactionCount) from Forecasting.InventoryItemMetricDetail with(nolock)
where forecastid = @forecastid
and InventoryItemId = @itemid

// RawTransactionCount = 569.72
// SystemTransactionCount = 571.89
// InventoryItemId = 7,244.57 -- This is way higher

      Looking through the forecast tables, I don't see any Forecast Events for this store/date.

      Looking at Forecasting.SalesItemMetricDetail, there aren't any items where the ManagerTransacationCount is way bigger than the SystemTransactionCount.

      // Eyeball the results, those at the top are deferred orders, 
select * from Forecasting.SalesItemMetricDetail with(nolock)
where ForecastId = 6503527
order by ManagerTransactionCount desc

      I also pulled down a bunch of files, but didn't see anything in them

      Forecast Adjustment, generated 8/19: ForecastAdj_6503527_03769_2020-08-19T04_48_44_A_20200819_044844.xml

      HS Exports, generated after the forecast has been changed:

      Being a super sleuth, I thought to look at Buns (22), as Filets and Fries were high, and Buns too were high.

      It feels to me like someone made a massive forecast adjustment, and then cancelled it, but it only got cancelled at the top level.

      I have not looked at other inventory items, but you may well see the same issue, i.e. Manage is much higher than System.

        Attachments

          Issue Links

          Clones

          Customer Defect - CFAMX-11520 Suggested ordering is suggesting huge amounts

          • Major - Major loss of function.
          • Done

            Activity

              People

              • Assignee:
                charles.wheeler Charles Wheeler
                Reporter:
                Robert.Johnson Robert Johnson (Inactive)
              • Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  PagerDuty

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