======  ======



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]]
  * [[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/sql_-_adjust_reserved_inventory_levels_to_match_orders|Adjust Reserved Inventory Levels to Match Orders]]
  * [[transpart_description_update_sql]]
  * [[set_warehouse_summaries_unitids_and_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|Compress Macro IDs in a Data-set Using SQL]]
  * [[merge_macros_from_a_dataset_using_sql|Merge Macros from a Data-set Using SQL]]



==== Orders and Estimates ====
  * [[order_and_order_detail_tree_sql|Order and Order Details Tree SQL]]
  * [[order_parts_grid_sql|Order Parts Grid SQL]]
  * [[batch_close_orders_in_sale_with_balance_due|Batch close Orders in Sale with Balance Due]]



==== Sales ====
  * [[customer_sales_for_a_period_sql|Customer Sales for a Period SQL]]



==== Employee ====
  * [[Employee+Tree+SQL|Employee Tree SQL]]



==== Production Tracking ====
  * [[simple_production_tracking_on_orders_sql|Simple Production Tracking on Orders SQL]]
  * [[employee_time_card_data_sql|Employee Time Card Data SQL]]
  * [[employee_time_card_data_associated_with_line_items_sql|Employee Time Card Data Associated with Line Items SQL]]
  * [[station_time_tracking_data_sql|Station Time Tracking Data SQL]]



==== Dataset Queries & Cleanup ====
  * [[sql_to_identify_column_differences_between_two_rows|Using SQL to Identify Column Differences Between Two Rows]]
  * [[purge_orders_and_customers_using_sql|Purge Orers and Customeres using SQL]]
  * [[purge_all_transactions_for_test_company_control_6.1?rev=|Purge all Transaction for Test Company (Control 6.1)]]
  * [[purge_all_transactions_for_test_company_control_5.75?rev=|Purge all Transaction for Test Company (Control 5.75)]]
  * [[purge_all_transactions_for_test_company_oobv2.78d|Purge all Transaction for Test Company (OOBv2.78D)]]
  * [[purge_all_transactions_for_test_company_oobv2.72|Purge all Transaction for Test Company (OOBv2.72)]]
  * [[sql_-_delete_recurring_macro_activities|Using SQL to Delete Recurring Macro Activities]]
  * [[locate_any_products_or_open_orders_with_products_using_xsl_product_layouts|Locate any Products or Open Orders with Products Using XSL Product Layouts]]
  * [[insert_missing_inactive_parts_in_oobv2.85_and_oobv2.86|Insert Missing Inactive Parts in OOBv2.85 ad OOBbv2.86]]
  * [[check_and_repair_primary_keys|Check and Repair Primary Keys]]



==== Export ====
  * [[http://export_aps_to_quickbook_sql|Export cyriouswiki.com/aps to Quickbook SQL]]



==== Misc ====
  * [[Control+Security+Rights+Tree|Security Rights Tree]]



==== General Database Functionality ====
  * [[copy_values_between_sql_tables_with_different_structures|Copy Values Between SQL Tables with Different Structures]]
  * [[stored_procedure_-_copy_a_table_between_databases|Store Procedure: Copy a Table Between Databases]]
  * [[stored_procedure_-_restore_a_backup|Store Procedure: Restore a Backup]]
  * [[database_option_-_numeric_roundabort|Database Option: Numeric Roundabort]]