I'm troubleshooting an issue in Odoo's Accounting module and need to track the exact SQL queries executed when creating, modifying, or posting invoices, journal entries, and payments. How can I enable logging to capture these queries? Are there specific settings or modules in Odoo that allow SQL debugging for accounting-related transactions? Can PostgreSQL logs or Odoo's built-in logging be configured to filter only queries related to the account.move and account.move.line tables? I'm using Odoo

How to Log SQL Queries Related to Odoo Accounting Transactions?

Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

ลูกค้าสัมพันธ์
e-Commerce
ระบบบัญชี
สินค้าคงคลัง
PoS
Project
MRP

All apps

All Posts คน เหรียญรางวัล

แท็ก (View all)

odoo accounting v14 pos v15

เกี่ยวกับฟอรั่มนี้

ช่วยเหลือ

How to Log SQL Queries Related to Odoo Accounting Transactions?

accounting log sql queries

1 ตอบกลับ

1457 มุมมอง

Community Question

I'm troubleshooting an issue in Odoo's Accounting module and need to track the exact SQL queries executed when creating, modifying, or posting invoices, journal entries, and payments.

How can I enable logging to capture these queries?
Are there specific settings or modules in Odoo that allow SQL debugging for accounting-related transactions?
Can PostgreSQL logs or Odoo's built-in logging be configured to filter only queries related to the account.move and account.move.line tables?

I'm using Odoo 16.0 on Odoo.sh.

Any advice on the best approach to capture and analyze these SQL queries would be appreciated!

ODOO_Aspirant

very usefull @ray Carnes

Ray Carnes (ray)

คำตอบที่ดีที่สุด

1) Connect to a STAGING branch of Odoo.sh (where you can modify the configuration file to trigger logging)

this step just ensures there are active Workers started

2) Connect to the Terminal via the SHELL tab, and start nano (a text editor) and open the Odoo configuration file:

nano ./.config/odoo/odoo.conf

3) Cursor down in the file and add the following two lines:

log_level=debug_sql
log_handler=odoo.addons.account:DEBUG

4) Use CTRL-O and ENTER to save the changes, then CTRL-X to exit

5) Restart Odoo:

odoosh-restart http

6) Open the logfile

lnav ~/logs/odoo.log

7) Review it while using Odoo, potentially using timestamps to quickly locate the place where Odoo is responding to what you are doing in the UI and logging the SQL:

You can also review the log files via the LOGS tab if that's easier

สนุกกับการพูดคุยนี้ใช่ไหม? เข้าร่วมเลย!

สร้างบัญชีวันนี้เพื่อเพลิดเพลินไปกับฟีเจอร์พิเศษและมีส่วนร่วมกับคอมมูนิตี้ที่ยอดเยี่ยมของเรา!

ลงชื่อ

Related Posts	ตอบกลับ	มุมมอง
Print the result of an SQL queries sql queries	0 มี.ค. 15	4577
Translate term get by SQL Queries sql translate queries	0 ก.ย. 22	6631
How do I view PostgreSQL logs? แก้ไขแล้ว postgresql log sql	1 ก.พ. 18	10599
unique multiple fields แก้ไขแล้ว accounting sql invoice.line	1 เม.ย. 25	14376
How to add practical_amount and theoretical_amount in pivot view? แก้ไขแล้ว accounting account_budget sql pivot computed-fields	4 มี.ค. 21	6499

คำถามนี้ถูกตั้งค่าสถานะ

สนุกกับการพูดคุยนี้ใช่ไหม? เข้าร่วมเลย!