Whether alpha-numeric doc. sequence is possible ??

[Dhananjay]

I need some help on the following issue

If I wants to have automatic document sequencing in GL/AP/AR/and FA modules. But the document number should represent year and month and then number e.g. documents generated in Jan-07 should carry numbers either like Jan-07/001, Jan-07/002 or if alpha numeric is not possible then like 0107/001, 0107/002 like this for every month.

Numbers should be re-set every month means in February document numbers should start either like Feb-07/001,Feb-07/002 or 0207/001,0207/002 so on and so forth....

I am doubtful whether Oracle supports alpha-numeric automatic numbering method
secondly, what will be disadvantages in future when volumes will be there....particularly to find/search a document by number....whether audit trail will be maintained...

Request to subscribe your views in details.

Thanks & Regards
Dhananjay

[Velumuthu]

Hi,

Alpha Numeric document Sequencing is not possible.

Regards,
Velumuthu.S