FAQ Delete invoice in the database EN - Revision history

Egils: Egils moved page FAQ Facture EN to FAQ Delete invoice in the database EN: translated

2020-03-20T16:55:16Z

Egils moved page FAQ Facture EN to FAQ Delete invoice in the database EN: translated

← Older revision

Revision as of 16:55, 20 March 2020

PolyglotBot: Import interlang links (links to translated versions of this page in other languages) from Multi Language Manager table.

2019-07-23T13:20:24Z

Import interlang links (links to translated versions of this page in other languages) from Multi Language Manager table.

← Older revision		Revision as of 13:20, 23 July 2019
Line 1:		Line 1:
			<!-- BEGIN origin interlang links -->
			<!-- You can edit this section but do NOT remove these comments
			Links below will be automatically replicated on translated pages by PolyglotBot -->
			[[fr:FAQ_Facture]]
			[[es:FAQ_Facture_ES]]
			<!-- END interlang links -->

	[[Category:FAQ EN]]		[[Category:FAQ EN]]
	'''How to remove "easily" an invoice customer "by hand" in the database ?'''		'''How to remove "easily" an invoice customer "by hand" in the database ?'''

Alban: Delete customer invoice

2010-09-02T15:43:20Z

Delete customer invoice

← Older revision		Revision as of 15:43, 2 September 2010
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.

Eldy at 11:26, 15 October 2009

2009-10-15T11:26:39Z

← Older revision		Revision as of 11:26, 15 October 2009
Line 1:		Line 1:
	[[Category:FAQ EN]]		[[Category:FAQ EN]]
	~~{{ToTranslate}}~~
	'''How to remove "easily" an invoice customer "by hand" in the database ?'''		'''How to remove "easily" an invoice customer "by hand" in the database ?'''

	~~Il faut supprimer en premier lieu les enregistrements qui ce trouvent dans~~ llx_facturedet ,		You must first remove all records into [[Table llx_facturedet]] (there is one record by invoice line),
	~~il existe un enregistrement par ligne sur la facture,~~		and then you can delete invoice in [[Table llx_facture]].
	~~et seulement ensuite vous pouvez supprimer la facture dans~~ llx_facture.

Eldy at 11:51, 23 April 2009

2009-04-23T11:51:31Z

← Older revision		Revision as of 11:51, 23 April 2009
Line 1:		Line 1:
	[[Category:FAQ EN]]		[[Category:FAQ EN]]
	{{ToTranslate}}		{{ToTranslate}}
			'''How to remove "easily" an invoice customer "by hand" in the database ?'''

	Il faut supprimer en premier lieu les enregistrements qui ce trouvent dans llx_facturedet ,		Il faut supprimer en premier lieu les enregistrements qui ce trouvent dans llx_facturedet ,
	il existe un enregistrement par ligne sur la facture,		il existe un enregistrement par ligne sur la facture,
	et seulement ensuite vous pouvez supprimer la facture dans llx_facture.		et seulement ensuite vous pouvez supprimer la facture dans llx_facture.

Simnandez: Created page with 'Category:FAQ EN {{ToTranslate}} Il faut supprimer en premier lieu les enregistrements qui ce trouvent dans llx_facturedet , il existe un enregistrement par ligne sur la fact...'

2009-04-23T10:06:25Z

Created page with 'Category:FAQ EN {{ToTranslate}} Il faut supprimer en premier lieu les enregistrements qui ce trouvent dans llx_facturedet , il existe un enregistrement par ligne sur la fact...'

New page

[[Category:FAQ EN]]
{{ToTranslate}}
Il faut supprimer en premier lieu les enregistrements qui ce trouvent dans llx_facturedet ,
il existe un enregistrement par ligne sur la facture,
et seulement ensuite vous pouvez supprimer la facture dans llx_facture.