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.

• 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

• change_last_statement_date_in_reconcile_bank_statement
• bank_register_report_sql

• sql_to_insert_missing_master_payment_records_into_journal

• sql_to_identify_out-of-balance_of_finance_charges
• sql_to_insert_missing_journal_activity_entry_for_finance_charge_on_order

• sql_report_of_avalara_taxes_paid_based_on_line_item_taxxml
• sql_report_for_simple_tax_report_by_order_from_the_gl

• 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
• 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

• 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

• Compress Macro IDs in a Data-set Using SQL
• Merge Macros from a Data-set Using SQL

• Order and Order Details Tree SQL
• Order Parts Grid SQL
• Batch close Orders in Sale with Balance Due

• Customer Sales for a Period SQL

• Employee Tree SQL

• 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

• Using SQL to Identify Column Differences Between Two Rows
• Purge Orers and Customeres using SQL
• Purge all Transaction for Test Company (Control 6.1)
• Purge all Transaction for Test Company (Control 5.75)
• Purge all Transaction for Test Company (OOBv2.78D)
• Purge all Transaction for Test Company (OOBv2.72)
• Using SQL to Delete Recurring Macro Activities
• Locate any Products or Open Orders with Products Using XSL Product Layouts
• Insert Missing Inactive Parts in OOBv2.85 ad OOBbv2.86
• Check and Repair Primary Keys

• Export cyriouswiki.com/aps to Quickbook SQL

• Security Rights Tree

• Copy Values Between SQL Tables with Different Structures
• Store Procedure: Copy a Table Between Databases
• Store Procedure: Restore a Backup
• Database Option: Numeric Roundabort