Invoices Table

Question

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

Chad Sullivan · Answer

Thank you!  Both replies are exactly what I needed to find the info I was looking for.

Cybrosys Techno Solutions Pvt.Ltd · Answer

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.

Rangadurai · Answer

*account_move*  check this table

This question has been flagged

Enjoying the discussion? Don't just read, join in!