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

Daily Sales Report reflecting incorrect Cash Over/Short amount

    Details

    • Type: Customer Defect
    • Status: Done (View Workflow)
    • Priority: Major
    • Resolution: Done
    • Affects Version/s: CFA 2021R6
    • Fix Version/s: CFA 2022R3
    • Component/s: None
    • Labels:
      None
    • VTask #:
      VTASK0478315
    • Root cause - Reason:
      Functionality new
    • Source Code ID(s):
    • Root Cause:
      Cashier Settlement CashOver calculation was updated to fix an issue with the existing cashOver value, but Daily Sales was not fixed at the same time.

      Description

      Description

      The daily sales report pulls Cash Over data from tbTransactionCashDeposit.  Cashover in tbTransactionCashDeposit is not accurate 

      Environment : PROD 
      Store : All Stores, example 02822, 00951, 01090

       

       Steps

      1. Navigate to https://inform.cfahome.com/mms_logon.aspx?bypass_sso=true

      2. Menu > Reports > Daily Sales > Select Store 02822> Business day 11/22

      3. Workflow > change the date to 11/22 > Cashier Settlement > select cashier Garrison White Shift 1  

       

      Results :

      Cashier Over/Short reflects 2.05 and Daily Sales report Cash Over is 623.62

       

      Expected : For the Cashier Over/Short data in cashier settlement to match Cash Over or Cash Short columns in daily sales report

       

       

       

      select* from tbtransactioncashdeposit with (nolock)
      where TransactionCashDepositID= 104000330

       

      CFA states that the amount being passed down in the CDS is correct.  The Cashier Over/Short details under Cashier Settlement are the correct totals.  Can we get the Cashier Over/Short totals under Cashier Settlement to also reflect in daily sales report?

        Attachments

        1. MonthlySalesSummary-03092 May 2022.pdf
          64 kB
        2. LiteSumToThirdParty_Open_2021-11-22_2021-11-23T04.05.03.033.zip
          355 kB
        3. LiteSumToThirdParty_Open_2021-11-22_2021-11-23T03.04.43.453.zip
          346 kB
        4. LiteSumToThirdParty_Open_2021-11-22_2021-11-23T02.13.16.926.zip
          336 kB
        5. LiteSumToThirdParty_Open_2021-11-22_2021-11-23T02.06.51.839.zip
          334 kB
        6. LiteSumToThirdParty_Open_2021-11-22_2021-11-23T01.34.50.583.zip
          326 kB
        7. LiteSumToThirdParty_Open_2021-11-22_2021-11-23T01.32.37.222.zip
          324 kB
        8. LiteSumToThirdParty_Open_2021-11-22_2021-11-23T01.26.32.410.zip
          323 kB
        9. LiteSumToThirdParty_Open_2021-11-22_2021-11-23T01.25.29.517.zip
          322 kB
        10. LiteSumToThirdParty_Open_2021-11-22_2021-11-23T01.22.46.240.zip
          321 kB
        11. LiteSumToThirdParty_Open_2021-11-22_2021-11-23T01.21.02.966.zip
          320 kB
        12. LiteSumToThirdParty_Open_2021-11-22_2021-11-23T01.19.50.107.zip
          320 kB
        13. LiteSumToThirdParty_Open_2021-11-22_2021-11-23T01.16.46.774.zip
          319 kB
        14. LiteSumToThirdParty_Open_2021-11-22_2021-11-23T01.08.21.514.zip
          316 kB
        15. LiteSumToThirdParty_Open_2021-11-22_2021-11-23T00.44.27.227.zip
          304 kB
        16. LiteSumToThirdParty_Open_2021-11-22_2021-11-22T23.08.33.838.zip
          270 kB
        17. LiteSumToThirdParty_Open_2021-11-22_2021-11-22T23.03.55.024.zip
          268 kB
        18. LiteSumToThirdParty_Open_2021-11-22_2021-11-22T21.27.17.239.zip
          242 kB
        19. LiteSumToThirdParty_Open_2021-11-22_2021-11-22T21.21.43.621.zip
          239 kB
        20. LiteSumToThirdParty_Open_2021-11-22_2021-11-22T21.15.39.527.zip
          238 kB
        21. LiteSumToThirdParty_Open_2021-11-22_2021-11-22T21.11.16.491.zip
          237 kB
        22. LiteSumToThirdParty_Open_2021-11-22_2021-11-22T21.06.22.898.zip
          234 kB
        23. LiteSumToThirdParty_Open_2021-11-22_2021-11-22T20.05.14.320.zip
          210 kB
        24. LiteSumToThirdParty_Open_2021-11-22_2021-11-22T17.22.34.955.zip
          89 kB
        25. LiteSumToThirdParty_Open_2021-11-22_2021-11-22T17.10.35.642.zip
          82 kB
        26. LiteSumToThirdParty_Open_2021-11-22_2021-11-22T17.05.18.321.zip
          78 kB
        27. LiteSumToThirdParty_Open_2021-11-22_2021-11-22T16.31.12.536.zip
          67 kB
        28. LiteSumToThirdParty_Open_2021-11-22_2021-11-22T15.10.50.237.zip
          45 kB
        29. LiteSumToThirdParty_Open_2021-11-22_2021-11-22T13.15.35.942.zip
          22 kB
        30. LiteSumToThirdParty_Open_2021-11-22_2021-11-22T13.06.02.770.zip
          21 kB
        31. LiteSumToThirdParty_Open_2021-11-22_2021-11-22T12.43.56.557.zip
          19 kB
        32. LiteSumToThirdParty_Open_2021-11-22_2021-11-22T12.38.04.602.zip
          17 kB
        33. LiteSumToThirdParty_Open_2021-11-22_2021-11-22T12.31.37.638.zip
          15 kB
        34. LiteSumToThirdParty_Open_2021-11-22_2021-11-22T12.28.41.612.zip
          15 kB
        35. LiteSumToThirdParty_Open_2021-11-22_2021-11-22T12.24.15.200.zip
          15 kB
        36. LiteSumToThirdParty_Open_2021-11-22_2021-11-22T12.02.54.095.zip
          14 kB
        37. LiteSumToThirdParty_Closed_2021-11-22.zip
          354 kB
        38. LiteSumToThirdParty_Closed_2021-11-22_2021-11-23T07.01.58.132.zip
          355 kB
        39. DailySales-03092 May 7 2022.pdf
          82 kB
        40. DailyReportSummarySheet-03092 May 7 2022.pdf
          68 kB
        41. CashierKeystrokeSummaryReport-03092 May 7 2022.pdf
          81 kB
        42. CashDaySummary_03092_20220507.xml-stacy.privalova1.xml
          33 kB
        43. 02822 on 11.22 - DSR and Cashier Settlement.PNG
          02822 on 11.22 - DSR and Cashier Settlement.PNG
          259 kB
        44. 01090 on 11.20 - DSR and Cashier Settlement.PNG
          01090 on 11.20 - DSR and Cashier Settlement.PNG
          277 kB
        45. 00951 on 11.10 - DSR and Cashier Settlement.PNG
          00951 on 11.10 - DSR and Cashier Settlement.PNG
          351 kB

          Issue Links

            Activity

              People

              • Assignee:
                charles.wheeler Charles Wheeler
                Reporter:
                Robert.Johnson Robert Johnson (Inactive)
              • Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  PagerDuty

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