I can't delete an invoice in draft status

Using my Dolibarr Financial modules
1

Please help me, I can’t delete an “supplier invoice” in draft status or or can you please show the name of the table it occupies in the mysql database

2

Hi @Sylnatek,

can you add more information to your help request? Currently it is not clear how someone can help you. Can you please add at least the following information:

  1. Dolibarr Version
  2. Are there errors in Dolibarr Log or Apache Error Log? If yes, please post it as well.
  3. If you click an delete and then accept. What exactly happens then? Are any messages shown?

Regards,
Sven

3

My dolibarr ver: 17.02

I want to know where the “supplier invoice” database is in what table, when viewing it using phpadmin

4

Hi,

the table name is llx_facture_fourn.

Regards,
Sven

5

Ok thanks

Regards,
Erwin

6

SURE you want to go in there with phpMyadmin but don’t it’s a big mistake : Be careful when deleting invoice files or draft invoice files rows in phpMyadmin. Dolibarr wont let you delete them with their interface for a reason. If you delete them in phpMyadmin that record deletion could corrupt the invoice data index. It depends on it that index to function correctly so that primary index record is not altered. So the best way to delete is to validate the invoice and then go in and mark it as abandoned, that way the index is preserved. if you get in there and screw with the index it could cause it to not accept creating invoices in the future due to index files not matching data on other invoices. I’ve been there and done that, just be careful when in the database

7

Oh…ok, i will remember that