Skip to Content
Menu
This question has been flagged
5 Replies
2192 Rodiniai

Hello,

May i know which table in odoov16 holds the Bill and invoice information? account.invoice is no longer available.

Portretas
Atmesti
Best Answer

Hello Muhammad, 

After the odoo12 version release this is major changes based on data table. 

Before V12 Invoice/Accounting table are known as account.inovice and it's related tables are changed but after replace the table with account.move

Thanks.

Portretas
Atmesti
Autorius Best Answer

Thank you for the quick response and how can we connect sales order with account move and account payment table?

Portretas
Atmesti

In that case you need to create a invoice from sales order.

In sales order you can see create invoice button visible. (Button Highlight based on product invoicing policy)

Best Answer

Hi,

In Odoo 16, the account.invoice model has been replaced by two main models for handling bills and invoices:

  1. account.move: This table holds both invoice and bill information. The field move_type distinguishes between different types of records:
    • out_invoice: Customer Invoice
    • in_invoice: Vendor Bill
    • out_refund: Customer Credit Note
    • in_refund: Vendor Credit Note
  2. account_move_line: This table contains the individual lines for each invoice or bill, linking to account.move via the move_id field.

Thanks.

Portretas
Atmesti
Best Answer

Hello,

The table which are managing the bill and invoice are,

  • account.move
  • account.move.line
  • account.payment (paid)


Portretas
Atmesti
Best Answer

account.move

Portretas
Atmesti
Related Posts Replies Rodiniai Veikla
0
spal. 24
1498
0
rugs. 24
1407
1
bal. 25
1571
0
lapkr. 24
1344
0
lapkr. 24
1992