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

CashOver causing inaccuracies in the daily sales report

    Details

    • Type: Customer Defect
    • Status: Done (View Workflow)
    • Priority: Major
    • Resolution: Closed/Resolved by Caller
    • Affects Version/s: CFA 2021R3
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None
    • VTask #:
      VTASK0460883

      Description

      Description

      The daily sales report pulls Cash Over data from tbTransactionCashDeposit.  Cashover in tbTransactionCashDeposit is not accurate due to CFAMX-15388

      Environment : PROD 
      Store : All Stores, example 02418

       

       Steps

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

      2. Menu > Reports > Daily Sales > Select Store 02418 > Business day 6/12

      3. Workflow > change the date to 6/12 > select cashier Layla Gallegos - Shift 1

       

      Results :

      Cashier Over/Short details under Cashier details in cashier settlement for  Layla Gallegos - Shift 1 does not match the Cash Over or Cash Short columns in daily sales report

       

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

       

      This is a widespread issue across the chain due to CFAMX-15388. Is there a way to clean up the incorrect data in tbTransactionCashDeposit?

       

       select* from tbTransactionCashDeposit with (nolock)
      where TransactionCashDepositID=95530695

      select* from tbTransactionCashDeposit with (nolock)
      where cashover <-20 and cashdepositdate > '2021-05-20 00:00:00.000'order by CashDepositDate desc

       

        Attachments

        1. casheirsettlement.PNG
          86 kB
          Robert Johnson
        2. dailysales.pdf
          117 kB
          Robert Johnson

          Issue Links

            Activity

              People

              • Assignee:
                Robert.Johnson Robert Johnson (Inactive)
                Reporter:
                Robert.Johnson Robert Johnson (Inactive)
              • Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  PagerDuty

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