Invoice Already Exists

Santhosh_Aerotek · February 4, 2022, 7:23am

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

Thanks
Santhosh

bahaou · February 4, 2022, 7:59am

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

Santhosh_Aerotek · February 4, 2022, 8:13am

This is how it looks…

bahaou · February 4, 2022, 8:45am

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

Santhosh_Aerotek · February 4, 2022, 8:46am

Yes, It already exists

bahaou · February 4, 2022, 8:48am

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

Santhosh_Aerotek · February 4, 2022, 8:50am

No, I haven’t changed anything

bahaou · February 4, 2022, 8:55am

@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 · February 4, 2022, 9:48am

Thanks, I solved this issue by rebuilding the table

Thanks you very much.

bahaou · February 4, 2022, 9:51am

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

bluesky · May 11, 2023, 9:16am

@bahaou Thanks for your suggestion. I am running into the same problem (different doctype though). How do I rebuild the table? Can you give some more details or link to a documented solution?
(Working on Frappe Cloud)
Thanks.

bahaou · May 11, 2023, 11:22am

@bluesky share more details , maybe screenshots

bluesky · May 11, 2023, 9:51pm

Thanks. I could resolve the problem. As discussed in other posts on the forum, this issue arose because we included the ID when importing the entries. ERPnext got confused with the autonaming (seems to be a bug). Deleting all imported entries (after exporting) and then re-uploading them again without the ID solved the issue.