Overslaan naar inhoud
Menu
Je moet geregistreerd zijn om te kunnen communiceren met de community.
Deze vraag is gerapporteerd
2 Antwoorden
2132 Weergaven

I am using Odoo 15 CE. The pdf invoices after generation gets stored in the filestore and makes the odoo backup file too big. I see that the pdf invoice can be generated again if required hence see not  much utility in keeping the copy in the filestore.


Is there anyway to avoid storage of the pdf invoice in odoo?


How to delete the exiting pdf invoices which are in the file store?

Avatar
Annuleer
Beste antwoord

Hi,
If you don't want to store the printed reports, try unticking "Reload from Attachment?" and "Save as Attachment Prefix" empty in the reports menu.

* Enable debug mode
* Navigate to Reports menu under settings -> technical

* search and open report and apply the change for above mentioned fields

Thanks

Avatar
Annuleer
Auteur

Whether this will delete the existing pdf already generated?

Auteur

i have written a cronjob to delete the invoice pdfs in the filestore.

1.use query SELECT store_fname FROM ir_attachment WHERE res_model= 'account.move' to get the location of the invoice pdf
2.delete the file from the file store.
3. use DELETE FROM ir_attachment WHERE res_model= 'account.move' to delete the record in ir_attachment table

Auteur Beste antwoord

i have written a cronjob to delete the invoice pdfs in the filestore.

1.use query SELECT store_fname FROM ir_attachment WHERE res_model= 'account.move' to get the location of the invoice pdf

2.delete the file from the file store.

3. use DELETE FROM ir_attachment WHERE res_model= 'account.move' to delete the record in ir_attachment table


Avatar
Annuleer
Gerelateerde posts Antwoorden Weergaven Activiteit
2
jul. 25
439
1
aug. 25
1309
1
jun. 24
2208
0
jan. 25
906
0
okt. 24
1933