Merged Transaction Report


Notice: Line 15: Table 'healingr_content2.temp_transactions' doesn't exist

DELETE FROM `temp_transactions` WHERE `transactionid` > '' OR `transactionid` IS NULL; in /home/healingr/public_html/account/admin/accounting/mergedTransactionHistory.php on line 15

Notice: Line 45: Table 'healingr_content2.temp_transactions' doesn't exist

SELECT * FROM temp_transactions in /home/healingr/public_html/account/admin/accounting/mergedTransactionHistory.php on line 58
Transaction History For To or Search By Date
M D YYYY M D YYYY

Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, bool given in /home/healingr/public_html/account/admin/accounting/mergedTransactionHistory.php on line 337

Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, bool given in /home/healingr/public_html/account/admin/accounting/mergedTransactionHistory.php on line 387

Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, bool given in /home/healingr/public_html/account/admin/accounting/mergedTransactionHistory.php on line 546

Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, bool given in /home/healingr/public_html/account/admin/accounting/mergedTransactionHistory.php on line 744

Notice: Line 820: Table 'healingr_content2.temp_transactions' doesn't exist

SELECT date_only, DATE_FORMAT(STR_TO_DATE(temp_transactions.date_only, '%Y-%m-%d'), '%Y-%m') as year_month_date, DATE_FORMAT(STR_TO_DATE(temp_transactions.date_only, '%Y-%m-%d'), '%Y') as year_date, DATE_FORMAT(STR_TO_DATE(temp_transactions.date_only, '%Y-%m-%d'), '%m') as month_date, DATE_FORMAT(STR_TO_DATE(temp_transactions.date_only, '%Y-%m-%d'), '%d') as day_date, sum(donation) AS donation, sum(dues) AS dues, sum(webfees) AS webfees, sum(registration) AS registration, sum(scs) AS scs, sum(wa_scs) AS wa_scs, sum(hr_scs) AS hr_scs, sum(total) AS total FROM temp_transactions GROUP BY date_only ORDER BY date_only ASC in /home/healingr/public_html/account/admin/accounting/mergedTransactionHistory.php on line 842

Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, bool given in /home/healingr/public_html/account/admin/accounting/mergedTransactionHistory.php on line 855
Date Donation Dues Web Fees Registration SCS WA SCS HR SCS Total
Total: $0 $0 $0 $0 $0 $0 $0 $0

*These totals include sales tax.  

Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, bool given in /home/healingr/public_html/account/admin/accounting/mergedTransactionHistory.php on line 990

Notice: Line 1047: Table 'healingr_content2.temp_products_sold' doesn't exist

DELETE FROM `temp_products_sold` WHERE `rowid` > '' OR `rowid` IS NULL; in /home/healingr/public_html/account/admin/accounting/mergedTransactionHistory.php on line 1053

Notice: SELECT Error line 1076: Table 'healingr_content2.temp_products_sold' doesn't exist in /home/healingr/public_html/account/admin/accounting/mergedTransactionHistory.php on line 1082

Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, bool given in /home/healingr/public_html/account/admin/accounting/mergedTransactionHistory.php on line 1095

Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, bool given in /home/healingr/public_html/account/admin/accounting/mergedTransactionHistory.php on line 1119

Warning: mysqli_fetch_row() expects parameter 1 to be mysqli_result, bool given in /home/healingr/public_html/account/admin/accounting/mergedTransactionHistory.php on line 1133

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, bool given in /home/healingr/public_html/account/admin/accounting/mergedTransactionHistory.php on line 1155