|
I have checked the file include/billing.inc.php with PHPDesigner2007 as debugging editor; it reports no errors. But from Citrus menu, print invoices causes error (at the end of the function add_taxdetails(), which is quoted below, for context. Here is the block of code, ending with "die" and a modified error message. function add_taxdetails($DB, $billingdate, $bybillingid, $billingmethod, $batchid) { /*--------------------------------------------------------------------*/ // Add taxes to the bill // database connector, billing date, billing method (invoice, prepay , // creditcard etc.), batch id // do this before services to make sure one time services get taxed // before they are removed /*--------------------------------------------------------------------*/ // // query for taxed services that are billed on the specified date // or a specific billing id // if ($bybillingid == NULL) { $query = "SELECT ts.id ts_id, ts.master_services_id ts_serviceid, ts.tax_rate_id ts_rateid, ms.id ms_id, ms.service_description ms_description, ms.pricerate ms_pricerate, ms.frequency ms_freq, tr.id tr_id, tr.description tr_description, tr.rate tr_rate, tr.if_field tr_if_field, tr.if_value tr_if_value, us.master_service_id us_msid, us.billing_id us_bid, us.removed us_removed, us.account_number us_account_number, us.usage_multiple us_usage_multiple, te.account_number te_account_number, te.tax_rate_id te_tax_rate_id, b.id b_id, b.billing_type b_billing_type, t.id t_id, t.frequency t_freq, t.method t_method FROM taxed_services ts LEFT JOIN user_services us ON us.master_service_id = ts.master_services_id LEFT JOIN master_services ms ON ms.id = ts.master_services_id LEFT JOIN tax_rates tr ON tr.id = ts.tax_rate_id LEFT JOIN tax_exempt te ON te.account_number = us.account_number AND te.tax_rate_id = tr.id LEFT JOIN billing b ON us.billing_id = b.id LEFT JOIN billing_types t ON b.billing_type = t.id WHERE b.next_billing_date = '$billingdate' AND t.method = '$billingmethod' AND us.removed <> 'y'"; } else { $query = "SELECT ts.id ts_id, ts.master_services_id ts_serviceid, ts.tax_rate_id ts_rateid, ms.id ms_id, ms.service_description ms_description, ms.pricerate ms_pricerate, ms.frequency ms_freq, tr.id tr_id, tr.description tr_description, tr.rate tr_rate, tr.if_field tr_if_field, tr.if_value tr_if_value, us.master_service_id us_msid, us.billing_id us_bid, us.removed us_removed, us.account_number us_account_number, us.usage_multiple us_usage_multiple, te.account_number te_account_number, te.tax_rate_id te_tax_rate_id, b.id b_id, b.billing_type b_billing_type, t.id t_id, t.frequency t_freq, t.method t_method FROM taxed_services ts LEFT JOIN user_services us ON us.master_service_id = ts.master_services_id LEFT JOIN master_services ms ON ms.id = ts.master_services_id LEFT JOIN tax_rates tr ON tr.id = ts.tax_rate_id LEFT JOIN tax_exempt te ON te.account_number = us.account_number AND te.tax_rate_id = tr.id LEFT JOIN billing b ON us.billing_id = b.id LEFT JOIN billing_types t ON b.billing_type = t.id WHERE b.id = '$bybillingid' AND us.removed <> 'y'"; } $DB->SetFetchMode(ADODB_FETCH_ASSOC); $taxresult = $DB->Execute($query) or die ("Taxes Query Failed; Citrus 103") ; $taxresult produces the die side of the ''or' statement Could it be a problem with the $DB variable? How can I check it, please? ----------------------------------------------------------------------------- Michael Rulison | 919/782-9576 Raleigh NC 27607-6723 ----------------------------------------------------------------------------- |
------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________ Citrusdb-users mailing list Citrusdb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/citrusdb-users
