Simple Invoices Blog

Follow this blog via Email or RSS

Simple Invoices 2010.2 Beta 6 released!

Hi Guys,

I'm very happy to announce the availability of Simple Invoices 2010.2 Beta 6 release!

Also very happy to welcome Steve Roddis & Harvinder Singh as Simple Invoices developers - thanks for your great work with this release!

You can grab the download from:

Whats new:

  • Process payment page redone - no more crappy autocomplete
  • Payments - updated to work with the new Invoice ID system
  • Product unit price fomatting update to fix that tax calculation issue with 3+ decimal place product prices
  • Updated French translation
  • Upgraded Zend Framework to 1.10.4
  • Add php logging option
  • Upgrade to the SQL Patch system
  • Minor Eway upgrade
  • Statement upgrade - date filter and logging issues
  • Inventory update
  • Installer updated - now works with different table prefixes
  • Installer json data and sql fiels updated
  • Fixed lots of XSS flaws. Pretty much all output/data is now escaped.

Note:

  • The language setting gets reset to English (en_GB) in this release

Documentation:

If you have any issues or queries please post in the forum:

Cheers

Justin

Simple Invoices 2010.2 Beta 5 released!

Hi Guys,

I'm very happy to announce the availability of Simple Invoices 2010.2 Beta 5 release!

You can grab the download from:

Whats new:

  • fixed IE manage payments problem
  • adjusted and fixed issue with login page
  • fixed custom_field1 problem
  • fixed export to Word in quick view problem
  • fixed French translation so that the manage grids now work
  • fixed preferences status save problem
  • fixed issue with blank Simple Invoices - now warns if cache folder not writeable
  • change to config - just use config/custom.config.ini if you want a version of config.ini that is not in svn
  • fixed issue with rounding number with lots of decimal places in invoice creation/editing
  • fixed email as PDF invoice name/id

Documentation:

Known issues:

  • Automatic installer might not work 100% - best bet is to manually import the Simple_Invoices_Full.sql file for new dbs

If you have any issues or queries please post in the forum:

Cheers

Justin

Simple Invoices 2010.2 Beta 4 released

Hi Guys,

Simple Invoices 2010.2 Beta 4 has been released.

You can grab the download from:

Whats new:

  • fixed preferences save problem with beta 3
  • fixed products save problem with beta 3
  • fixed email as PDF 0kb sized attachments issue
    • note: some more work on this re utf8 needs to be done
  • fixed issue with installer not importing the correct data in beta 3 which caused some issues re saving stuff
  • minor edit to paypal code to make
  • added indexes on a few fields in the database to speed up the manage payments page when has 100s of records

Documentation:

Known issues:

  • Not all of the issues with Simple Invoices 2010.2 beta 2&3 were resolved with this release - refer http://code.google.com/p/simpleinvoices/wiki/todo
  • Automatic installer might not work 100% - best bet is to manually import the Simple_Invoices_Full.sql file for new dbs
  • French translation - the manage grids don't work

If you have any issues or queries please post here in the forum:

Cheers

Justin

Simple Invoices 2010.2 Beta 3 released

Hi Guys,

Simple Invoices 2010.2 Beta 3 has been released.

You can grab the download from:

This issue fixes a few issues from the beta 1 release include:

  • fixed add user no role problem
  • fixed decimal place - missing zeros problem
  • fixed cron ACL issue
  • fixed expense extension/2010.2 issues

Documentation:

Known issues:

  • Not all of the issues with Simple Invoices 2010.2 beta 2 were resolved with this release - refer http://code.google.com/p/simpleinvoices/wiki/todo
  • Automatic installer might not work 100% - best bet is to manually import the Simple_Invoices_Full.sql file for new dbs
  • French translation - the manage grids don't work

If you have any issues or queries please post in the forum:

Cheers

Justin

Simple Invoices featured in Linux User magazine

Hi Guys,

just a quick note to let you know that Simple Invoices has been written up in the Linux User magazine Issue 85

thanks linux user for the nice review!

The main issue they have with Simple Invoices is that you have to install it on your own server. I would put this as a Pro rather than Con

To counter the issue of this being an issues i'm now offering Simple Invoices hosting via www.smarterinvoices.com

  • This way if your not familiar with the LAMP setup, all you have to so go get Simple Invoices up and running is sign up and its all taken care of for you

refer:

now off to find a copy of issue 85 somewhere

let me know if you have any queries

Cheers

Justin

Simple Invoices 2010.2 Beta 2 released

Hi Guys,

Simple Invoices 2010.2 Beta 2 has been released.

