Try the meaning layer.

Revenue is not one universal account.move field; select an accounting basis, population, date, tax treatment, refund policy, company, and currency before calculation. Alternatives: gl_accrual_revenue: Posted journal items on income/income_other accounts by accounting date, usually in company currency; report/localization rules may refine the result.; invoiced_sales: Posted customer invoices net of selected customer credit notes by invoice or accounting date; this is invoicing activity, not automatically recognized revenue.; cash_received: Customer cash/payment activity by payment or reconciliation date; this is not the same as accrual revenue. Clarify: Do you mean general-ledger revenue, invoiced sales, or cash received? Should other income be included? Should the result be before or after tax and refunds? Which company or consolidated company set applies? Which currency and conversion policy applies? Which date basis and timezone define the period? Limits: Tenant fiscal policy and localization can change the correct answer. No revenue metric should be emitted from this entry until the requested alternative is resolved.

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.

Account moves and move lines are constrained to the user's allowed company IDs by global record rules; inaccessible records must not be reported as nonexistent. Security implication: Preserve the requesting user's allowed-company context. If a result may be incomplete because of access, say so; never use sudo to make an answer look complete. Limits: Allowed-company scope is not necessarily the same as the user's currently selected company. Additional module or tenant record rules can narrow visibility further.