Přejít na obsah
Menu
You need to be registered to interact with the community.
This question has been flagged
2 Odpovědi
2131 Zobrazení

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
Zrušit
Nejlepší odpověď

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
Zrušit
Autor

Whether this will delete the existing pdf already generated?

Autor

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

Autor Nejlepší odpověď

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
Zrušit
Related Posts Odpovědi Zobrazení Aktivita
2
čvc 25
439
1
srp 25
1309
1
čvn 24
2208
0
led 25
906
0
říj 24
1933