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

Received orders are not updating tbitemqty causing inaccurate on hand totals creating a order

    Details

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

      Description

      Description

      received orders are not updating tbitemqty but appear to update tbdailystockbalance causing the item Activity to have the correct on hand amount and create order page to have the wrong on hand amount

      Environment : PROD 
      Store : 00528, 02891
       

       Steps

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

      2. Workflow > Mobile Inform > Select Store 00528 > Inv. & Order Setup > Item Activity

      3. Select Potato, Waffle Fries > On Hand total is different from a created order

      4. Create a Order for QCD > Search for Potato, Waffle Fries > On Hand is different from Item Activity

      Results :

      On Hand in Item Activity does not match the on hand that is in a created order.  Received orders are not updating Tbitemqty but they appear to update tbdailystockbalance causing Item Activity to have the correct on hand and the create order page to have the wrong on hand amount

       

      Expected : To have received orders update tbitemqty

       

       select* from tbItemQty with (nolock)
      where entityid=326 and itemid=883

       

      Select * from tbDailyStockBalance with (nolock)
      where ItemID=883
      and BusinessDay between '2021-05-01' and '2021-06-02'
      and EntityID=326
      order by BusinessDay DESC

       

      Select * from tbTransactionReceiveLog with (nolock)
      where entityid=326
      and ItemID=883 order by ApplyDate desc

       

        Attachments

        1. CFAMX-12456 (2).sql
          3 kB
          Cherlyn Thomas
        2. screenshot-1.png
          14 kB
          Cherlyn Thomas

          Issue Links

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved:

                  PagerDuty

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