Audit Queries

Use this page as the audit and controls query library. The groups below organize reusable SQL by control question: process completeness, manufacturing controls, workforce and attendance, master data, financial timing, planning support, pricing governance, and design-service billing support.

Audit Query Groups

Core process completeness and anomaly triage

Use these queries to start from document-chain completeness, cutoff timing, anomaly triage, and customer-service exception patterns.

Open a query when you want to inspect the SQL, copy it into SQLite, or trace the source-table logic.

O2C Document Chain Completeness

Trace sales orders through shipment, billing, cash application, and return activity to review document-chain completeness.

Output

One row per sales order with quantity and document-chain completion indicators.

Main tables

SalesOrder, SalesOrderLine, Shipment, ShipmentLine, SalesInvoice, SalesInvoiceLine, CashReceiptApplication, SalesReturnLine, CreditMemo.

P2P Document Chain Completeness

Trace requisitions through PO lines, receipts, supplier invoices, and payments to review P2P completeness.

Output

One row per purchase requisition.

Main tables

PurchaseRequisition, PurchaseOrderLine, PurchaseOrder, GoodsReceiptLine, PurchaseInvoiceLine, PurchaseInvoice, DisbursementPayment.

Cutoff and Timing Analysis

Summarize timing gaps across key O2C and P2P process transitions.

Output

One row per timing metric with average, minimum, maximum, and negative-gap counts.

Main tables

SalesInvoice, SalesInvoiceLine, Shipment, ShipmentLine, PurchaseRequisition, PurchaseOrderLine, PurchaseOrder, GoodsReceipt, GoodsReceiptLine, PurchaseInvoice, PurchaseInvoiceLine.

Potential Anomaly Review

Run heuristic anomaly checks using currently implemented tables and fields.

Output

One row per potential anomaly candidate with a type, document reference, and explanatory detail.

Main tables

JournalEntry, PurchaseOrder, PurchaseRequisition, SalesInvoice, Shipment, DisbursementPayment.

Backorder and Return Review

Identify backordered orders and orders that later experienced returns or credit memos.

Output

One row per sales order with backorder and return indicators.

Main tables

SalesOrder, SalesOrderLine, ShipmentLine, SalesInvoiceLine, SalesReturn, SalesReturnLine, CreditMemo.

Manufacturing and work-order controls

Use these queries to test BOM, routing, scheduling, capacity, operation timing, labor support, and released-work-order exception seeds.

Open a query when you want to inspect the SQL, copy it into SQLite, or trace the source-table logic.

Missing BOM or Supply Mode Conflict

Identify supply-mode and BOM-structure conflicts.

Output

One row per item with a potential BOM or supply-mode issue.

Main tables

Item, BillOfMaterial.

Over Issue and Open WIP Review

Review work orders with possible material over-issue or unusually old open WIP.

Output

One row per work order needing review.

Main tables

WorkOrder, BillOfMaterialLine, MaterialIssue, MaterialIssueLine, ProductionCompletionLine, WorkOrderClose.

Work Order Close Timing Review

Review the timing between the last production activity and work-order close.

Output

One row per work order with delayed or missing close behavior.

Main tables

WorkOrder, MaterialIssue, ProductionCompletion, WorkOrderClose.

Missing Routing or Operation Link Review

Review routing, work-order operation, and direct-labor linkage completeness.

Output

One row per potential routing or operation-link exception.

Main tables

Item, Routing, WorkOrder, WorkOrderOperation, LaborTimeEntry.

Operation Sequence and Final Completion Review

Review operation sequencing and final completion timing for manufactured work orders.

Output

One row per potential sequencing or completion-timing exception.

Main tables

WorkOrder, WorkOrderOperation, RoutingOperation.

Schedule on Nonworking Day Review

Detect work-center schedule rows that fall on non-working days.

Output

One row per suspicious schedule row.

Main tables

WorkOrderOperationSchedule, WorkCenterCalendar, WorkCenter, WorkOrderOperation, WorkOrder.

