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

After Counting and Applying - On Hand is not correct

    Details

    • Type: Testing Defect
    • Status: Need More Info (View Workflow)
    • Priority: Critical
    • Resolution: Unresolved
    • Affects Version/s: CFA 2022R5
    • Fix Version/s: CFA 2022R5
    • Component/s: None
    • Labels:
      None
    • SCRUM Team:
      Brotherhood of Mutants

      Description

      Scenario - with multiple store I tried counting items using whole numbers like 10 and 5 yet when looking in the DB I am seeing a decimal value. 

       

      Steps to recreate: 

      1- Do a weekly count @ store 03946 in staging 

      2- Count 5 of each item and Apply for the current date and exact time

       

      3. View the On Hand of these items in the DB in tbItemQty

      Select dtLastUpdate_dt, *
      from tbItemQty
      where EntityID = 4761
      and ItemID in (16,14,18,19) --,883,135,225,220,546,847,609,577,16,2117,883)
      and iLastPhysInv_dt > '2022-10-25 10:34:00'
      order by 1 desc

      Defect: 

      The fOnHand_qty are all displaying a decimal value when they should all display 180.

      TNOTE : There are no sales from this lab.

      SELECT *
      FROM tbTransactionSummary ts with (nolock)
      join tbEntity e with (nolock)
      on e.EntityID = ts.EntityID
      WHERE BusinessDay between '2022-10-24' and '2022-10-25'
      and e.EntityID in (4761)

       

       

        Attachments

        1. CFA tbItemQty Out of count sync with tbItemBalance.sql
          0.9 kB
          Stacy Privalova
        2. CFA update tbItemQty from tbItemBalance by store.sql
          1 kB
          Stacy Privalova
        3. image-2022-10-25-15-00-33-492.png
          90 kB
          Charles Wheeler
        4. image-2022-10-25-15-03-35-555.png
          56 kB
          Charles Wheeler
        5. image-2022-10-26-11-55-12-114.png
          59 kB
          Charles Wheeler
        6. image-2022-10-26-11-55-58-601.png
          61 kB
          Charles Wheeler
        7. image-2022-10-26-11-56-51-926.png
          61 kB
          Charles Wheeler
        8. image-2022-11-04-12-04-26-597.png
          20 kB
          Charles Wheeler
        9. ItemQty ItemBalance mismatch.sql
          1 kB
          Sree Surapaneni
        10. Update ItemQty onhand value to match Itembalance.sql
          1 kB
          Sree Surapaneni

          Issue Links

            Activity

              People

              • Assignee:
                charles.wheeler Charles Wheeler
                Reporter:
                charles.wheeler Charles Wheeler
              • Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:

                  PagerDuty

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