Features

• Romania - Journal Registry report variant — registered as a variant of the stock General Ledger (root_report_id = account_reports.general_ledger_report), country-scoped to Romania (country_id = base.ro). Columns: Date, Partner, Counterpart, Currency, Debit, Credit, Balance.
• Counterpart column — the custom handler l10n.ro.account.general.ledger.report.handler overrides _report_custom_engine_general_ledger to enrich each AML-level row with the code of l10n_ro_counterpart_id.
• Print RO button — injected via _custom_options_initializer whenever the active company's account_fiscal_country_id.code == "RO". The button snapshots the current GL options (period, journals, account filter, search bar, unfolded lines) as JSON and opens the print wizard.
• Print wizard (l10n.ro.account.report.print.wizard) — two report types (Account Sheet vs. Journal Registry) and three output formats (XLSX, PDF, CSV). The Excel split option produces one sheet per month or quarter with per-account opening / closing balances recomputed for each sub-period.
• P&L vs. B/S initial balance — opening balances for income / expense accounts sum activity from the start of the fiscal year (via compute_fiscalyear_dates); for asset / liability / equity / off-balance accounts the opening sums all prior activity.
• Chunked PDF rendering — accounts are batched so each wkhtmltopdf render stays under PDF_MAX_LINES_PER_CHUNK = 5000 AML lines (mitigates the ulimit -n 1024 open-files ceiling for multi-million-line periods); chunks are merged via PyPDF2 / pypdf.

Configuration

The module is plug-and-play: no master data has to be created specifically for the Romania Account Sheet / Journal Registry. A few prerequisites have to be in place so the variant and the Print RO button behave as expected:

1. Romanian fiscal country — the Print RO button is appended to the GL options only when env.company.account_fiscal_country_id.code == "RO". Set the fiscal country on Settings → Companies if it is not already set to Romania.
2. Counterpart computation — install l10n_ro_account_counterpart (declared as a dependency, installed automatically); it populates account_move_line.l10n_ro_counterpart_id, which the custom handler reads to fill the Counterpart column on the variant and in the wizard exports.
3. Extra account types — depends on l10n_ro_account_extra_types for the income / expense sub-types used by the wizard when computing the fiscal-year opening balance for P&L accounts.
4. Fiscal-year configuration — the wizard's opening balance for income / expense accounts is summed from the start of the fiscal year computed via company.compute_fiscalyear_dates(date_from). Configure the company's fiscal year start (defaults to January 1) on Settings → Companies so the per-account initial balance matches the year you expect.
5. Posted entries only — the SQL fetcher filters on parent_state = 'posted', so unposted moves do not appear in the wizard exports.
6. PDF dependencies — the chunked PDF rendering requires PyPDF2 (>=2 PdfMerger, 1.x PdfFileMerger) or the renamed pypdf package. The wizard probes each in turn and raises a UserError if none is installed.

Access to the wizard is granted via account.group_account_user (declared in security/ir.model.access.csv); no further role configuration is required.

How it works

Reaching the report

Open Odoo's stock General Ledger via Accounting → Reporting → General Ledger. For companies whose fiscal country is Romania the variant selector at the top of the report exposes Romania - Journal Registry, which is registered as a variant of the General Ledger (root_report_id = account_reports.general_ledger_report).

The variant inherits Odoo's native pagination, drill-down to account.move, search bar and built-in PDF / XLSX export from account_reports, and adds a Counterpart column populated from l10n_ro_counterpart_id on each line.

Print RO button

Whenever the active company's fiscal country is Romania, a Print RO button is appended to the GL toolbar (both on the stock GL and on the RO variant). Clicking it:

1. Snapshots the current GL options (period, journals, account filter, search bar, unfolded lines) as JSON onto l10n.ro.account.report.print.wizard.options_json.
2. Tries to pre-fill the wizard's account_ids from the GL state — either from options["account_ids"] (explicit account filter), the search-bar text resolved against account.account.display_name, or any unfolded-line key encoding account_id|<id>.
3. Opens the wizard in a modal dialog.

Wizard fields

What happens on Generate

1. The wizard parses the GL options snapshot to recover the date range, the journal ids and any account filter; missing values fall back to current-year and all-journals-of-the-company.
2. A single SQL query fetches every posted AML in the period joined to its account, move, counterpart account, partner and currency, ordered by account_code, date, move.name, aml.id. A second query computes opening balances per account, with P&L accounts summed from the fiscal-year start (compute_fiscalyear_dates) and B/S accounts summed from the beginning of time.
3. A running cumulated balance is computed per account in Python and the lines are grouped by account.
4. The selected renderer is invoked:
   • XLSX — one sheet per account (Account Sheet), or one sheet per month / quarter (Journal Registry + Split) with per-account opening / closing balances recomputed for each sub-period, or a single sheet with per-account sub-headers.
   • CSV — single file with a header block per account and a blank separator row between accounts.
   • PDF — accounts are batched into chunks bounded by PDF_MAX_LINES_PER_CHUNK = 5000 AML lines, each rendered via the QWeb template and merged via PyPDF2 / pypdf.
5. The generated file is streamed back through /web/content for immediate download.

If no AML matches the filter the wizard raises a UserError instead of producing an empty file.

Versions

19.0.0.1.0 (2026-05-24)

• Changelog tracking starts at this release.