Skip to Content
Menu
This question has been flagged
5 Replies
1012 Views

Hello,

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

Avatar
Discard
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.

Avatar
Discard
Author Best Answer

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

Avatar
Discard

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.

Avatar
Discard
Best Answer

Hello,

The table which are managing the bill and invoice are,

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


Avatar
Discard
Best Answer

account.move

Avatar
Discard
Related Posts Replies Views Activity
0
May 25
15
0
Oct 24
645
0
Sep 24
601
1
Apr 25
571
0
Nov 24
498