Over Capacity Day Review

Detect work-center days where scheduled hours exceed available capacity.

Output

One row per over-capacity work-center day.

Main tables

WorkOrderOperationSchedule, WorkCenterCalendar, WorkCenter.

Completion Before Scheduled Operation End

Detect work orders completed before their final scheduled operation window ends.

Output

One row per suspicious work order.

Main tables

WorkOrder, WorkOrderOperation, RoutingOperation.

Labor Outside Scheduled Operation Window Review

Find direct labor booked outside the scheduled or actual operation window.

Output

One row per potential labor-window exception.

Main tables

LaborTimeEntry, TimeClockEntry, WorkOrderOperation, WorkOrder, RoutingOperation, Employee.

Released Work Orders Due without Actual Start Review

Review released work orders that are already due in-horizon but still have no actual start recorded.

Output

One row per released work order with no actual start.

Main tables

WorkOrder, WorkOrderOperation, WorkOrderOperationSchedule, WorkCenter, Item.

Released Work Orders Due without Actual Start Summary

Summarize the released-work-order-without-actual-start pattern by release month, due month, and first scheduled work center.

Output

Aggregated rows by due month, release month, and first scheduled work center.

Main tables

WorkOrder, WorkOrderOperation, WorkOrderOperationSchedule, WorkCenter.

Payroll, workforce, attendance, and time controls

Use these queries to review payroll support, employee lifecycle activity, schedule and punch integrity, absence conflicts, overtime, and roster control.

Open a query when you want to inspect the SQL, copy it into SQLite, or trace the source-table logic.

Payroll Control Review

Review common payroll-control exceptions around approvals, payments, and liabilities.

Output

One row per potential payroll-control issue.

Main tables

PayrollRegister, PayrollPayment, PayrollPeriod, Employee.

Labor Time After Close and Paid without Time

Review labor-control exceptions around time posted after work-order close and hourly employees paid without time.

Output

One row per potential control issue.

Main tables

LaborTimeEntry, WorkOrder, PayrollRegister, PayrollPeriod, Employee.

Time Clock Exceptions by Employee Supervisor Work Center

Review time-clock and attendance exceptions by employee, supervisor, and work center.

Output

One row per attendance exception.

Main tables

AttendanceException, TimeClockEntry, ShiftDefinition, Employee, WorkCenter.

Paid without Clock and Clock without Pay Review

Review hourly payroll lines without approved time-clock support and approved time clocks that do not feed hourly pay.

Output

One row per potential payroll-support exception.

Main tables

PayrollRegister, PayrollRegisterLine, LaborTimeEntry, TimeClockEntry, PayrollPeriod, Employee.

Time Clock Payroll Labor Bridge Review

Reconcile approved time clocks, labor allocation, and hourly payroll hours.

Output

One row per employee and payroll period with an exception-oriented bridge result.

Main tables

TimeClockEntry, LaborTimeEntry, PayrollRegister, PayrollRegisterLine, PayrollPeriod, Employee.

Terminated Employee Activity Review

Detect post-termination payroll, approval, and labor activity.

Output

One row per employee activity that occurs after the employee's termination date.

Main tables

Employee, PayrollRegister, TimeClockEntry, LaborTimeEntry, PurchaseOrder, JournalEntry.

Terminated Employee Activity Rollup by Process Area

Roll up post-termination activity by process area so students can see where workforce-control failures appear.

Output

One row per process area and source table with counts of post-termination activity.

Main tables

Employee, PayrollRegister, TimeClockEntry, LaborTimeEntry, PurchaseRequisition, PurchaseOrder, PurchaseInvoice, CreditMemo, CustomerRefund, JournalEntry.

Scheduled without Punch and Punch without Schedule Review

Find rostered days with no punch activity and punch activity without a valid roster assignment.

Output

One row per flagged roster or punch event.

Main tables

EmployeeShiftRoster, TimeClockEntry, TimeClockPunch, Employee.

Overtime without Approval Review

