Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
Does anyone know where the invoice data is stored in the tables?
I see the account.invoice.report table, but I don’t see the actual invoice ID (also known as the invoice number) anywhere in it. If anyone can point me to the correct table where that might be located, I’d really appreciate it.
Thank you.
Chad
Thank you! Both replies are exactly what I needed to find the info I was looking for.
Hi,
In Odoo, the data of invoices is stored in the 'account.move' model, and it is saved in the 'account_move' table. This table holds the main invoice information, such as the invoice number, date, customer, and total amount.
The detailed line items of each invoice—such as products, quantities, prices, and associated accounts—are stored in the account_move_line table.
Hope it helps.
account_move check this table
Create an account today to enjoy exclusive features and engage with our awesome community!
Sign up
1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.
