Details

    • Type: Customer Defect
    • Status: Need More Info (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: CFA 2023R2
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None
    • VTask #:
      VTASK0514795

      Description

      Two stores with similar sales and forecasts for items using Chopped Romaine for prep are seeing very different 'amount forecasted' values in their Bulk Prep Reports.

      select '01604' as StoreNumber,B.Description,A.* from tbSalesItemInventoryItemQuantity A with ( nolock )
      Left Join tbSalesItem B with ( nolock) ON A.SalesItemId = B.SalesItemID
      where entityid = 887 and ServiceType = 9
      and A.SalesItemId in (2469,2474,2475,2471,2472,2426,2409,2418,2419,2431,2497,2703,2702,2719,2705,3082,3083,3079,3084,3085,3086,3087,3080,3078,3081,239)
      and A.ItemId = 853
       
      select '02234' as StoreNumber,B.Description,A.* from tbSalesItemInventoryItemQuantity A with ( nolock )
      Left Join tbSalesItem B with ( nolock) ON A.SalesItemId = B.SalesItemID
      where entityid = 1179 and ServiceType = 9
      and A.SalesItemId in (2469,2474,2475,2471,2472,2426,2409,2418,2419,2431,2497,2703,2702,2719,2705,3082,3083,3079,3084,3085,3086,3087,3080,3078,3081,239)
      and A.ItemId = 853

       

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                wesam.el-gendy Wesam El-Gendy
                Reporter:
                Gregory.Sciuto Greg Sciuto
              • Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:

                  PagerDuty

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