#150 Transactions on record invoice

[Torben S. Soerensen]

I have seen a few times that the recording of an invoice causes an inconsistancy in the database if for example the FriFinans client goes down because of the memory failure in PHP. The inconsistency can be that in invoicenumber is assigned, but the invoice is not recorded. When you later record the invoice again then a new number is used and you get an unused number which is not legal.
We need to introduce or improve the use of transactions in the record process so that the recording is done in its entirety or not at all.

/Torben

[Torben S. Soerensen]

Hi,
When FF records an invoice it starts by saving the invoice and invoice lines. The saving of the invoice lines are done by deleting the old lines and save the new.
If FF fails during the save then you can end up with no lines. This must be prevented f.x. by using transactions.

/Torben

[Torben S. Soerensen]

Before doing any actual work I would like to have an opinion on how much work is required to do this now. E.g. if we are not using transactions now, then it might be to big a task and other areas are perhaps then more important.