Simple Invoices Blog

Hi Guys,

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

You can grab the download from:

• http://simpleinvoices.googlecode.com/files/simpleinvoices.2010.2.beta5.zip

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:

• Installing Simple Invoices: http://www.simpleinvoices.org/install
• Upgrading Simple Invoices: http://www.simpleinvoices.org/wiki/upgrade
• Simple Invoices help: http://www.simpleinvoices.org/help
• Frequently Asked Questions: http://www.simpleinvoices.org/wiki/faqs
• Simple Invoices config file options: http://www.simpleinvoices.org/config

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:

• http://simpleinvoices.org/forum/discussion/1215/simple-invoices-20102-beta-5-released/

Cheers

Justin

Hi Guys,

Simple Invoices 2010.2 Beta 4 has been released.

You can grab the download from:

• http://simpleinvoices.googlecode.com/files/simpleinvoices.2010.2.beta4.zip

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:

• Installing Simple Invoices: http://www.simpleinvoices.org/install
• Upgrading Simple Invoices: http://www.simpleinvoices.org/wiki/upgrade
• Simple Invoices help: http://www.simpleinvoices.org/help
• Frequently Asked Questions: http://www.simpleinvoices.org/wiki/faqs
• Simple Invoices config file options: http://www.simpleinvoices.org/config

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:

• http://simpleinvoices.org/forum/discussion/1199/simple-invoices-20102-beta-4-released/

Cheers

Justin

Hi Guys,

Simple Invoices 2010.2 Beta 3 has been released.

You can grab the download from:

• http://simpleinvoices.googlecode.com/files/simpleinvoices.2010.2.beta3.zip

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

• Added Inventory - refer http://simpleinvoices.org/wiki/inventory
• fixed add user no role problem
• fixed decimal place - missing zeros problem
• fixed cron ACL issue
• fixed expense extension/2010.2 issues

Documentation:

• Installing Simple Invoices: http://www.simpleinvoices.org/install
• Upgrading Simple Invoices: http://www.simpleinvoices.org/wiki/upgrade
• Simple Invoices help: http://www.simpleinvoices.org/help
• Frequently Asked Questions: http://www.simpleinvoices.org/wiki/faqs
• Simple Invoices config file options: http://www.simpleinvoices.org/config

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:

• http://simpleinvoices.org/forum/discussion/1182/simple-invoices-20102-beta-3-released/

Cheers

Justin

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:

• http://www.linuxuser.co.uk/reviews/simple-invoices-review/
• http://www.smarterinvoices.com

now off to find a copy of issue 85 somewhere

let me know if you have any queries

• http://simpleinvoices.org/forum/discussion/1177/simple-invoices-featured-in-linux-user-magazine/

Cheers

Justin

Hi Guys,

Simple Invoices 2010.2 Beta 2 has been released.

You can grab the download from:

• http://simpleinvoices.googlecode.com/files/simpleinvoices.2010.2.beta2.zip

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

• Fixed tax total and grouping on invoice print issue
• Fixed issue with various 'manage' pages grid not working
• Fixed issue where blank screen presented if tmp dir not write-able
• refer http://code.google.com/p/simpleinvoices/wiki/done#2010.2_Beta_2 for full list

Documentation:

• Installing Simple Invoices: http://www.simpleinvoices.org/install
• Upgrading Simple Invoices: http://www.simpleinvoices.org/wiki/upgrade
• Simple Invoices help: http://www.simpleinvoices.org/help
• Frequently Asked Questions: http://www.simpleinvoices.org/wiki/faqs
• Simple Invoices config file options: http://www.simpleinvoices.org/config

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:

• http://simpleinvoices.org/forum/discussion/1160/simple-invoices-20102-beta-2-released/

Cheers

Justin

Hi Guys

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

You can grab the download from:

• http://simpleinvoices.googlecode.com/files/simpleinvoices.2010.2.beta1.zip

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

Whats new:

• Added recurring invoices - refer http://simpleinvoices.org/wiki/recurrence
• Added support for Paypal - http://simpleinvoices.org/wiki/paypal
• Added support for Eway payment gateway - http://simpleinvoices.org/wiki/eway
• Added invoice statements
• Predefined filters added to the Manage Invoices pages -http://simpleinvoices.org/wiki/filters
• Invoices can now have statuses - http://simpleinvoices.org/wiki/status
• Invoice numbering groups added - ie. multiple invoice numbergin ranges
  • refer http://simpleinvoices.org/wiki/invoice_numbering_groups
• Swap Gross for SubTotal? - refer: http://simpleinvoices.org/forum/discussion/826/nett--tax-gross/#Item_1
• edit db class - only use mysql attr if available - Fixed
• Upgrade to Zend 1.10
• refer http://code.google.com/p/simpleinvoices/wiki/done#2010.2 for full list

