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

IAR is displaying negative purchases due multiple changed apply dates for order 6055211

    Details

    • Type: Customer Defect
    • Status: Need More Info (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: CFA 2022R4
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None
    • VTask #:
      VTASK0500472

      Description

      CFA updated the apply dates multiple times for order 6055211

      SElect EntityID,iTransaction_num,CreatedFromOrder,iStatus_typ,sStatus,iApply_dt, * from tbTransactionSupplyOrder with ( nolock) where iTransaction_num in (6055211,6055162, 6055139, 6055092, 6055089, 6055077, 6055074, 6047855)

      It looks like when the user change the apply date the system return the original order, and this creates negative PurchaseAmt and InventoryAmt values in tbTransactionReceiveLog

      SElect PurchaseAmt,InventoryAmt, * from tbTransactionReceiveLog with ( nolock) where iTransaction_num in (6055211,6055162, 6055139, 6055092, 6055089, 6055077, 6055074, 6047855)

      The IAR report show incorrect qty in this case

       

        Attachments

        1. image-2022-09-20-10-22-22-053.png
          112 kB
          Wesam El-Gendy
        2. image-2022-09-21-17-47-35-229.png
          47 kB
          Sree Surapaneni
        3. image-2022-09-26-13-37-13-433.png
          217 kB
          Wesam El-Gendy
        4. image-2022-10-03-13-38-19-534.png
          81 kB
          Charles Wheeler
        5. image-2022-10-04-12-05-02-275.png
          138 kB
          Sree Surapaneni

          Issue Links

            Activity

              People

              • Assignee:
                wesam.el-gendy Wesam El-Gendy
                Reporter:
                wesam.el-gendy Wesam El-Gendy
              • Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:

                  PagerDuty

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