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

SO Processing time forecast adjustments are not skipping Sunday 0 forecasts

    Details

    • Type: Customer Defect
    • Status: Done (View Workflow)
    • Priority: Major
    • Resolution: Done
    • Affects Version/s: CFA 2020R3
    • Fix Version/s: CFA 2021R1
    • Component/s: None
    • Labels:
      None
    • VTask #:
      VTASK0429531
    • SCRUM Team:
      Globogym Purple Cobras
    • Root cause - Reason:
      Requirements ambiguity
    • Source Code ID(s):
    • Sprint:
      CFAMX 2021R1 SA Sprint 1

      Description

      Example storeĀ 04012

      OrderĀ 3730208 for , 8/26, has low forecasts for all of the items on the processing time pilot. Their forecasts are quite consistent and they receive daily trucks, but their forecasts yesterday were about 2/3 of their "normal" forecasts for all of these items

      it appears that Sunday is being included as a forecast day instead of being "skipped

      Sunday 0 forecasts are not being 'skipped' when forecast window is adjusted due to the "processing time" feature.


      Note: Skipping Sundays was implemented under: CFAMX-9245
      If my memory is still working, I did test and demo this, and it all worked

      Problem?!?

      • processing time = 48 hours
      • order placed on Thursday, for Delivery on Friday, Cover Until Saturday
      • in this instance, the forecast that we should be using is:
        • Start = Saturday
        • End = Tuesday
        • Where do these days come from?
          • Start = Order day + 48 = Thursday + 48 = Saturday
          • End = Cover Until + 48 + 24 (if the 48 spans Sunday) = Saturday + 48 = Monday, but Sunday is in the range, so add another 24 = Tuesday
      • But we are not accounting for Sunday correctly
      • So we are giving Monday as the End
      • Resulting in the forecast range being Saturday - Monday
        • which really only includes the forecast for Saturday
      • Stores trusted the suggested order, and are now running out of product

      Example from Staging:

      • Order placed Thursday, for Delivery Friday, Cover Until Saturday
      • Processing time = 48 hours
      • Forecast range should be Sat Aug 29 - Tues Sep 01
      • What we see:

        Attachments

        1. dbo.fn_AdjustDateForItemProcessTime.sql
          1 kB
          Francois Steenkamp
        2. fn_AdjustDateForItemProcessTime-OLD.sql
          1 kB
          Francois Steenkamp
        3. screenshot-1.png
          78 kB
          Will Englefield

          Issue Links

            Activity

              People

              • Assignee:
                will.englefield Will Englefield (Inactive)
                Reporter:
                Robert.Johnson Robert Johnson (Inactive)
              • Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 29h 1m
                  29h 1m

                    PagerDuty

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