Identify approved worked overtime that is missing a linked overtime approval or exceeds the approved amount.

Output

One row per flagged time-clock entry.

Main tables

TimeClockEntry, OvertimeApproval, Employee, WorkCenter.

Absence with Worked Time Review

Find rostered absences that still carry time summaries or raw punch activity.

Output

One row per conflicting absence record.

Main tables

EmployeeAbsence, EmployeeShiftRoster, TimeClockEntry, TimeClockPunch, Employee.

Overlapping or Incomplete Punch Review

Detect incomplete punch sets and punch sequences with invalid ordering.

Output

One row per flagged time-clock entry.

Main tables

TimeClockPunch, TimeClockEntry, Employee.

Roster After Termination Review

Review roster rows scheduled after an employee's termination date.

Output

One row per invalid rostered day.

Main tables

EmployeeShiftRoster, Employee, TimeClockEntry, TimeClockPunch.

Master data, approvals, role design, and authority limits

Use these queries to test approval roles, executive uniqueness, employee assignments, item completeness, lifecycle status, and authority limits.

Open a query when you want to inspect the SQL, copy it into SQLite, or trace the source-table logic.

Approval and SOD Review

Review basic approval and segregation-of-duties conditions across major document types.

Output

One row per potentially suspicious document.

Main tables

PurchaseRequisition, PurchaseOrder, PurchaseInvoice, JournalEntry, Employee.

Approval Role Review by Org Position

Review who is approving operational and accounting documents by role and organization position.

Output

One row per document family and approver role.

Main tables

Employee, PurchaseRequisition, PurchaseOrder, PurchaseInvoice, CreditMemo, CustomerRefund, JournalEntry, PayrollRegister.

Executive Role Uniqueness and Control Assignment Review

Review whether key executive and control-owner roles are unique and where those role holders appear in current-state assignments and approvals.

Output

One row per key role holder, with role counts and control-assignment evidence.

Main tables

Employee, CostCenter, Warehouse, WorkCenter, PurchaseOrder, PurchaseInvoice, CreditMemo, CustomerRefund, JournalEntry, PayrollRegister.

Item Master Completeness Review

Review whether item-master rows carry the expected catalog attributes for their item group.

Output

One row per item with one or more missing expected attributes.

Main tables

Item.

Discontinued or Prelaunch Item Activity Review

Review operational activity that uses items before launch or after they are discontinued from the active catalog.

Output

One row per flagged activity line or work order.

Main tables

Item, SalesOrder, SalesOrderLine, PurchaseOrder, PurchaseOrderLine, WorkOrder, Shipment, ShipmentLine, SalesInvoice, SalesInvoiceLine.

Approval Authority Review by Expected Role Family

Compare expected approver role families to the roles that actually approve key document families.

Output

One row per document type and observed approver role family.

Main tables

Employee, PurchaseRequisition, PurchaseOrder, PurchaseInvoice, CreditMemo, CustomerRefund, JournalEntry, PayrollRegister.

Current State Employee Assignment Review

Review current-state master assignments that still point to inactive or terminated employees.

Output

One row per current-state assignment linked to an inactive or terminated employee.

Main tables

CostCenter, Warehouse, WorkCenter, Customer, Employee.

Approval Authority Limit Review

Compare document approval amounts to approver limits and expected approver role families.

Output

One row per flagged approval event.

Main tables

PurchaseOrder, PurchaseInvoice, CreditMemo, CustomerRefund, JournalEntry, PayrollRegister, Employee.

Item Status Alignment Review

Review current-state item master conflicts between lifecycle status and active-flag logic.

Output

One row per item with a current-state lifecycle or active-status conflict.

Main tables

Item.

Accrual, cash, duplicate-reference, and financial timing review

Use these queries to investigate duplicate payment references, accrued-service settlement, customer deposits, cash application, and supplier-reference exceptions.

Open a query when you want to inspect the SQL, copy it into SQLite, or trace the source-table logic.

Duplicate Payment Reference Review

