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
  • control_sql_-_find_gl_out_of_balances
  • control_sql_-_gl_out_of_balance_by_order
  • control_sql_-_find_an_order_number_with_the_transaction_id
  • control_sql_-_balance_sheet_or_journal_out_of_balance
  • control_sql_-_plug_all_journal_out_of_balance_entries
  • Plug all A.cyriouswiki.com/r_balances_for_orders_not_in_sale
• control_sql_-_gl_balance_integrity_checks
  • control_sql_-_customer_credit_balance_integrity_check
  • control_sql_-_vendor_credit_balance_integrity_check
  • control_sql_-_order_deposit_integrity_check
  • A.cyriouswiki.com/r_integrity_check
  • A.cyriouswiki.com/p_integrity_check
  • control_sql_-_wip_and_built_integrity_check
• control_sql_-_invalid_gl_entries
• control_sql_-_payments_gl_integrity_check
• control_sql_-_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_large_variances_in_inventorylog_unit_costs
• control_sql_-_fill_in_zero_unit_costs_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