Documentation:

• Installing Simple Invoices: http://www.simpleinvoices.org/install
• Upgrading Simple Invoices: http://www.simpleinvoices.org/wiki/upgrade
• Simple Invoices help: http://www.simpleinvoices.org/help
• Frequently Asked Questions: http://www.simpleinvoices.org/wiki/faqs
• Simple Invoices config file options: http://www.simpleinvoices.org/config

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:

• http://simpleinvoices.org/forum/discussion/1155/simple-invoices-20102-beta-1-released/

Cheers

Justin

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

• post in the forum http://simpleinvoices.org/forum/discussion/1129/ux-guru-redesigns-simpleinvoicesorg-site/ if your interested or have questions/ thoughts on the design

refer:

• Original post - http://news.ycombinator.com/item?id=1194567
• Results post - http://news.ycombinator.com/item?id=1199990
• PSD files - http://groups.google.com/group/simpleinvoices/web/SI_creative02.psd.zip

Cheers

Justin

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:

• Installing Simple Invoices: http://www.simpleinvoices.org/install
• Upgrading Simple Invoices: http://www.simpleinvoices.org/wiki/upgrade
• Simple Invoices help: http://www.simpleinvoices.org/help
• Frequently Asked Questions: http://www.simpleinvoices.org/wiki/faqs
• Simple Invoices config file options: http://www.simpleinvoices.org/config

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

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:

• Installing Simple Invoices: http://www.simpleinvoices.org/install
• Upgrading Simple Invoices: http://www.simpleinvoices.org/wiki/upgrade
• Simple Invoices help: http://www.simpleinvoices.org/help
• Frequently Asked Questions: http://www.simpleinvoices.org/wiki/faqs
• Simple Invoices config file options: http://www.simpleinvoices.org/config

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

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:

• Installing Simple Invoices: http://www.simpleinvoices.org/install
• Upgrading Simple Invoices: http://www.simpleinvoices.org/wiki/upgrade
• Simple Invoices help: http://www.simpleinvoices.org/help
• Frequently Asked Questions: http://www.simpleinvoices.org/wiki/faqs
• Simple Invoices config file options: http://www.simpleinvoices.org/config

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:

• http://simpleinvoices.org/forum/discussion/877/simple-invoices-20091-released/

Note:

• backup your database before upgrading!
• to see 2009.1 in action refer our demo site: http://simpleinvoices.org/demo

Cheers

Justin

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

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:

• Delete invoices - add delete line item taxes
• Fix email problem in beta 5
• Config.ini change - display errors now on by default
• Expense extension added - refer: http://simpleinvoices.org/wiki/expense_extension

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

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
• Input validation using http://www.position-relative.net/creation/formValidator/
• 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

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

• 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

• 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
  • refer http://simpleinvoices.org/config for some details re config file (not this is still a work-in-progress)

• 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

Hi Guys,

I'm very happy to announce the availability of Simple Invoices 2009.1 beta 3

http://simpleinvoices.googlecode.com/files/simpleinvoices.2009.1.beta3.zip

1. users management - you can now add/edit users in Simple Invoices - no more phpmyadmin nonsense
2. multiple taxes per line item - just adjust the number of taxes per line item in System Preferences to show the number you require
3. UI updates - Simple Invoices is now using 970px wide layout instead of 100% width
4. email as pdf working now
5. email - now allow multiple email addresses in to or bcc and can be delimited via , or ; - thanks stella
6. add system pref for number of taxes per line item
7. sql patch 163 - tax conversion patch updated

1. customer view info tabs - not happy - need to be redone in jquery UI
2. can't close yellow text
3. backup db - once db backed up - menu goes wierd
4. IE - menu not all nice
5. no data validation on form input
6. postgres version not complete
7. total style invoice not selectable
8. Help link - top right - not working
9. Reports - not localised - ie. in 6 decimal places
10. PHP.ini max memory needs to be min 64M to handle new PDF

1. If using a new database for beta2 please restore using ./database/MySQL/Strucutre.sql and then Essentials.sql) - if you want the sample data also restore SampleData.sql
2. chmod -Rv 777 ./tmp; as cache, log, and dbbackups directories have been moved into this folder

1. try upgrading a database from an older version (pre 2009.1 beta2) and make sure all the invoices are still OK
2. create invoices using a few different scenarios and then edit them - etc.. - make sure the invoice is 100% ok in all the differents
3. are you a css guru? i need someone to help fix the css round the menus - issue in IE and also with side borders
4. post on the forum - http://simpleinvoices.org if you find any issues

Cheers

Justin