Deletion of invoice FAQ

How can the users delete a customer and vendor invoice from the databases without having to go through a complicated process?

For deleting all the invoice related data and records from Table llx_facturedet. After that the users need to delete invoice in Table llx_facture. However, these steps are different for a MySQL database. For deleting an invoice in MySQL database the steps are presented below:

• The ID of the invoice need to be generated. The invoice ID can be found in the invoice card. The ID can also be checked in the address provided by the used browser.
• Then the users need to the connect the ID with the user database
• The following commands need to be typed for deleting the invoice:

DELETE FROM llx_facturedet WHERE fk_facture = INVOICE_ID; DELETE FROM llx_facture WHERE rowid = INVOICE_ID; After completing this procedure Tactic will be able to delete the invoice successfully.