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

CLONE 2020R4 - 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 2020R4
    • Component/s: None
    • Labels:
      None
    • VTask #:
      VTASK0429531
    • Root cause - Reason:
      Code defect
    • Source Code ID(s):

      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

          Issue Links

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved:

                  PagerDuty

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