You can grab the download from:

This issue fixes a few issues from the beta 1 release include:

Documentation:

Known issues:

  • Automatic installer might not work 100% - best bet is to manually import the Simple_Invoices_Full.sql file for new dbs
  • French translation - the manage grids don't work

If you have any issues or queries please post in the forum:

Cheers

Justin

Simple Invoices 2010.2 beta 1 released

Hi Guys

I'm very pleased to announce the availability of Simple Invoices 2010.2 Beta 1 release

You can grab the download from:

The 2010.2 release of Simple Invoices will include a number of much requested features like PayPal and Recurring invoices etc..

Whats new:

Documentation:

Known issues:

  • Automatic installer might not work 100% - best bet is to manually import the Simple_Invoices_Full.sql file for new dbs
  • French translation - the manage grids don't work

If you have any issues or queries please post in the forum:

Cheers

Justin

UX Guru redesigns SimpleInvoices.org site

Hi Guys,

Thanks to a thread on Hacker News, UX guru Jason Strachan : http://www.jasonstrachan.com has donated a days work to redesign the Simple Invoices home page.

Heres the current design - http://simpleinvoices.org

and heres the proposed design - http://jasonstrachan.com/clients/simpleinvoices/

I really like the design - the header menu/logo is negotiable but i love the rest. Let me know your thoughts on the design!

Now for the fun part - converting the design (psd files below) into html/css reality. I'm normally fine doing this but an flat out trying to finish some features for Simple Invoices 2010.2 and some real world stuff ( new baby, new job, selling & buying a house/etc..)

If anyone is interested in helping out with the html/css grab the psd from below and give it a go - Really would love to implement this design asap


refer:


Cheers

Justin

Simple Invoices 2010.1 released

Hi Guys,

Simple Invoices 2010.1 has been release

Grab the download from : http://simpleinvoices.googlecode.com/files/simpleinvoices.2010.1.zip

Whats new:

  • update Zend Framework to version 1.9.6
  • updated include paths - this may resolve some peoplse blank page issues
  • fix Zend AutoLoader errors for WAMP/MAMP/XAMMP users - now works fine works with ZF 1.9.6

Documentation:

Known issues:

  • French translation - the manage grids don't work
  • Some reports have sql errors

If you have any issues or queries please post in the forum: http://simpleinvoices.org/forum/discussion/984/simple-invoices-20101-released/

Cheers

Justin

Simple Invoices 2009.1 update 1 released!

Hi Guys,

Simple Invoices 2009.1 update 1 has been release

Grab the download from : http://simpleinvoices.googlecode.com/files/simpleinvoices.2009.1.update-1.zip

Whats new:

  • DB uft8 change
    • New config.ini option “database.uft8”
    • If you have any problem re data you've inputted with non-latin characters set this to false and retry
  • Rounding in invoices problem fixed
  • Extensions - if login is enabled problem fixed
  • Expense extension - if login is enabled problem fixed

Documentation:

Known issues:

  • French translation - the manage grids don't work

If you have any issues or queries please post in the forum: http://simpleinvoices.org/forum/discussion/899/simple-invoices-20091-update-1-released/

Cheers

Justin

Simple Invoices 2009.1 released!!

Hi Guys,

I'm very happy to announce the release of Simple Invoices 2009.1!!

Grab the download from:
http://simpleinvoices.googlecode.com/files/simpleinvoices.2009.1.zip

This release has been more than 2 years in the works - thanks to all involved!

New stuff:

  • Dynamically add/edit/remove invoice line items
  • Editable product prices in invoices creation/editing
  • Multiple tax rates per line item
  • Tax rates can be dollar or percentage based
  • 'Manage' grids re-developed
  • UI re-developed
  • Basic installer added
  • Itemised and consulting style invoices merged
  • PDF re-developed
    • should fix alot of peoples PDF problems - note: will have to bump php max mem upto 64M at least - refer install docs
  • User management added
  • Added Zend Framework and PDO
  • Work started on Postgres and SQLite ports
  • Expenses extension added
  • etc..

For a full list refer:
http://code.google.com/p/simpleinvoices/wiki/done?ts=1253850557&updated=done#2009.1_series

Documentation:

Known issues:

  • French translation - the manage grids dont work
  • UI of Manage Extensions needs updating
  • not all extensions work

If you have any issues please post in our forum here:

Note:

Cheers

Justin

Can anyone make this sql query faster

Hi Guys,

we've got an old sql query that powers the 'Manage Customers' page thats slow as a dog to run. if anyone has a few minutes to review and rewrite this query so it run faster it would be greatly appreciated.

