Skip to Content
0
Former Member
May 30, 2010 at 03:34 PM

Query

8 Views

Hi, Experts,

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

090900001

where 09- Year

09- Month

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.

Regards

Honey