John
Saw your post. What we have done is to create the invoice in cursors then if the user decides to save the invoice, PO, whatever we then create new records in the master and detail files thus leaving no holes in the sequence.
Jon

>Hi,
>I want to generate auto number for document such as invoice, PO and etc. Any function built in in MM for this purposes? I tried newid() but it will increase the value even the record is not saved. I don't want to have "hole" between theese number. Any ideas?
>
>Thank you