I have a UDF on Sale Ored Named as Project No. where i want a series which is generated Automatically each time the sale order is posted like
where 09- Year
00001 is a number
and when the month changes it will change into like 091000001
and when the year changes it will change into like this 100100001
where 10 is for year
where 01 is for month
where 00001 is the number
and the number generated each time by 1 as the month changes or year..
Please tell me the suggestion or query.