Live verified decision
What is revenue?
A raw schema invites a shortcut: sum account.move.amount_total. The verified runtime refuses that guess and identifies what must be decided first.
Clarify before querying
- Do you mean general-ledger accrual revenue, invoiced sales, or cash received?ocl.odoo19.account.disambiguation.revenue · revision 1
- Which date basis and timezone define the reporting period?ocl.odoo19.account.disambiguation.revenue · revision 1
- Should the result be before or after tax and refunds, and include other income?ocl.odoo19.account.disambiguation.revenue · revision 1
Correction kept with the answer
Do not calculate revenue by summing account.move.amount_total across account.move records. Wrong approach: Treat account.move as an invoice table and sum amount_total for the period. Correction: Resolve the revenue definition first. For GL revenue, work from posted account.move.line records and applicable income accounts/report rules; for invoiced sales, explicitly discriminate document types, states, dates, refunds, tax basis, company, and currency. Limits: The corrected GL metric remains a candidate until localization, sign, currency, and report reconciliation fixtures pass.
ocl.odoo19.account.negative.sum_account_move_amount_total_as_revenue · verified · revision 1