Skip to Content
Menu
This question has been flagged
2 Replies
2206 Rodiniai

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?

Portretas
Atmesti
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

Portretas
Atmesti
Autorius

Whether this will delete the existing pdf already generated?

Autorius

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

Autorius 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


Portretas
Atmesti
Related Posts Replies Rodiniai Veikla
2
liep. 25
577
1
rugp. 25
1378
1
birž. 24
2269
0
saus. 25
971
0
spal. 24
2014