Simple Invoices - Forum

i recently got my brother going with this and one thing that may be an issue that i found with his and my install was the setting of real/draft for each invoice type under Settings>Invoice Preferences>Status>(real/draft). Real adds the amount to the sales totals and draft doesn't making your sales totals calculate only invoice types that are considered real (actually invoiced). I hope this helps and is not to late.

If this is not the case please let me know so i can help you further.

I have gone a head and tested this with my own installation. I found that even if its an estimate it shows up in debtors section of reports but the calculations are fine in the Sales reports. I will look at the php code for those pages. i cant promise anything cause im not a coder but i will try because this affects me as well.

Jeeez well so far I got the right SQL query using what is in the /modules/reports/report_debtors_by_amount.php and phpmyadmin and got a query that will not include the preference_id if it is equal to a certain number. I found the preference_id for estimates in si_preferences table so mine is 4. So if i don't want id for an estimate to show up in the "Debtors by Amount Owed" report then the MySQL query is this.

SELECT id from si_invoices WHERE preference_id !=4

Of course this doesn't scale to well if you have more than one type of preference_id you don't want included in your totals. As it is we have only 3 invoice preferences (estimates,receipts,invoices).

But when I try and edit the file to use that query the page says my syntax is incorrect and shows nothing at all. I tried it every way except the correct way.

This is what it looks like now.

else {
$sSQL = "SELECT
i.id, <---point of interest
....


I would put my query here but i made so many different versions it would just be confusing. Any suggestions or even a way to get a log of the error my queries are creating would be great. Thanks.