Random numbering

Henry

Hello guys (and girls),

I hope one of you can help me out with the following problem:

For our batch numbering i've created a new no. serie where i make use of the default numbering (automatically). This because the batch no. has to be unique.

Example:
A001, A002, A003......

The problem is that i would like to use a random numbering where each number must be unique.

Example:
A001, A871, A342....

Is this possible in Navision? Thank you for thoughts!

Greetzz,
Henry

AK

Without coding this is not possible. But you can extend codeunit 396 to behave like you want. I would store every created number in a separate table and compare my new random number with this table.
But this would put a growing load on the server, depending on how much numbers will be created...

Luc_VanDyck

Maybe you can use Year Month Day Hour Minutes Seconds to form your Batch No.?

Henry

Thanks Luc & AK for your replies.

With the function RANDOM(IZE) i can create raondom numbers but to be unique i have to check all batch no.'s (like AK mentioned). This will lead to bad performance (like AK mentioned). Does anybody knows what other solution to use?

Unfortunately i can't use YEARMONTHDATE because the batch no. has to be printed on the article and we have a limit on the characters we can use.

Thanks,
Henry

AK

Another solution could be to create a formula which calculates a unique number out of some given parameters, for example date, time and costumer no.
Could be as simple as formatting date (e.g. 18/12/02), time (10:32:17) and costumer no (4711) into one number (1812021032174711) and converting it into a hex value (6700605F2C477). This is of course not a random number, but it looks like one. And it's too long for your purpose, but may be it is a starting point.
Actually I have no idea about how to prove if the number is really unique (when using another formula than the one above)... Any mathematic whizkids around?