====== {$page} ======

This page is intended to serve as a central repository for customized reports and for SQLs (which can be used as SQL reports)that have been written to pull information from the system.

===== Crystal Reports =====

===== SQLs =====

==== Accounting ====

  * [[:gl_listing_by_batch_sql|]]
  * [[:gl_account_tree_sql|]]
  * [[:gl_ledger_totals_by_month_sql|]]
  * [[:trial_balance_sql_report|]]
  * [[:balance_sheet_sql_report|]]
  * [[:income_statement_sql_report|]]
  * [[:glaccounttree_sql_function|]]
  * [[:ar_sql_report|]]
  * [[:cost_of_wip_built_breakdown_sql_report|]]
  * [[:income_from_miscellaneous_non-order_receipts_sql_report|]]
  * [[:merge_divisions_sql|]]
  * [[:direct_cost_from_bills_repair|]]

==== Banking ====

  * [[:change_last_statement_date_in_reconcile_bank_statement|]]
  * [[:bank_register_report_sql|]]

==== Payments ====

  * [[:sql_to_insert_missing_master_payment_records_into_journal|]]

==== Finance Charges ====

  * [[:sql_to_identify_out-of-balance_of_finance_charges|]]
  * [[:sql_to_insert_missing_journal_activity_entry_for_finance_charge_on_order|]]

==== Taxes ====

  * [[:sql_report_of_avalara_taxes_paid_based_on_line_item_taxxml|]]
  * [[:sql_report_for_simple_tax_report_by_order_from_the_gl|]]

==== Inventory ====

  * [[:inventory_valuation_sql|]]
  * [[:historic_inventory_valuation_sql|Historic inventory_valuation_sql]]
  * [[:inventory_asset_account_valuation_sql|]]
  * [[:historic_inventory_asset_account_valuation_sql|Historic inventory_asset_account_valuation_sql]]
  * [[:historic_inventory_tracking_sql|]]
  * [[:inventory_out_of_balance_repair_sqls|]]
  * [[:remove_auto-generated_material_usage|]]
  * [[:inventory_out_of_balance_repair|]]
  * [[http://@support.cyriouswiki.com/http://support.cyriouswiki.com/Control+SQL+-+Adjust+Reserved+Inventory+Levels+to+Match+Orders%7CAdjust+Reserved+Inventory+Levels+to+Match+Orders|Adjust Reserved Inventory Levels to Match Orders]]
  * [[:transpart_description_update_sql|]]
  * [[:set_warehouse_summaries_unitids_and_unittypes|Update Warehouse Summaries UnitIDs & UnitTypes]]
  * [[:reset_all_warehouses_back_to_default_sql|]]
  * [[:merge_duplicate_inventory_items|]]
  * [[:merge_duplicate_inventory_summaries|]]
  * [[:negative_quantity_received_only_repair|]]
  * [[:compare_on-order_po_line_items_and_on-order_inventory_quantites|]]

==== Products, Modifiers and Parts ====

  * [[:product_tree|]]
  * [[:modifier_tree_sql|]]
  * [[:parts_tree_sql|]]
  * [[:update_averagecost_on_inventory_to_match_unitcost_on_part|]]
  * [[:merge_product_dataset_using_sql|]]
  * [[:income_accounts_by_product_sql|]]
  * [[:identify_part_udf_differences_between_two_databases|]]
  * [[:delete_duplicate_catalog_items_from_vendors|]]

**Part Usage Cards**

  * [[:copy_stationid_from_time_card|]]

==== Marketing Import ====

  * [[:compress_macro_ids_in_a_dataset_using_sql|]]
  * [[:merge_macros_from_a_dataset_using_sql|]]

==== Orders and Estimates ====

  * [[:order_and_order_detail_tree_sql|]]
  * [[:order_parts_grid_sql|]]
  * [[:batch_close_orders_in_sale_with_balance_due|]]

==== Sales ====

  * [[:customer_sales_for_a_period_sql|]]

==== Employee ====

  * [[:employee_tree_sql|]]

==== Production Tracking ====

  * [[:simple_production_tracking_on_orders_sql|]]
  * [[:employee_time_card_data_sql|]]
  * [[:employee_time_card_data_associated_with_line_items_sql|]]
  * [[:station_time_tracking_data_sql|]]

==== Dataset Queries & Cleanup ====

  * [[:sql_to_identify_column_differences_between_two_rows|]]
  * [[:purge_orders_and_customers_using_sql|]]
  * [[:purge_all_transactions_for_test_company_control_6.1|]]
  * [[:purge_all_transactions_for_test_company_control_5.75|]]
  * [[:purge_all_transactions_for_test_company_oobv2.78d|Purge all Transactions for Test Company (OOBv2.78D+)]]
  * [[:purge_all_transactions_for_test_company_oobv2.72|Purge all Transactions for Test Company (OOBv2.72 to v2.78C)]]
  * [[:sql_-_delete_recurring_macro_activities|Delete Recurring Macro Activities]]
  * [[:locate_any_products_or_open_orders_with_products_using_xsl_product_layouts|]]
  * [[:insert_missing_inactive_parts_in_oobv2.85_and_oobv2.86|]]
  * [[:check_and_repair_primary_keys|]]

==== Export ====

  * [[http://Export APs to QuickBook SQL|Export A.cyriouswiki.com/Ps+to+QuickBook+SQL]]

==== Misc ====

  * [[:control_security_rights_tree|]]

==== General Database Functionality ====

  * [[:copy_values_between_sql_tables_with_different_structures|]]
  * [[:stored_procedure_-_copy_a_table_between_databases|]]
  * [[:stored_procedure_-_restore_a_backup|]]
  * [[:database_option_-_numeric_roundabort|]]

===== See Also =====

  * Backlinks [[:include_pagepage_componentbacklinks|]]