Help me, how i delete an customer invoice?
There’s a FAQ about it but it’s in French. So here’s the way in English :
- 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
http://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.
Alban
When you have activate the bank module then you have to do some more.
step 1 : Delete in llx_paiement_facture --> fk_facture = Invoice_ID
step 2 : Delete in llx_paiement --> rowid = llx_paiement_facture --> rowid
step 3 : Delete in llx_facturedet --> fk_facture = Invoice_ID
step 4 : Delete in llx_facture --> rowid = Invoice_ID
The previous post used a very technical way to solve a very simple problem… Invoices only stop you from deletion if a transaction has been applied…
Click “Bank/Cash”
Click the name of the account the transaction was made (I.E. Bank A)
Click on the “Transactions” tab
Click on the trash can next to the transaction you need to delete
A new menu will appear*****
Select yes from the dropdown then click validate
Click on “Third Parties”
Click the name of the Third party who’s invoice you want to delete
Click on the “Customer” Tab up top
Click on the invoice number you want to delete
Click Reopen
Click on the date in the payments section
Verify the payments in this section are for this invoice only
Click delete then yes in the pop up
Click “third parties” > then the customer name > then customer tab again…
Click on the invoice in question
Click Delete!
Regards,
Kevin
Also,
you cannot delete an invoice if you changed the invoice mask afterwards (setup, modules, invoices, setup). You have to return the mask to the mask which generated the invoice number. That will unlock the erase number.
Bye
Jeeeees,
I had to remind myself of this.
Good I have left the last post cause I would never remember this.
Regards!
