0

i have programe where i use serial number for each document number. now i want to start serial number with one againe in new financial year, but restarting number with one result in duplication of reference number in database. how to get this.

2
Contributors
2
Replies
4
Views
5 Years
Discussion Span
Last Post by PM312
0

You can create a year table where you can store the year as 2010,2011,2012 and so on and use the id of the year in your transaction table. When year will change u can easily start the serail number again with 1 and it will also not create any duplicacy as serial number will be associated with the year ID.

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.