Перейти к содержимому
Меню
Чтобы взаимодействовать с сообществом, необходимо зарегистрироваться.
Этот вопрос был отмечен
3 Ответы
468 Представления

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

Аватар
Отменить