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_inventorylog_and_gl_entries_to_balance_historical_inventory
• control_sql_-_reclassify_historic_inventory_adjustments_to_the_parts_expense_account
• control_sql_-_add_function_to_compare_inventory_totals_to_log_records
• control_sql_-_create_inventorylog_records_so_they_match_inventory
• control_sql_-_fix_inventorylog_to_point_to_proper_inventory_record
• control_sql_-_adjust_reserved_inventory_levels_to_match_orders
• control_sql_-_look_for_gl_adjustment_entries_on_parts_not_inventoried
• control_sql_-_check_inventory_on-order_levels_v_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