Search for duplicate disbursement references and duplicate supplier invoice numbers.

Output

One row per duplicate-pattern candidate.

Main tables

DisbursementPayment, PurchaseInvoice, Supplier.

Over Under Accrual Review

Flag accrued-expense settlements that materially differ from the original estimate or remain uncleared.

Output

One row per potentially unusual accrual outcome.

Main tables

JournalEntry, GLEntry, Account, PurchaseInvoiceLine, PurchaseInvoice.

Accrued Service Settlement Exception Review

Review direct service invoices that clear prior accruals and identify timing or amount exceptions.

Output

One row per accrued-service invoice line with timing, payment, and amount-difference flags.

Main tables

JournalEntry, PurchaseInvoice, PurchaseInvoiceLine, DisbursementPayment, Supplier, Item.

Customer Deposits and Unapplied Cash Exception Review

Review customer receipts that remain unapplied or show unusual application timing.

Output

One row per customer receipt flagged for deposit or unapplied-cash review.

Main tables

CashReceipt, CashReceiptApplication, Customer.

Duplicate AP Reference Detail Review

Review detailed duplicate AP reference patterns by supplier, document, and amount.

Output

One row per duplicated AP document reference.

Main tables

PurchaseInvoice, DisbursementPayment, Supplier.

Planning-support, pricing-governance, and design-service controls

Use these queries to test planning support, inventory policy, replenishment conversion, commercial pricing governance, and design-service billing support.

Open a query when you want to inspect the SQL, copy it into SQLite, or trace the source-table logic.

Forecast Approval and Override Review

Review weekly forecasts that lack approval or show unusually large overrides.

Output

One row per flagged forecast row.

Main tables

DemandForecast, Item, Employee.

Inactive or Stale Inventory Policy Review

Review active inventory items that lack a current active policy or carry inactive policy rows.

Output

One row per policy exception.

Main tables

InventoryPolicy, Item, Warehouse, Employee.

Requisitions and Work Orders without Planning Support

Review replenishment documents that lack planning support.

Output

One row per unsupported requisition or work order.

Main tables

PurchaseRequisition, WorkOrder, Item.

Recommendation Converted After Need by Date Review

Review planning recommendations that converted after their need-by date.

Output

One row per late conversion.

Main tables

SupplyPlanRecommendation, PurchaseRequisition, WorkOrder, Item.

Discontinued or Prelaunch Planning Activity Review

Review planning activity that occurs before launch or against discontinued inactive items.

Output

One row per planning-timing exception.

Main tables

DemandForecast, SupplyPlanRecommendation, PurchaseRequisition, WorkOrder, Item.

Sales Below Floor without Approval

Identify sales lines priced below the configured floor without a valid override approval.

Output

One row per offending sales order line.

Main tables

SalesOrder, SalesOrderLine, PriceListLine, Customer, Item.

Expired or Overlapping Price List Review

Review price lists that are used after expiry or overlap another active list for the same scope.

Output

One row per expired-use or overlapping-scope exception.

Main tables

PriceList, PriceListLine, SalesOrder, SalesOrderLine.

Promotion Scope and Date Mismatch Review

Find sales lines that use a promotion outside the allowed date window or scope.

Output

One row per mismatched promoted sales line.

Main tables

SalesOrder, SalesOrderLine, PromotionProgram, Customer, Item.

Customer Specific Price List Bypass Review

Identify customer orders that bypass an available customer-specific price list.

Output

One row per bypassed sales order line.

Main tables

SalesOrder, SalesOrderLine, Customer, PriceList, PriceListLine.

Override Approval Completeness Review

Review override approvals that are incomplete or missing from override-priced sales lines.

Output

One row per incomplete approval or missing linked approval.

Main tables

PriceOverrideApproval, SalesOrderLine, SalesOrder, Customer, Item, PriceListLine.

Design Service Approved vs Billed Hours Review

Review whether approved design-service hours, billed hours, and invoice coverage stay aligned by engagement.

Output

One row per service engagement.

Main tables

