2
edits
FAQ Delete invoice in the database EN: Difference between revisions
Jump to navigation
Jump to search
FAQ Delete invoice in the database EN (view source)
Revision as of 15:43, 2 September 2010
, 16 years agoDelete customer invoice
mNo edit summary |
(Delete customer invoice) |
||
| Line 4: | Line 4: | ||
You must first remove all records into [[Table llx_facturedet]] (there is one record by invoice line), | You must first remove all records into [[Table llx_facturedet]] (there is one record by invoice line), | ||
and then you can delete invoice in [[Table llx_facture]]. | and then you can delete invoice in [[Table llx_facture]]. | ||
The steps for a MySQL database are: | |||
- get the ID of your invoice (invoice is called "facture" in French). You can get this ID by going to the Invoice's card, and check the address in your browser. For example | |||
dolibarr.xxxxx.com/compta/facture.php?facid=29 the invoice ID is "29" | |||
- connect to your database (via phpmyadmin or command line, for example) | |||
- Type the following commands ('''replace INVOICE_ID by the ID you got earlier'''): | |||
- DELETE FROM llx_facturedet WHERE fk_facture = ''INVOICE_ID''; | |||
- DELETE FROM llx_facture WHERE rowid = ''INVOICE_ID''; | |||
Your invoice should be deleted successfully. | |||