Skip to Content
Menu
This question has been flagged
2 Replies
1509 Views

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
Discard
Best Answer

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
Discard
Author

Whether this will delete the existing pdf already generated?

Author

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

Author Best Answer

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
Discard
Related Posts Replies Views Activity
0
Dec 24
558
1
Jun 24
1488
0
Jan 25
401
0
Oct 24
951
11
Oct 24
26204