Simple Invoices - Forum

Hi there,

Long time no speak, I have been fairly busy myself. The issue is that I am using the simpleinvoicig system as probably others are as a financial history document and also a bit of a crm solution. Whilst I enjoy the nice interface all the data is begining to slow the process down a little. I don't know if anyone else is having this issue at all. essential its now taking 4-5 seconds for the page to load and I am not really sure of the link I am clicking in the manage invoices section until its all loaded.

I only have around 250 invoices in total which for some of the users here is like a months work, but I could really use a more streamlined approach to the manage invoices page. I've just just purchases a new PC ( nout special) but I will obviously wait and see how that pans out.

I was thinking that perhaps re-introduce paging or put an option in to enable/disable it.

Also for all those windoze users out there who are from an access background. I have written a few tools which might be of interest. they were to me and I use the mysql driver and access to run a few reports. Its reporting only but I am using it to track remind me of.

-What, who, and how much I billed last month
-Product breakdowns / Margins (Create a linked table to a purchase price and therefore shows how effective you are at selling

I would love to code these things in PHP but it's a steep learning curve I hope once its all working to pass it around and perhaps just give people ideas for including it into SI, or not

Hey Stu

good to hear from you again

re manage invoices page
- yep with 100s of invoices it currently takes to long to load
- once we swap over to extjs properly we'll introduce paging/filtering/sorting in the grid - this way the page should load very quick as it wont have to display all 250 invoices - just the first screen on invoices

re reports
- we currently use phpreports ( http://phpreports.sf.net ) to make the reports in Simple Invoices
- if you know basic sql and html then its quite easy to create reports for Simple Invoices

to create a report
- just copy an existing file ie. ./modules/reports/report_sales_total.php
- and copy the relateing xml file ./modules/reports/xml/report_sales_total.xml
- edit the php file and replace the existing sql query with yours
ie. from
$sSQL = "select sum(".TB_PREFIX."invoice_items.total) as Total from ".TB_PREFIX."invoice_items";
$oRpt = new PHPReportMaker();

$oRpt->setXML("./modules/reports/xml/report_sales_total.xml")

to
$sSQL = "select average(".TB_PREFIX."invoice_items.total) as Average from ".TB_PREFIX."invoice_items";
$oRpt = new PHPReportMaker();

$oRpt->setXML("./modules/reports/xml/stues_reportl.xml")


then edit the .xml file (which controls the reports layout) and update the fields etc.

as you might need to edit the menu or home page and put in a link to that report

but if you could post that access stuff here im sure it would help some other windows users
- you can attach files to our google group page
http://groups.google.com/group/simpleinvoices/files

Cheers

Justin

Hey, I am excited about your proposed update with extjs and multiplicity, etc. Are you going the ability to add different tax codes to different product items such as the ability to charge labor/services with no tax and yet be able to tax product/materials within the same invoice? Also is there a way that the invoice form, estimate form, order form can be easily modified to add terms, conditions and legal stuff? Thanks. Heath G

Hey Heath

re exjs
- thanks - it will be a big change re UI but i think it will help Simple Invoices alot

re different tax codes
- this wont be implemented in the next release
- im still thinking about this and also discounts per item
-- just dont want to have to many drop down menu etc on the new invoice screen as it'll get messay and confusing quickly

re modify the forms
- you can either just edit the invoice preference and update the "Invoice detail line" or the payment lines with your own terms
- or if your game - you can edit the template files themselves and add whatever you want in
-- refer: http://simpleinvoices.org/wiki/doku.php?id=templates

Cheers

Justin