Alerts
Manage system alerts and notifications
79 alerts
| DEV | AAA Helpdesk | Helpdesk tickets | - | 124 | 1/14/2026, 4:11:09 PM | DAILY | select z_kp_actionsuuid from actions where done_date is null |
| DEV | ALERT Scripts bad name | Action Scripts that have a bad scriptname. | UNKNOWN | - | - | DAILY | - |
| DEV | ALERT Scripts NO Script | Active Alerts that do not have an Action script. | - | 74 | 12/29/2025, 4:46:50 PM | DAILY | select z_kp_alertuuid from public.alerts where alert_query_sql is null |
| QUALITY | CAR Pending | CAR Pending | UNKNOWN | - | - | DAILY | - |
| QUALITY | CAR Remedial Needed | CAR Assignment incomplete Remedial action. | UNKNOWN | - | - | DAILY | - |
| QUALITY | CCF Pending | CCF still Pending | UNKNOWN | - | - | DAILY | - |
| QUOTES | Closing next week | Quotes that have To Close Date next week. | UNKNOWN | - | - | DAILY | - |
| QUOTES | Closing this month | Quotes that have To Close Date this month. | UNKNOWN | - | - | DAILY | - |
| QUOTES | Closing this week | Quotes that have To Close Date this week. | UNKNOWN | - | - | DAILY | - |
| QUOTES | Closing today | Quotes that have To Close Date today. | UNKNOWN | - | - | DAILY | - |
| DEV | Cust Comm Orphan | Customer Communication without Customer | UNKNOWN | - | - | DAILY | - |
| DEV | Cust Contact Orphan | Customer Contact without Customer | UNKNOWN | - | - | DAILY | - |
| CUSTOMERS | Customer data issues | Customer data entry issues. | UNKNOWN | - | - | DAILY | - |
| CUSTOMERS | Customer Duplicate Name | Duplicate name not allowed. | UNKNOWN | - | - | DAILY | - |
| CUSTOMERS | CUSTOMER FU needed | CUSTOMER Follow up needed | UNKNOWN | - | - | DAILY | - |
| CUSTOMERS | Customer Invalid CSR | CSR doesn't match valid list | UNKNOWN | - | - | DAILY | - |
| CUSTOMERS | Customer without CSR | No CSR Entered | UNKNOWN | - | - | DAILY | - |
| DEV | Def InvLocID incorrect | InvLocID for BizUnit incorrect | UNKNOWN | - | - | DAILY | - |
| DEV | DefaultLayout issue | When a group default layout is missing or doesn't match existing layouts available | UNKNOWN | - | - | DAILY | - |
| DEV | DO Due today | How many To Do items are due today | - | 0 | 12/29/2025, 4:47:39 PM | DAILY | SELECT z_kp_actionsuuid FROM actions WHERE done_date IS NULL AND date_start = CURRENT_DATE |
| DEV | DO with no Due Date | Do Records with no Due Date. | UNKNOWN | - | - | DAILY | - |
| DEV | DO with no Minutes | DO Records with an empty Minutes value. | UNKNOWN | - | - | DAILY | - |
| QUALITY | ECO Engineer | ECO's waiting on Engineering Approval | UNKNOWN | - | - | DAILY | - |
| QUALITY | ECO Executive | ECO's waiting on Executive Approval | UNKNOWN | - | - | DAILY | - |
| QUALITY | ECO Operations | ECO's waiting on Operations Approval | UNKNOWN | - | - | DAILY | - |
| QUALITY | ECO Originator | ECO's waiting on Originator Approval | UNKNOWN | - | - | DAILY | - |
| QUALITY | ECO Quality | ECO's waiting on Quality Approval | UNKNOWN | - | - | DAILY | - |
| INVOICING | Invoice Credit Hold | Invoices with a Credit Hold | UNKNOWN | - | - | DAILY | - |
| DEV | Invoice Detail Orphan | Invoice Detail without an Invoice | UNKNOWN | - | - | DAILY | - |
| DEV | Invoice Orphan | Invoice without a Customer | UNKNOWN | - | - | DAILY | - |
| INVOICING | Invoice Overdue | Invoice is overdue. | UNKNOWN | - | - | DAILY | - |
| INVOICING | Invoice PSNI | Invoices with PSNI as Status | UNKNOWN | - | - | DAILY | - |
| DEV | Layout name has Copy | A layout name has the word copy | UNKNOWN | - | - | DAILY | - |
| PURCHASING | MRP < 30 Days | Purchased Items Order By 30 days | UNKNOWN | - | - | DAILY | - |
| PURCHASING | MRP 30 - 60 Days | Purchased Items Order By 30-60 days | UNKNOWN | - | - | DAILY | - |
| QUALITY | NCR Engineering Open | NCR waiting for Engineering | UNKNOWN | - | - | DAILY | - |
| QUALITY | NCR Originator Open | NCR waiting for Originator | UNKNOWN | - | - | DAILY | - |
| QUALITY | NCR Quality Open | NCR waiting for Quality | UNKNOWN | - | - | DAILY | - |
| DEV | Order Detail Orphan | Order Detail record without related Order record. | UNKNOWN | - | - | DAILY | - |
| DEV | Order Orphan | Order without a related Customer record. | UNKNOWN | - | - | DAILY | - |
| PRODUCTION | Overdue | Orders that are overdue. | UNKNOWN | - | - | DAILY | - |
| DEV | Part Pricing Orphans | Product Pricing without a valid Parent record | UNKNOWN | - | - | DAILY | - |
| DEV | Part_c <> Part_a | ProductPrice auto enter recs do not match the calculation. | UNKNOWN | - | - | DAILY | - |
| QUOTES | Past Close Date | Quotes that have To Close Date before today. | UNKNOWN | - | - | DAILY | - |
| PURCHASING | PO closed Detail Open | PO is closed but has lines still open | UNKNOWN | - | - | DAILY | - |
| PURCHASING | PO Detail Orphan | PO Detail record without a related Purchase Order record. | UNKNOWN | - | - | DAILY | - |
| PURCHASING | PO Exec Approval | POR submitted waiting for Exec approval | UNKNOWN | - | - | DAILY | - |
| PURCHASING | PO Manager Approval | POR submitted waiting for Manager approval | UNKNOWN | - | - | DAILY | - |
| PURCHASING | PO Orphan | Purchase Order without a related Vendor record. | UNKNOWN | - | - | DAILY | - |
| PURCHASING | PO Overdue | Purchase Order is overdue. | UNKNOWN | - | - | DAILY | - |
| PURCHASING | PO Pending | POR entered but not submitted for approval | UNKNOWN | - | - | DAILY | - |
| PURCHASING | PO Place | POR approved but not placed | UNKNOWN | - | - | DAILY | - |
| PURCHASING | PO Submit | POR entered but not submitted for approval | UNKNOWN | - | - | DAILY | - |
| DEV | PO_c <> PO_a | PO auto enter recs do not match the calculation. | UNKNOWN | - | - | DAILY | - |
| SHIP/RCV | PORcv Complete Acct | PORcv waiting for Accounting completion | UNKNOWN | - | - | DAILY | - |
| SHIP/RCV | PORcv Complete Rcv | PORcv waiting for Receiving completion | UNKNOWN | - | - | DAILY | - |
| QUALITY | Production Inspection | Production waiting on Quality | UNKNOWN | - | - | DAILY | - |
| PURCHASING | Purch Item Duplicate Name | Duplicate name not allowed. | UNKNOWN | - | - | DAILY | - |
| PURCHASING | Purchase Item Expired | Purchased Items Expired | UNKNOWN | - | - | DAILY | - |
| PURCHASING | Purchased item issues | Purchased item data entry issues. | - | 4 | 12/29/2025, 3:52:50 AM | DAILY | Select z_kp_purchased_itemuuid from purchased_items where z_statusentry is not null |
| DEV | Quote Detail Orphan | Quote Detail record without a related Quote record. | UNKNOWN | - | - | DAILY | - |
| DEV | Quote Orphan | Quote without a related Customer record. | UNKNOWN | - | - | DAILY | - |
| DEV | Quote_c <> Quote_a | QuotedPrice auto enter recs do not match the calculation. | UNKNOWN | - | - | DAILY | - |
| QUALITY | Receiving Inspection | Receiving waiting on Quality | UNKNOWN | - | - | DAILY | - |
| PRODUCTION | Risk Level Red | Production Risk at Red | UNKNOWN | - | - | DAILY | - |
| PRODUCTION | Risk Level Yellow | Production Risk at Yellow | UNKNOWN | - | - | DAILY | - |
| DEV | Script name has Copy | A script name has the word copy | UNKNOWN | - | - | DAILY | - |
| DEV | Sold Item BOMMP Orphans | Product BOMMP without a valid Parent record | UNKNOWN | - | - | DAILY | - |
| SOLD ITEMS | Sold Item data issues | Sold Item data entry issues. | UNKNOWN | - | - | DAILY | - |
| SOLD ITEMS | Sold Item Duplicate Name | Duplicate name not allowed. | UNKNOWN | - | - | DAILY | - |
| SOLD ITEMS | Sold Item Scrap Act-Est | Scrap rate Act vs Est | UNKNOWN | - | - | DAILY | - |
| DEV | Table name has Copy | A Table name has the word copy | UNKNOWN | - | - | DAILY | - |
| - | Trigger test alert 1 | - | UNKNOWN | - | - | DAILY | - |
| ADMIN | User Button issue | No Buttons for active user | UNKNOWN | 3 | 12/5/2025, 3:26:46 AM | DAILY | select z_kp_useruuid from public.users left join user_buttons on users.z_kp_useruuid = user_buttons.z_kf_useruuid where user_buttons.z_kf_useruuid is null and users.z_inactive is null |
| ADMIN | User DefaultLayout issue | When a group default layout for a user is missing or doesn't match existing layouts available | UNKNOWN | - | - | DAILY | - |
| ADMIN | User Group issue | No groups for active user | UNKNOWN | - | - | DAILY | - |
| PURCHASING | Vendor Approval | New Vendor approval | UNKNOWN | - | - | DAILY | - |
| PURCHASING | Vendor data issues | Vendor data entry issues. | UNKNOWN | - | - | DAILY | - |
| PURCHASING | Vendor Duplicate Name | Duplicate name questionable. | UNKNOWN | - | - | DAILY | - |