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

2020.R1(S2):After Counting an Item, the COH modal and Counts screen show Never Counted

    Details

    • Type: Sprint Defect
    • Status: Done (View Workflow)
    • Priority: Major
    • Resolution: Completed
    • Affects Version/s: CFA 2020R1
    • Fix Version/s: CFA 2020R1
    • Component/s: Counting
    • Labels:
      None
    • Source Code ID(s):
    • Sprint:
      CFAMX 2020R1 - SA Sprint 3

      Description

      After Counting an Item, the COH modal and Counts screen show "Never Counted"

      VendorCode PerformStockTake StockCountDate AutoStockCount Description vendordescription fOnHand_qty InventoryUnitCost DiscontinueDateOverrideEnabled itemcode itemid purchaseunit
      101050 1 2019-10-13 17:50:15.250 0 Splenda, Packets SPLENDA, PACKETS 8000 0.0105 1 1748 132 2000 Ct Case

      Note From David: I think the problem is in "MXC_Inventory_GetLastCountedDaysForItemsByEntity" - there's a condition of "tsc.StockCount > 0" that I think should be "tsc.StockCount >= 0" instead, to account (no pun intended) for items that were counted with a quantity of zero.

        Attachments

        1. CFAMX-6769ItemInfo.sql
          1.0 kB
          Soma Dixon
        2. image-2019-10-13-19-25-51-797.png
          111 kB
          Soma Dixon
        3. screenshot-1.png
          40 kB
          Colin Wyatt-Goodall
        4. screenshot-2.png
          32 kB
          Colin Wyatt-Goodall
        5. screenshot-3.png
          30 kB
          Soma Dixon

          Issue Links

            Activity

              People

              • Assignee:
                soma.dixon Soma Dixon (Inactive)
                Reporter:
                soma.dixon Soma Dixon (Inactive)
              • Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 8h
                  8h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 6h Time Not Required
                  6h

                    PagerDuty

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