Reset sales invoice serial number monthly

1

Hi
I have to reset the serial number of my invoice to 1 every month
my serial number follows this format
mm-yy-####
any guidance on how to achieve this
Regards
Hemanth

2

if you want to reset the autogenrated serial number… truncate the database table

3

Hi Johnrech_Cabatana
Thanks for the reply
But truncate database table means, i stand to lose all previous data stored for the previous month
regards
hemanth

4

there is no other option, because the system assumes that you have the data already to the system…

5

if you used the : mm.-.yy.-####

that will reset your serial number to 1 when mm and yy change.

Cheers

Sione

2 Likes
6

Thanks Sione
Thanks for the reply
I am going to try this
Thanks again
Regards
Hemanth

7

Hi Johnrech_Cabatana
Thanks for the reply
I think Sione has a solution and iam going to try it
Thanks again
Regards
Hemanth