ServiceEngagement, ServiceEngagementAssignment, ServiceTimeEntry, ServiceBillingLine, Customer.

Main Table Families

Topic	Main tables
O2C and P2P completeness	O2C and P2P header and line tables plus CashReceiptApplication
Approvals and segregation of duties	PurchaseRequisition, PurchaseOrder, PurchaseInvoice, JournalEntry, CreditMemo, CustomerRefund, PayrollRegister, Employee
Manufacturing controls	Item, BillOfMaterial, Routing, WorkCenter, WorkOrder, WorkOrderOperation, WorkOrderOperationSchedule, MaterialIssueLine, ProductionCompletionLine, WorkOrderClose
Payroll and time controls	ShiftDefinition, EmployeeShiftAssignment, EmployeeShiftRoster, EmployeeAbsence, OvertimeApproval, TimeClockPunch, TimeClockEntry, AttendanceException, LaborTimeEntry, PayrollRegister, PayrollRegisterLine, PayrollPayment, PayrollLiabilityRemittance, Employee
Master-data controls	Employee, Item, PriceList, PriceListLine, PromotionProgram, PriceOverrideApproval, plus operational tables that reuse those masters
Cross-process control review	Combine query output with source-table tracing across the affected process tables

Baseline Control Queries

Use these first when you want control logic without relying on planted anomalies:

• O2C and P2P completeness
• approval-role review by organization position
• executive-role uniqueness and control-assignment review
• approval-authority review by expected role family

Exception-Oriented Queries

Use these when you want students to review the exception patterns present in the published dataset:

• duplicate payment or AP reference review
• payroll control review
• routing and operation-link review
• released work orders due without actual start review
• released work orders due without actual start summary
• time-clock and labor exception review
• roster, punch, absence, and overtime-approval review
• terminated-employee activity review
• item-master completeness review
• discontinued or pre-launch item activity review
• current-state employee assignment review
• approval authority-limit review
• item status alignment review
• forecast approval and override review
• inactive or stale inventory policy review
• requisitions and work orders without planning support
• recommendation converted after need-by date review
• discontinued or pre-launch planning activity review
• sales below floor without approval
• expired or overlapping price-list review
• promotion scope and date mismatch review
• customer-specific price-list bypass review
• override approval completeness review

Interpretation Notes

• Exception-oriented queries are designed to return reviewable control patterns from the published dataset.
• The GL remains balanced even when audit queries identify exceptions.
• Employee-master review should distinguish current-state IsActive from historical validity driven by HireDate and TerminationDate.
• Item-master review should distinguish current-state lifecycle and launch-date logic from operational usage timing.
• Pricing-control review should distinguish price-list master-data failures from transaction-level override and promotion-use failures.
• Source-table tracing should remain the final step in explaining each exception pattern.

Anomaly Coverage Queries

Click Show SQL to open a query, review the logic, and copy it into SQLite or a compatible SQL tool.

AP payment review

Search for duplicate disbursement references and duplicate supplier invoice numbers.

Output

One row per duplicate-pattern candidate.

Main tables

DisbursementPayment, PurchaseInvoice, Supplier.

broad control screening

Run heuristic anomaly checks using currently implemented tables and fields.

Output

One row per potential anomaly candidate with a type, document reference, and explanatory detail.

Main tables

JournalEntry, PurchaseOrder, PurchaseRequisition, SalesInvoice, Shipment, DisbursementPayment.

payroll settlement review

Review common payroll-control exceptions around approvals, payments, and liabilities.

Output

One row per potential payroll-control issue.

Main tables

PayrollRegister, PayrollPayment, PayrollPeriod, Employee.

labor support review

Review labor-control exceptions around time posted after work-order close and hourly employees paid without time.

Output

One row per potential control issue.

Main tables

LaborTimeEntry, WorkOrder, PayrollRegister, PayrollPeriod, Employee.

manufacturing linkage review

Review routing, work-order operation, and direct-labor linkage completeness.

Output

One row per potential routing or operation-link exception.

