Monday, April 27, 2009

Update 1.0.4.21

I added for a client, that had to revert back to older backup data at hq, 2 Utilities on the Multi branch Feature.

On the POS invoice screen I added a option for marking the current POS Invoice as not send to hq. That with the next Run to send invoices to hq that the current invoice also will be send.

And on the Stock transfer screen I added a option for marking current stock transfer as already send to branch.

Thanks

Tuesday, April 14, 2009

Reason for Mysql 5.0 and above requirement

I am explaining in this post, the Mysql 5.0 or above requirement for NCompPOS. There is lots of questions about this subject because lots of people already have an older version of Mysql installed.

From Mysql 5.0 there were a function build in called 'Transaction save'. I am using this function in a lot of places for the following reason.

If there is a run that do lots of changes in your database, the transaction save function will test if the run was completed and only if the run was completed successfully will it post the changes to the database. So if anything happens during the run Mysql will divert back to how the data looked before the run was initiated. Example of such a situation is if you send your invoices over the internet to HQ and your connection is lost, you don't sit with half run data. In the half run data situation we would have had to restore a backup to fix the data.

If you still need to use an older Mysql I expect it to work I haven't build in any other mysql special features into the software. The older Mysql (Its tested with version 4.0 and above) don't give a error on the 'Transaction save' command it just ignore it so if the run is stopped half way, your data will be corrupt and you will have to restore a backup.

Thanks enjoy your day.

Update 1.0.4.20

I have uploaded a new stable version of NCompPOS 1.0.4.20 its just a bug fix release.

I have decided to change my strategy with my NCompPOS Software, it will be changed as soon as I have time, there will be 3 versions of my software in the future. Free Basic version 'This will only include the basic features like a till', Paid Pro version 'This will include all the features except the Branch Sync Features' and multiple branch version 'This will include all the Features'.

Have a nice day.