Where can i find the Invoice XML file?
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Accounting
- Inventory
- PoS
- Project management
- MRP
This question has been flagged
Hello Santosh,
Additional information here that could be useful for users looking to extract the XML files generated in Odoo.
The first step is to activate electronic invoicing, by going in the Advanced Settings of the appropriate Sales journal. The different possibilities of e-Invoicing will be displayed according to the fiscal country and package set for the company.
This feature enables to generate automatically the XML file when posting a new invoice in this journal.
All XML files that have been generated previously can be visualized and extracted if necessary. To do so, debug mode must be activated. Go to Settings > Technical > Database Structure > Attachments. Here can be found all attachments across the database, including the XML files linked to invoices.
To display and extract the XML file of invoices, switch to list view and filter on the Resource Model: account.move.
You can either extract each XML file by clicking on the invoice and downloading it, field "File Content (base64). Or you can select all invoices and export them in Excel, containing the XML links in one column as in the below screenprint :
attachment = self.env['ir.attachment'].search([('res_name', '=', invoice.name)])
in attachment, you will get the record of the attachment of your invoice and can access other fields with it like attachment.datas will be base64 of XML of your invoice
Hi Santosh,
You can find the Invoice XML in Settings > Technical > Reports > Reports, and search Invoice using the search-box.
Regards,
Juan José - ADHOC
Which one? Printed or view?
Santosh R P ΙExec-Tech Team
Bodhih Training Solutions Pvt Ltd Ι Phones: +91 80 4260 6666 - Ext. 602
Email: santoshrp@bodhih.com Ι Web: www.bodhih.com
<img border="0" width="593" height="6" src="cid:image001.jpg@01D05FEA.9A473BD0" alt="Description: Description: cid:image002.jpg@01CEA8C2.DC5DA710">
<img border="0" width="40" height="47" src="cid:image002.png@01D05FEA.9A473BD0" alt="Description: Description: cid:image003.png@01D05D8A.31A632F0"><img border="0" width="39" height="45" src="cid:image003.png@01D05FEA.9A473BD0" alt="Description: Description: cid:image002.png@01D05D8A.AAE50470"><img border="0" width="40" height="46" src="cid:image004.jpg@01D05FEA.9A473BD0" alt="Description: Description: cid:image006.jpg@01D05D8A.AAE50470">