Whether alpha-numeric doc. sequence is possible ??
Posted: Mon Jul 23, 2007 6:20 am
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
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