> Max(nr) or next_ nr_procedure will provide different results if more then

one user > is creating invoices and something goes wrong between calling

> trigger/statement for calculating invoice nr and closing transaction.

This solution will work when we don't really need the number 'On new record'
Putting routine for setting the number in BeforeInsert trigger.

Marcin