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

IAR is showing less theoretical usage than what reported as daily sales in Item activity page

    Details

    • Type: Customer Defect
    • Status: Need More Info (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: CFA 2022R4
    • Fix Version/s: None
    • Component/s: Reports
    • Labels:
      None
    • VTask #:
      VTASK0502640,VTASK0512581

      Description

      CFA reported that the IAR is showing less theoretical usage than what reported as daily sales in Item activity page

      For store 00199 they ran the IAR report with date rang '2022-08-31 17:10:00.000' to '2022-09-30 22:55:00.00' 

      The IAR theoretical usage for Item ID = 18 is 108.93

      While if we calculate the daily sales (Daily Sales) under the item activity page from 09/01 to 09/30 is 113.22

      I checked the DSB table to see the sales qty and I found that we are skipping 09/01.

      select salesQty/36, * from tbDailySTockBalance with ( nolock) where entityid = 124 and businessday between '2022-08-31 17:10:00.000' and '2022-09-30 22:55:00.00' and ItemID = 18

       

      Please investigate why the IAR not including 09/01.

        Attachments

        1. image-2022-10-31-20-09-46-309.png
          29 kB
          Wesam El-Gendy
        2. image-2023-03-28-13-35-31-735.png
          38 kB
          Wesam El-Gendy
        3. image-2023-03-29-14-01-55-108.png
          71 kB
          Sree Surapaneni
        4. image-2023-03-29-14-03-00-295.png
          249 kB
          Sree Surapaneni
        5. image-2023-03-29-14-05-56-883.png
          62 kB
          Sree Surapaneni
        6. ItemActivity_01085_202303270117 (1).csv
          13 kB
          Greg Sciuto
        7. ItemActivity_September.xlsx
          14 kB
          Sree Surapaneni
        8. Nuggets ItemActivity_01085_202303270117 (1).csv
          11 kB
          Greg Sciuto
        9. Screenshot_658.png
          75 kB
          Greg Sciuto

          Issue Links

            Activity

              People

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

                Dates

                • Created:
                  Updated:

                  PagerDuty

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