How to Log SQL Queries Related to Odoo Accounting Transactions?

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

Ray Carnes (ray) · Accepted Answer

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:
image [1]
*nano ./.config/odoo/odoo.conf*
3) Cursor down in the file and add the following two lines:
image [2]
*log_level=debug_sql*
*log_handler=odoo.addons.account:DEBUG*
4) Use CTRL-O and ENTER to save the changes, t

Aiheeseen liittyviä artikkeleita	Vastaukset	Näkymät
Print the result of an SQL queries sql queries	0 maalisk. 15	5266
Translate term get by SQL Queries sql translate queries	0 syysk. 22	7414
How do I view PostgreSQL logs? Ratkaistu postgresql log sql	1 helmik. 18	11434
unique multiple fields Ratkaistu accounting sql invoice.line	1 huhtik. 25	15183
How to add practical_amount and theoretical_amount in pivot view? Ratkaistu accounting account_budget sql pivot computed-fields	4 maalisk. 21	7244

Tämä kysymys on merkitty

Nautitko keskustelusta? Älä vain lue, vaan osallistu!