No Serial Number Gaps

[Dr. Evil]

Does anyone know how use a calculation for the serial id; where if a record is deleted the next serial number would be the record last deleted or if a record has not been last deleted, calculation would just use next value?

My solution creates invoices. Sometimes a user could make a mistake or simply the invoice needs to be fixed/deleted.

In accounting, it is not good practice to have missing invoice numbers/ids, looks bad if audited.

For example...

1, 2, 3, 4, 5, 6 = good

1, 2, 4, 5, 7, 8 = bad

Should I worry, or just let live?

Thanks for all your help!

[Raybaudi]

Hi

try this one.

RecoverTheProgression.zip

[comment]

In accounting, it is not good practice to allow users to delete invoices once they have been posted.

[Dr. Evil]

Wow! This works beautifully!

NextID ( ValueListItems ( Get ( FileName ) ; "IDs" ) ; 1 )

Altho I do not understand how it is works and cannot get it to work in my own solution.

How is the calculation referencing NextID and using "IDS", etc...?

I looked through your sample file and did not see ANY other fields other then Serial, not other calculations, etc... magic? lol

Please help me understand how you accomplished this. THANKS A HEAP!

[Dr. Evil]

In accounting, it is not good practice to allow users to delete invoices once they have been posted.

Maybe I should just mark Invoice as NULL vs. deleting and correcting. My thought behind deleting and re-generating is a user could make a simple mistake in creating an invoice, for example a spelling error. In the spelling error case, I do not think it would justify recording the spelling error invoice, a simple "undo" and redo would suffice.

In the case of an incorrect posted charge on the invoice; the invoice would be allowed to live and a new invoice would be generated to compensate for the incorrect invoice.

Could this model create issues? What I just explained is one invoice may be an over charge, so I would create a new invoice that credited account or visa versa.:

I am still VERY interested in the "Recover Progression SS" technique.

[comment]

I suggest you consult an accountant or a lawyer for the best practice in your jurisdiction. In general, I believe the correct way is to post a new invoice to "offset" the mistake.

@Daniele:

Watch this short video:

http://www.screencast.com/users/comment/folders/Default/media/7d478ffd-031f-487b-9875-af7c39003a4f

[Raybaudi]

That's too bad !

Thank you, Michael.

[Raybaudi]

NextID ( ValueListItems ( Get ( FileName ) ; "IDs" ) ; 1 )

Altho I do not understand how it is works and cannot get it to work in my own solution.

You'll need the Advanced version to place any Custom Function inside your file.

Also that was an old idea of mines :

Comment has said many times that wasn't good...

and he is always right.