theres the sql

SELECT
    c.id AS CID,
    c.name AS name,
    (
		SELECT (CASE  WHEN c.enabled = 0 THEN 'Disabled' ELSE 'Enabled' END )
	) AS enabled,
    (
        SELECT
            coalesce(sum(ii.total),  0) AS total
        FROM
            si_invoice_items ii INNER JOIN
            si_invoices iv ON (iv.id = ii.invoice_id)
        WHERE
        iv.customer_id  = CID 
	) AS customer_total,
    (
        SELECT
            coalesce(sum(ap.ac_amount), 0) AS amount
        FROM
            si_payment ap INNER JOIN
            si_invoices iv ON (iv.id = ap.ac_inv_id)
        WHERE
            iv.customer_id = CID
	) AS paid,
    ( 
		SELECT customer_total - paid 
	) AS owing
FROM
    si_customers c
WHERE 
	c.domain_id = '1'
ORDER BY
    name ASC;

just post your improve query in the Simple Invoices forum:
- http://simpleinvoices.org/forum/discussion/864/can-anyone-make-this-sql-query-faster/

Cheers

Justin

Simple Invoices 2009.1 Release Candidate available

Hi All,

Simple Invoices 2009.1 Release Candidate is now available for download from
: http://simpleinvoices.googlecode.com/files/simpleinvoices.2009.1.RC.zip

Whats new:

Expense extension - this allows you to records your expenses in Simple Invoices, you can assign an expense to a biller, customer, invoice, and or product note: expense extension is mainly for reporting purposes - you can't invoice an expense etc.

Assuming there are no major problems - Simple Invoices 2009.1 will be released in a week or so

Please test upgrading your existing db to 2009.1 and post in the forum is all was OK/not OK
- http://simpleinvoices.org/forum/discussion/861/simple-invoices-20091-release-candidate-available/

Cheers

Justin

Simple Invoices 2009.1 Beta 5 released

Hi Guys

Simple Invoices 2009.1 Beta 5 has been release

You can grab the file from: http://simpleinvoices.googlecode.com/files/simpleinvoices.2009.1.beta5.zip

Whats New:

  • Basic installer added
    • no more importing .sql files via phpMyAdmin!!
    • includes an option to import the sample data if you want - no more manually removing the data you don't want!
  • Payments page updated
  • Merge docs.php into normal index.php
  • User Add - fill in info from session problem fixed
  • Sql patch to move all consluting invoices to itemised style

How to install:

  1. Create a blank database in MySQL
  2. Enter the database connection details in config/config.ini
  3. Open your Simple Invoices url ( ie. http://localhost/simpleinvoices ) and follow the steps

Know issues:

  • Delete invoices - line item taxes arent deleted from db
  • Email - fix errors
  • UI of Manage Extensions needs updating
  • not all the extensions work
  • front page/dashboard not complete
  • Invoice edit needs work

If you find any details please post on the forum: http://simpleinvoices.org/forum/discussion/822/simple-invoices-20091-beta-5-released/

Cheers

Justin

Simple Invoices 2009.1 Beta 4 release

Hi Guys,

Simple Invoices 2009.1 beta 4 has been released!

This is the second last beta release before the stable 2009.1 release

You can grab the download from: http://simpleinvoices.googlecode.com/files/simpleinvoices.2009.1.beta4-3.zip

Whats new

  • Simple Invoices now works with E_STRICT error reporting (ie. the 'Manage' pages now work for E_STRICT people)
  • sql port number added into config.ini
  • UI updates
  • First Run wizard - work started
  • Default landing page is Manage Invoices if there is already an invoice in the db
  • backup db - menu fix
  • customer view info tabs - redone in jquery UI
  • Extensions can now be managed within Simple Invoices and not in the config file - thanks Marcel
  • System defaults table updated to include both domain_id and extension_id fields - so can have different values for a default depending on extension or domain - thanks Marcel

FYI

  • If creating a new database use the files in ./databases/MySQL
    • import 1-Structure.sql and 2-EssentialDate.sql
  • If you want some same data import 3-SampleData.sql
  • edit your config settinsg in ./config.ini

Known issues

  • UI of Manage Extensions needs updating
  • not all the extensions work
  • front page/dashboard not complete
  • Total style invoice not selectable
  • Invoice edit needs work

If you have any problems please post here on the forum: http://simpleinvoices.org/forum/discussion/788/simple-invoices-20091-beta-4-release/

Cheers

Justin

 
 | blog.txt · Last modified: 2013/06/14 04:59 (external edit)