Difference between revisions of "Deletion of invoice FAQ"
From Tactic Wiki
(Created page with "'''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 dat...") |
|||
| Line 5: | Line 5: | ||
* Then the users need to the connect the ID with the user database | * Then the users need to the connect the ID with the user database | ||
* The following commands need to be typed for deleting the invoice: | * The following commands need to be typed for deleting the invoice: | ||
DELETE FROM llx_facturedet WHERE fk_facture = INVOICE_ID; | DELETE FROM llx_facturedet WHERE fk_facture = INVOICE_ID; | ||
DELETE FROM llx_facture WHERE rowid = INVOICE_ID; | DELETE FROM llx_facture WHERE rowid = INVOICE_ID; | ||
After completing this procedure Tactic will be able to delete the invoice successfully. | After completing this procedure Tactic will be able to delete the invoice successfully. | ||
Revision as of 09:52, 11 January 2022
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.
