Invoice Already Exists

[Santhosh_Aerotek]

When I tried to raise new sales invoice its saying it already exists
Why i am getting this error

Thanks
Santhosh

[bahaou]

@Santhosh_Aerotek check doctype list → sales invoice → auto naming . what have you written ?

[Santhosh_Aerotek]

This is how it looks…

[bahaou]

@Santhosh_Aerotek can you confirm that the sales invoice 00001 actually exists ?

[Santhosh_Aerotek]

Yes, It already exists

[bahaou]

@Santhosh_Aerotek did you change anything in the doctype list ? probably added “unique” to one of the fields.

[Santhosh_Aerotek]

No, I haven’t changed anything

[bahaou]

@Santhosh_Aerotek I suggest to rebuild the table . open apps/erpnext/erpnext/accounts/doctype/sales_invoice . open sales_invoice.json. search for modified and change it to recent date like yesterday . than run bench migrate . hope rebuilding the table will fix it

[Santhosh_Aerotek]

Thanks, I solved this issue by rebuilding the table

Thanks you very much.

[bahaou]

@Santhosh_Aerotek mark the answer as solution please so everyone can have the soltion