Deletion of invoice FAQ - Revision history

N.paul at 11:47, 6 July 2022

2022-07-06T11:47:07Z

← Older revision		Revision as of 13:47, 6 July 2022
Line 1:		Line 1:
	'''How can the users delete a customer and vendor invoice from the databases without having to go through a complicated process? '''		'''<h3 style="color:#006799;">How can the users delete a customer and vendor invoice from the databases without having to go through a complicated process?</h3>'''

	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:		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.		* 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.

Admin at 08:52, 11 January 2022

2022-01-11T08:52:21Z

← Older revision		Revision as of 10:52, 11 January 2022
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.

Admin: 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..."

2022-01-07T11:58:08Z

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..."

New page

'''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.