Hi,
I'm wondering where/how do folks increment Invoice Numbers. My queries are as follows:

1. I generally use Table Buffered views
2. If I increment the Incoice immediately, and then the transaction is cancelled for some reason, I have MISSING invoice numbers

3. If I increment AFTER a Tableupdate, its two processes I cant easily rollback
4. I cant lock the next available file as there are other users who will want to increment all the time.

I'd be very interested in how this is normally done
Regards,

Gerard