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

Suggested Count Export does not include all expected stores.

    Details

    • Type: Testing Defect
    • Status: Done (View Workflow)
    • Priority: Major
    • Resolution: Completed
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None
    • SCRUM Team:
      Brotherhood of Mutants

      Description

      Hi Team 

      Looking in Staging , the "Suggested Count Export" that got generated today through SM by DEV Team help, does not include all expected stores.

      The query returns 2 stores while the export only shows 1 store, please advise.

      The query used is:

      select ApplicablePeriod, * from tbTransactionStockCountLocation with (nolock)
      where StockCountSubTypeID=2 and
      status = 'Applied' and
      StockCountType='Monthly' and ApplyDate >= '2021-12-17 00:00:00.000'
      order by 1 desc.

       

       

       

       

       

        Attachments

        1. image-2022-01-19-14-39-11-091.png
          51 kB
          Colin Wyatt-Goodall
        2. screenshot-1.png
          76 kB
          Marwa Abdelwahed
        3. SuggestCountData_20220118_053735_A_20220118_053736.csv
          2 kB
          Marwa Abdelwahed

          Issue Links

            Activity

              People

              • Assignee:
                Marwa.Abdelwahed Marwa Abdelwahed
                Reporter:
                Marwa.Abdelwahed Marwa Abdelwahed
              • Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 8h
                  8h
                  Remaining:
                  0h
                  Logged:
                  Time Not Required
                  Not Specified

                    PagerDuty

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