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

Inventory Adjustment values out of range (Request to get a query to be used in Query Mailer)

    Details

    • Type: Customer Defect
    • Status: Done (View Workflow)
    • Priority: Major
    • Resolution: Done
    • Affects Version/s: CFA 2022R3
    • Fix Version/s: CFA 2022R5
    • Component/s: Reports
    • Labels:
      None
    • Root cause - Reason:
      Functionality new
    • Root Cause:
      new functionality

      Description

      Based on the issue we found for some items where we see the amounts or the Quantities are out of their normal ranges ( For more information - Reference ticket # CFAMX-20671) 

      Can we get a SQL script that we can put in the server manager Query Mailer so we can get an alert email when the values go our of normal range. 

      I have been using the following query to detect these items. 

      Select A.ItemID,ItemCode,Description,Count(A.ItemID) as Count_oF_Records from tbTransactionStockAdjust A with (nolock) Join tbItem B with ( nolock ) ON A.ItemID = B.ItemID
where 
 (TransactionWasteID = 0  or TransactionWasteID is NULL)
and  ((StockAdjust_qty > 9999999 or StockAdjust_qty < -9999999) or (StockAdjust_amt > 9999999 or StockAdjust_amt < -9999999))
Group by ​A.ItemID,ItemCode,Description 
Order by 4 desc

       

       

        Attachments

          Issue Links

          blocks

          Feature Request - CFAMX-11540 Production Defects

          • Blocker - Blocks development and/or testing work, production could not run.
          • Open

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved:

                  PagerDuty

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