Main tables

Item, Routing, WorkOrder, WorkOrderOperation, LaborTimeEntry.

operation sequence review

Review operation sequencing and final completion timing for manufactured work orders.

Output

One row per potential sequencing or completion-timing exception.

Main tables

WorkOrder, WorkOrderOperation, RoutingOperation.

capacity-calendar review

Detect work-center schedule rows that fall on non-working days.

Output

One row per suspicious schedule row.

Main tables

WorkOrderOperationSchedule, WorkCenterCalendar, WorkCenter, WorkOrderOperation, WorkOrder.

capacity review

Detect work-center days where scheduled hours exceed available capacity.

Output

One row per over-capacity work-center day.

Main tables

WorkOrderOperationSchedule, WorkCenterCalendar, WorkCenter.

schedule-completion review

Detect work orders completed before their final scheduled operation window ends.

Output

One row per suspicious work order.

Main tables

WorkOrder, WorkOrderOperation, RoutingOperation.

attendance exception review

Review time-clock and attendance exceptions by employee, supervisor, and work center.

Output

One row per attendance exception.

Main tables

AttendanceException, TimeClockEntry, ShiftDefinition, Employee, WorkCenter.

labor timing review

Find direct labor booked outside the scheduled or actual operation window.

Output

One row per potential labor-window exception.

Main tables

LaborTimeEntry, TimeClockEntry, WorkOrderOperation, WorkOrder, RoutingOperation, Employee.

payroll-time reconciliation

Review hourly payroll lines without approved time-clock support and approved time clocks that do not feed hourly pay.

Output

One row per potential payroll-support exception.

Main tables

PayrollRegister, PayrollRegisterLine, LaborTimeEntry, TimeClockEntry, PayrollPeriod, Employee.

workforce bridge review

Reconcile approved time clocks, labor allocation, and hourly payroll hours.

Output

One row per employee and payroll period with an exception-oriented bridge result.

Main tables

TimeClockEntry, LaborTimeEntry, PayrollRegister, PayrollRegisterLine, PayrollPeriod, Employee.

AP duplicate-reference review

Review detailed duplicate AP reference patterns by supplier, document, and amount.

Output

One row per duplicated AP document reference.

Main tables

PurchaseInvoice, DisbursementPayment, Supplier.

employment validity review

Detect post-termination payroll, approval, and labor activity.

Output

One row per employee activity that occurs after the employee's termination date.

Main tables

Employee, PayrollRegister, TimeClockEntry, LaborTimeEntry, PurchaseOrder, JournalEntry.

executive-role review

Review whether key executive and control-owner roles are unique and where those role holders appear in current-state assignments and approvals.

Output

One row per key role holder, with role counts and control-assignment evidence.

Main tables

Employee, CostCenter, Warehouse, WorkCenter, PurchaseOrder, PurchaseInvoice, CreditMemo, CustomerRefund, JournalEntry, PayrollRegister.

item-master completeness review

Review whether item-master rows carry the expected catalog attributes for their item group.

Output

One row per item with one or more missing expected attributes.

Main tables

Item.

item-lifecycle review

Review operational activity that uses items before launch or after they are discontinued from the active catalog.

Output

One row per flagged activity line or work order.

Main tables

Item, SalesOrder, SalesOrderLine, PurchaseOrder, PurchaseOrderLine, WorkOrder, Shipment, ShipmentLine, SalesInvoice, SalesInvoiceLine.

approval-role review

Compare expected approver role families to the roles that actually approve key document families.

Output

One row per document type and observed approver role family.

Main tables

Employee, PurchaseRequisition, PurchaseOrder, PurchaseInvoice, CreditMemo, CustomerRefund, JournalEntry, PayrollRegister.

employment rollup review

Roll up post-termination activity by process area so students can see where workforce-control failures appear.

Output

One row per process area and source table with counts of post-termination activity.

Main tables

