TRUNCATE `approve_indent`;
TRUNCATE `po_quotation`;
TRUNCATE `tbl_allocate_process`;
TRUNCATE `tbl_allocate_process_material`;
TRUNCATE `tbl_allocate_process_trn`;
TRUNCATE `tbl_allocate_re_process`;
TRUNCATE `tbl_allocate_re_process_trn`;
TRUNCATE `tbl_grn`;
TRUNCATE `tbl_grn_attch`;
TRUNCATE `tbl_grn_sub_trn`;
TRUNCATE `tbl_grn_trn`;
TRUNCATE `tbl_jobwork`;
TRUNCATE `tbl_jobworktrn`;
TRUNCATE `tbl_jobwork_history`;
TRUNCATE `tbl_jobwork_main`;
TRUNCATE `tbl_jobwork_process`;
TRUNCATE `tbl_job_work`;
TRUNCATE `tbl_job_work_sub_trn`;
TRUNCATE `tbl_job_work_trn`;
TRUNCATE `tbl_mrn`;
TRUNCATE `tbl_mrn_trn`;
TRUNCATE `tbl_pono`;
TRUNCATE `tbl_potrancation`;
TRUNCATE `tbl_potrntemp`;
TRUNCATE `tbl_po_grn_used`;
TRUNCATE `tbl_process_reserve_stock`;
TRUNCATE `tbl_process_stock_trn`;
TRUNCATE `tbl_purchaseorder`;
TRUNCATE `tbl_purchaseordertrn`;
TRUNCATE `tbl_purchaseorder_aprv_log`;
TRUNCATE `tbl_purchaseorder_req_trn`;
TRUNCATE `tbl_purchasetrntemp`;
TRUNCATE `tbl_qc`;
TRUNCATE `tbl_qc_param_trn`;
TRUNCATE `tbl_qc_process_trn`;
TRUNCATE `tbl_qc_trn`;
TRUNCATE `tbl_request_product`;
TRUNCATE `tbl_reserve_stock`;
TRUNCATE `tbl_sales_order`;
TRUNCATE `tbl_sales_ordertrn`;
TRUNCATE `tbl_sales_order_production_trn`;
TRUNCATE `tbl_set_main_process`;
TRUNCATE `tbl_so_aprv_log`;
TRUNCATE `tbl_stock_trn`;
TRUNCATE `tbl_work_order_resource_allocate`;
TRUNCATE `tbl_work_order_stock_transfer`;
TRUNCATE `tbl_work_order_stock_transfer_trn`;
TRUNCATE `tbl_wororder_product_process`;
TRUNCATE `tbl_pre`;
TRUNCATE `tbl_pre_trn`;
TRUNCATE `tbl_purchaseorder_finance_aprv_log`;
TRUNCATE `tbl_purchaseorder_aprv_log`;
TRUNCATE `tbl_purchaseorder_delivery_date`;

TRUNCATE TABLE `tbl_sale_return`;
TRUNCATE TABLE `tbl_sale_return_transaction`;
TRUNCATE TABLE `tbl_tcs_reverse`;
TRUNCATE TABLE `tbl_tcs_reverse_transaction`;
TRUNCATE TABLE `tbl_cost_center_transaction`;
TRUNCATE TABLE `tbl_bill_sundry_transaction`;
TRUNCATE TABLE `tbl_transport_transaction`;
TRUNCATE TABLE `tbl_ewaybill_transaction`;
TRUNCATE TABLE `tbl_tax_trn`;
TRUNCATE TABLE `tbl_invoice`;
TRUNCATE TABLE `tbl_invoicetrn`;
TRUNCATE TABLE `tbl_salesman_transaction`;
TRUNCATE TABLE `tbl_general_book`;
TRUNCATE TABLE `tbl_debitnote`;
TRUNCATE TABLE `tbl_debitnote_trn`;
TRUNCATE TABLE `mst_hsn_code`;
TRUNCATE TABLE `tbl_tax_category`;
TRUNCATE TABLE `tbl_tax_category_details`;
TRUNCATE TABLE `tbl_tds_tax_category`;
TRUNCATE TABLE `tbl_tds_tax_category_detail`;


TRUNCATE `tbl_followup`;
TRUNCATE `tbl_quotation`;
TRUNCATE `tbl_quotation_terms_trn`;
TRUNCATE `tbl_quotation_trn`;
TRUNCATE `tbl_quot_aprv_log`;
TRUNCATE `tbl_quot_dfd_attach`;
TRUNCATE `tbl_quot_payment_aprv_log`;
TRUNCATE `tbl_quot_payment_trn`;
TRUNCATE `tbl_quot_po_aprv_log`;
TRUNCATE `tbl_task`;
TRUNCATE `tbl_inquiry`;
TRUNCATE `tbl_inquiry_trn`;
TRUNCATE `tbl_inq_attach`;
TRUNCATE tbl_sales_order;
TRUNCATE tbl_sales_ordertrn;


delete from tbl_ledger where default_ledger!=1