Control SQL Queries to Identify Problems

This section is to record queries that might be useful to find, analyze, and fix potential errors in the database.

• Control SQL - Query to Breakdown Reconciliation Entries
• Control SQL - Queries to Search for Reconciliation Problems

• Control SQL - Move all Open Artwork Groups to Produced

• Control SQL - Identify Credit Cards Processed but Not Saved

• Control SQL - Change Prospect to Client
• Control SQL - Duplicate Companies
• Control SQL - Customer Write Offs

• Control SQL - Direct Cost from Bills Details
• Control SQL - Check That GL Accounts are Under Valid Categories
• Control SQL - Shows Payments That Went Into Each Deposit
• Control SQL - Shows Amounts from Undeposited Funds by Division for Each Deposit
• Control SQL - Find Off-of-Balance Sheet Issues
• Control SQL - Invalid GL Account Error
• Control SQL - Identify Doubled GL from Bug with Posting Payment and Sale Simultaneously

• GL Out of Balance
  • All GL Out of Balances
  • GL Out of Balance By Order
  • Find an Order Number with the TransactionID
  • Balance Sheet or Journal Out of Balance
  • Plug all Journal OOB Entries
  • Plug all AR Balances for Orders Not In Sale
• GL Balance Integrity Check Summary
  • Customer Credit Balance Integrity Check
  • Vendor Credit Balance Integrity Check
  • Order Deposit Integrity Check
  • A/R Integrity Check
  • A/P Integrity Check
  • WIP and Built Integrity Check
• Invalid GL Entries
• Payments GL Integrity Check
• Resequence the GL Table

• Control SQL - Log Records Saved without Changing SeqID
• Control SQL - Log Database Record Locks Every Few Minutes

• control_sql_-_invalid_gl_account_error to fix Computed GL Accounts not properly converted to Off-Balance Sheet
• Control SQL - Find Larger Variances in Inventory Log Unit Costs
• Control SQL - Fill in Zero Unit Cost in Inventory Log
• Control SQL - Create Inventory Log and GL Entries to Balance Historical Inventory
• Control SQL - Reclassify Historic Inventory Adjustments to the Part Expense Account
• Control SQL - Add Function to Compare Inventory Totals to Log Records
• Control SQL - Create Inventory Log Records so They Match Inventory
• Control SQL - Fix Inventory Log to Point to Proper Inventory Record
• Control SQL - Adjust Reserved Inventory Levels to Match Orders
• Control SQL - Look for GL Adjustments Entries on Part not Inventoried
• Control SQL - Check Inventory On-Order Levels vs Ordered POS
• control_sql_-_check_all_inventory_levels_v_all_inventory_logs
• control_sql_-_fix_incorrect_gl_inventory_and_cost_entries_when_wip_orders_voided
• control_sql_-_identify_manual_postings_to_inventory_gl_accounts
• control_sql_-_identify_missing_inventory_entries

• control_sql_-_query_to_fix_gl_entries_without_depositjournalid
• control_sql_-_identify_imbalances_in_make_deposit_entries
• control_sql_-_identify_deposits_in_a_make_deposit_batch

• control_sql_-_historical_wip_report
• control_sql_-_historical_built_report
• control_sql_-_historical_deposits_report
• control_sql_-_historical_customer_credit_report
• control_sql_-_shipment_items
• control_sql_-_find_negative_balance_due_orders

• control_sql_-_version_history
• control_sql_-_recently_modified_records
• control_sql_-_sql_server_processes
• control_sql_-_sql_server_table_indexes
• control_sql_-_sql_server_primary_keys
• control_sql_-_sql_server_foreign_keys
• control_sql_-_sql_server_expensive_queries
• control_sql_-_query_to_determine_oob_dataset_version
• control_sql_-_query_for_evaluation_days_left_on_sql