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

          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.