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. 00951 on 11.10 - DSR and Cashier Settlement.PNG
          351 kB
          Robert Johnson
        2. 01090 on 11.20 - DSR and Cashier Settlement.PNG
          277 kB
          Robert Johnson
        3. 02822 on 11.22 - DSR and Cashier Settlement.PNG
          259 kB
          Robert Johnson
        4. CashDaySummary_03092_20220507.xml-stacy.privalova1.xml
          33 kB
          Stacy Privalova
        5. CashierKeystrokeSummaryReport-03092 May 7 2022.pdf
          81 kB
          Stacy Privalova
        6. DailyReportSummarySheet-03092 May 7 2022.pdf
          68 kB
          Stacy Privalova
        7. DailySales-03092 May 7 2022.pdf
          82 kB
          Stacy Privalova
        8. MonthlySalesSummary-03092 May 2022.pdf
          64 kB
          Stacy Privalova

          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.