Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
control_sql_-_queries_to_identify_problems [2019/02/05 11:25] admin [GL Queries] |
control_sql_-_queries_to_identify_problems [2019/08/09 17:11] (current) vsouvannarath [Inventory Queries] |
||
|---|---|---|---|
| Line 8: | Line 8: | ||
| ===== Account Reconciliation Queries ===== | ===== Account Reconciliation Queries ===== | ||
| - | * [[control_sql_-_query_to_breakdown_reconciliation_entries]] | + | * [[control_sql_-_query_to_breakdown_reconciliation_entries|Control SQL - Query to Breakdown Reconciliation Entries]] |
| * [[control_sql_-_queries_to_search_for_reconciliation_problems|Control SQL - Queries to Search for Reconciliation Problems]] | * [[control_sql_-_queries_to_search_for_reconciliation_problems|Control SQL - Queries to Search for Reconciliation Problems]] | ||
| Line 14: | Line 14: | ||
| ===== Artwork Approval Queries ===== | ===== Artwork Approval Queries ===== | ||
| - | * [[control_sql_-_move_all_open_artwork_groups_to_produced]] | + | * [[control_sql_-_move_all_open_artwork_groups_to_produced|Control SQL - Move all Open Artwork Groups to Produced]] |
| ===== Credit Card Processing Queries ===== | ===== Credit Card Processing Queries ===== | ||
| - | * [[control_sql_-_identify_credit_cards_processed_but_not_saved]] | + | * [[control_sql_-_identify_credit_cards_processed_but_not_saved|Control SQL - Identify Credit Cards Processed but Not Saved]] |
| ===== Customer Queries ===== | ===== Customer Queries ===== | ||
| - | * [[control_sql_-_change_prospect_to_client]] | + | * [[control_sql_-_change_prospect_to_client|Control SQL - Change Prospect to Client]] |
| - | * [[control_sql_-_duplicate_companies]] | + | * [[control_sql_-_duplicate_companies|Control SQL - Duplicate Companies]] |
| - | * [[control_sql_-_customer_write_offs]] | + | * [[control_sql_-_customer_write_offs|Control SQL - Customer Write Offs]] |
| ===== GL Account Queries ===== | ===== GL Account Queries ===== | ||
| - | * [[control_sql_-_direct_cost_from_bills_details]] | + | * [[control_sql_-_direct_cost_from_bills_details|Control SQL - Direct Cost from Bills Details]] |
| - | * [[control_sql_-_check_that_gl_accounts_are_under_valid_categories]] | + | * [[control_sql_-_check_that_gl_accounts_are_under_valid_categories|Control SQL - Check That GL Accounts are Under Valid Categories]] |
| - | * [[control_sql_-_shows_payments_that_went_into_each_deposit]] | + | * [[control_sql_-_shows_payments_that_went_into_each_deposit|Control SQL - Shows Payments That Went Into Each Deposit]] |
| - | * [[control_sql_-_shows_amounts_from_undeposited_funds_by_division_for_each_deposit]] | + | * [[control_sql_-_shows_amounts_from_undeposited_funds_by_division_for_each_deposit|Control SQL - Shows Amounts from Undeposited Funds by Division for Each Deposit]] |
| - | * [[control_sql_-_find_off-of-balance_sheet_issues]] | + | * [[control_sql_-_find_off-of-balance_sheet_issues|Control SQL - Find Off-of-Balance Sheet Issues]] |
| - | * [[control_sql_-_invalid_gl_account_error]] | + | * [[control_sql_-_invalid_gl_account_error|Control SQL - Invalid GL Account Error]] |
| - | * [[control_sql_-_identify_doubled_gl_from_bug_with_posting_payment_and_sale_simultaneously]] | + | * [[control_sql_-_identify_doubled_gl_from_bug_with_posting_payment_and_sale_simultaneously|Control SQL - Identify Doubled GL from Bug with Posting Payment and Sale Simultaneously]] |
| Line 53: | Line 53: | ||
| * [[control_sql_-_vendor_credit_balance_integrity_check|Vendor Credit Balance Integrity Check]] | * [[control_sql_-_vendor_credit_balance_integrity_check|Vendor Credit Balance Integrity Check]] | ||
| * [[control_sql_-_order_deposit_integrity_check|Order Deposit Integrity Check]] | * [[control_sql_-_order_deposit_integrity_check|Order Deposit Integrity Check]] | ||
| - | * [[control_sql_-_ar_integrity_check|A/ | + | * [[control_sql_-_ar_integrity_check|A/ |
| - | * [[control_sql_-_ap_integrity_check|A/ | + | * [[control_sql_-_ap_integrity_check|A/ |
| * [[control_sql_-_wip_and_built_integrity_check|WIP and Built Integrity Check]] | * [[control_sql_-_wip_and_built_integrity_check|WIP and Built Integrity Check]] | ||
| - | * [[control_sql_-_invalid_gl_entries]] | + | * [[control_sql_-_invalid_gl_entries|Invalid GL Entries]] |
| - | * [[control_sql_-_payments_gl_integrity_check]] | + | * [[control_sql_-_payments_gl_integrity_check|Payments GL Integrity Check]] |
| - | * [[control_sql_-_resequence_the_gl_table]] | + | * [[control_sql_-_resequence_the_gl_table|Resequence the GL Table]] |
| ===== Identify Refresh Problem Queries ===== | ===== Identify Refresh Problem Queries ===== | ||
| - | * [[control_sql_-_log_records_saved_without_changing_seqid]] | + | * [[control_sql_-_log_records_saved_without_changing_seqid|Control SQL - Log Records Saved without Changing SeqID]] |
| - | * [[control_sql_-_log_database_record_locks_every_few_minutes]] | + | * [[control_sql_-_log_database_record_locks_every_few_minutes|Control SQL - Log Database Record Locks Every Few Minutes]] |
| Line 70: | Line 70: | ||
| ===== Inventory Queries ===== | ===== Inventory Queries ===== | ||
| * [[control_sql_-_invalid_gl_account_error]] to fix Computed GL Accounts not properly converted to Off-Balance Sheet | * [[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_-_find_large_variances_in_inventorylog_unit_costs|Control SQL - Find Larger Variances in Inventory Log Unit Costs]] |
| - | * [[control_sql_-_fill_in_zero_unit_costs_in_inventory_log]] | + | * [[control_sql_-_fill_in_zero_unit_costs_in_inventory_log|Control SQL - Fill in Zero Unit Cost in Inventory Log]] |
| - | * [[control_sql_-_create_inventorylog_and_gl_entries_to_balance_historical_inventory]] | + | * [[control_sql_-_create_inventorylog_and_gl_entries_to_balance_historical_inventory|Control SQL - Create Inventory Log and GL Entries to Balance Historical Inventory]] |
| - | * [[control_sql_-_reclassify_historic_inventory_adjustments_to_the_parts_expense_account]] | + | * [[control_sql_-_reclassify_historic_inventory_adjustments_to_the_parts_expense_account|Control SQL - Reclassify Historic Inventory Adjustments to the Part Expense Account]] |
| - | * [[control_sql_-_add_function_to_compare_inventory_totals_to_log_records]] | + | * [[control_sql_-_add_function_to_compare_inventory_totals_to_log_records|Control SQL - Add Function to Compare Inventory Totals to Log Records]] |
| - | * [[control_sql_-_create_inventorylog_records_so_they_match_inventory]] | + | * [[control_sql_-_create_inventorylog_records_so_they_match_inventory|Control SQL - Create Inventory Log Records so They Match Inventory]] |
| - | * [[control_sql_-_fix_inventorylog_to_point_to_proper_inventory_record]] | + | * [[control_sql_-_fix_inventorylog_to_point_to_proper_inventory_record|Control SQL - Fix Inventory Log to Point to Proper Inventory |
| - | * [[control_sql_-_adjust_reserved_inventory_levels_to_match_orders]] | + | * [[control_sql_-_adjust_reserved_inventory_levels_to_match_orders|Control SQL - Adjust Reserved Inventory Levels to Match Orders]] |
| - | * [[control_sql_-_look_for_gl_adjustment_entries_on_parts_not_inventoried]] | + | * [[control_sql_-_look_for_gl_adjustment_entries_on_parts_not_inventoried|Control SQL - Look for GL Adjustments Entries on Part not Inventoried]] |
| - | * [[control_sql_-_check_inventory_on-order_levels_v_ordered_pos]] | + | * [[control_sql_-_check_inventory_on-order_levels_v_ordered_pos|Control SQL - Check Inventory On-Order Levels vs Ordered POS]] |
| * [[control_sql_-_check_all_inventory_levels_v_all_inventory_logs]] | * [[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_-_fix_incorrect_gl_inventory_and_cost_entries_when_wip_orders_voided]] | ||