Skip to Content
Meniu
Trebuie să fiți înregistrat pentru a interacționa cu comunitatea.
Această întrebare a fost marcată
3 Răspunsuri
450 Vizualizări

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

Imagine profil
Abandonează
Autor Cel mai bun răspuns

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

Imagine profil
Abandonează
Cel mai bun răspuns

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.

Imagine profil
Abandonează
Cel mai bun răspuns

account_move  check this table

Imagine profil
Abandonează