Employee, PayrollRegister, TimeClockEntry, LaborTimeEntry, PurchaseRequisition, PurchaseOrder, PurchaseInvoice, CreditMemo, CustomerRefund, JournalEntry.

assignment ownership review

Review current-state master assignments that still point to inactive or terminated employees.

Output

One row per current-state assignment linked to an inactive or terminated employee.

Main tables

CostCenter, Warehouse, WorkCenter, Customer, Employee.

authority-limit review

Compare document approval amounts to approver limits and expected approver role families.

Output

One row per flagged approval event.

Main tables

PurchaseOrder, PurchaseInvoice, CreditMemo, CustomerRefund, JournalEntry, PayrollRegister, Employee.

item-status alignment review

Review current-state item master conflicts between lifecycle status and active-flag logic.

Output

One row per item with a current-state lifecycle or active-status conflict.

Main tables

Item.

roster-punch review

Find rostered days with no punch activity and punch activity without a valid roster assignment.

Output

One row per flagged roster or punch event.

Main tables

EmployeeShiftRoster, TimeClockEntry, TimeClockPunch, Employee.

overtime approval review

Identify approved worked overtime that is missing a linked overtime approval or exceeds the approved amount.

Output

One row per flagged time-clock entry.

Main tables

TimeClockEntry, OvertimeApproval, Employee, WorkCenter.

absence-time conflict review

Find rostered absences that still carry time summaries or raw punch activity.

Output

One row per conflicting absence record.

Main tables

EmployeeAbsence, EmployeeShiftRoster, TimeClockEntry, TimeClockPunch, Employee.

punch-sequence review

Detect incomplete punch sets and punch sequences with invalid ordering.

Output

One row per flagged time-clock entry.

Main tables

TimeClockPunch, TimeClockEntry, Employee.

post-termination roster review

Review roster rows scheduled after an employee's termination date.

Output

One row per invalid rostered day.

Main tables

EmployeeShiftRoster, Employee, TimeClockEntry, TimeClockPunch.

forecast-governance review

Review weekly forecasts that lack approval or show unusually large overrides.

Output

One row per flagged forecast row.

Main tables

DemandForecast, Item, Employee.

inventory-policy review

Review active inventory items that lack a current active policy or carry inactive policy rows.

Output

One row per policy exception.

Main tables

InventoryPolicy, Item, Warehouse, Employee.

planning-support review

Review replenishment documents that lack planning support.

Output

One row per unsupported requisition or work order.

Main tables

PurchaseRequisition, WorkOrder, Item.

recommendation-timing review

Review planning recommendations that converted after their need-by date.

Output

One row per late conversion.

Main tables

SupplyPlanRecommendation, PurchaseRequisition, WorkOrder, Item.

planning-lifecycle review

Review planning activity that occurs before launch or against discontinued inactive items.

Output

One row per planning-timing exception.

Main tables

DemandForecast, SupplyPlanRecommendation, PurchaseRequisition, WorkOrder, Item.

price-floor review

Identify sales lines priced below the configured floor without a valid override approval.

Output

One row per offending sales order line.

Main tables

SalesOrder, SalesOrderLine, PriceListLine, Customer, Item.

price-list validity review

Review price lists that are used after expiry or overlap another active list for the same scope.

Output

One row per expired-use or overlapping-scope exception.

Main tables

PriceList, PriceListLine, SalesOrder, SalesOrderLine.

promotion-scope review

Find sales lines that use a promotion outside the allowed date window or scope.

Output

One row per mismatched promoted sales line.

Main tables

SalesOrder, SalesOrderLine, PromotionProgram, Customer, Item.

customer-price review

Identify customer orders that bypass an available customer-specific price list.

Output

One row per bypassed sales order line.

Main tables

SalesOrder, SalesOrderLine, Customer, PriceList, PriceListLine.

override-approval review

Review override approvals that are incomplete or missing from override-priced sales lines.

Output

One row per incomplete approval or missing linked approval.

Main tables

PriceOverrideApproval, SalesOrderLine, SalesOrder, Customer, Item, PriceListLine.