I have one number series in which start no. is 20100101-001 to 20011231-999 (its formate like YYYYMMDD-DocNo)
Now for assigning no i have to do like TODAYDATE-DocNo … so i have to assign this number based on today date and latest document no. + 1… how can i achieve this?
is that a typo? your number series is getting smaller: 20100101-001 to 20011231-999
It might be “Like” YYYYMMDD - but it’s not going to behave like that, are you expecting it to?
What’s the purpose of this, other than to make the system look pretty. You’ve got doc date & posting date fields if you want to keep track of dates.
What happens if there is 1000 orders or whatever in a day and your 999 runs out? What’s the plan then?
What you a trying to generate daily no series, for this you need to create no series lines like following for the whole year.
|
Line No. Starting Date Starting No. Ending No. Increment-by No. Open 10000 01/04/10 20100401/0001 20100401/0999 1 Yes 20000 02/04/10 20100402/0001 20100402/0999 1 Yes 30000 03/04/10 20100403/0001 20100403/0999 1 Yes |
|---|
And as you change the work date the no series will also change, if you want to generate vouchers more than 999 don’t put the Ending no in that situation.
Hi Debapriya…
Its not a solution . Because client already provide range from 20100101-001 to 20101231-999 . I cant do in that way. I have to handle that all thing using Code. Can you explain me how can i do it?