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

Customer Sales Report not reflecting the overpayment in the report

    Details

    • Type: Customer Defect
    • Status: Done (View Workflow)
    • Priority: Major
    • Resolution: Done
    • Affects Version/s: CFA 2023R1
    • Fix Version/s: CFA 2023R2
    • Component/s: Reports
    • Labels:
      None
    • VTask #:
      VTASK0510269
    • Root cause - Reason:
      Code defect
    • Source Code ID(s):
    • Root Cause:
      Hide
      The query to look for credits is controlInfo.ControlInfo IN (
         'OPShift Collected Sale Check'
         ,'OPShift Collected Sale Cash'
         ,'OPShift Collected Sale Credit'
         ,'OPShift Collected Sale GiftCard' ) . In the code side there is a bug looking only for ,'OPShift Collected Sale" record. The code changes are made to look if the ",'OPShift Collected Sale" string exists in the result query.
      Show
      The query to look for credits is controlInfo.ControlInfo IN (    'OPShift Collected Sale Check'    ,'OPShift Collected Sale Cash'    ,'OPShift Collected Sale Credit'    ,'OPShift Collected Sale GiftCard' ) . In the code side there is a bug looking only for ,'OPShift Collected Sale" record. The code changes are made to look if the ",'OPShift Collected Sale" string exists in the result query.

      Description

      Customer Sales Report not reflecting the overpayment in the report, I have Verified that the customer should have overpayment amount for the report date range amount of $1911.07.

      If you run the following Query it will show you the payments done on 01/24

      select * from tbTransactionControlInfo with ( nolock ) where TransactionControlInfoID in (52670037206,52670037210)

      If you run the following query it will show you the balance for the customer on 01/24

      Select * from tbCustomerOnAccountBalanceEvent with ( nolock ) where CustomerId = 48805330 order by EventTimestamp

      Why the overpayment is not showing the report the amount of $1911.07 ?

        Attachments

        1. image-2023-02-17-16-54-43-010.png
          75 kB
          Wesam El-Gendy
        2. image-2023-02-17-16-56-43-454.png
          69 kB
          Wesam El-Gendy
        3. image-2023-02-17-16-58-35-985.png
          131 kB
          Wesam El-Gendy
        4. image-2023-02-21-09-45-15-409.png
          19 kB
          Sree Surapaneni

          Issue Links

          blocks

          Feature Request - CFAMX-11540 Production Defects

          • Blocker - Blocks development and/or testing work, production could not run.
          • Open
          relates to

          Testing Defect - CFAMX-24372 Customer Sales Report - Amount overstated when overpayment is applied

          • Critical - Crashes, loss of data, severe memory leak.
          • Open

            Activity

              People

              • Assignee:
                charles.wheeler Charles Wheeler
                Reporter:
                wesam.el-gendy Wesam El-Gendy
              • Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  PagerDuty

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