Features

• Batch document with chatter — l10n.ro.account.partner.confirmation with date, company, Customers / Suppliers / Both selector, partner/account filters and a state bar draft → generated → pdf_ready → sent → done. Each batch gets a sequence-driven name (CONF/2026/00001).
• Per-partner line — l10n.ro.account.partner.confirmation.line with its own state (draft / no_balance / no_email / ready / sent / error), error message, PDF attachment and sent-date timestamp. Lines inherit mail.thread for full audit trail.
• Configurable internal numbering — last_number on the batch holds the free-text counter (e.g. CONF-2026-100). The numeric suffix is auto-incremented per generated line, preserving any prefix and zero-padding, so you can match your in-house archive.
• Historic balance computation — _compute_balances runs a raw SQL query that returns one row per account.move.line with its residual at the cutoff, accounting only for partial reconciliations whose max_date is on or before the date. Each balance is grouped by (account, currency); manual additions to the line are kept and zeroed if no movement is found.
• Account-type aware — picks asset_receivable, liability_payable plus the extra variants from l10n_ro_account_extra_types based on the Customers / Suppliers / Both selector. Optional account filter narrows further.
• PDF generation in bulk — _generate_pdfs renders the report_partner_confirmation QWeb report (paper format base.paperformat_euro), saves it as ir.attachment on each line, with a fallback chunked re-render on errors and per-line state reporting.
• Bundled bilingual mail template — mail_template_partner_confirmation renders the email body in the partner's language with the PDF auto-attached.
• Smart-button dashboard — the batch form shows live counters for generated lines, PDF-ready, sent, no-email, error and missing balance, with click-through to filtered line lists.
• Romanian menu — Accounting → Romania → Balance Confirmations, visible to users in account.group_account_user.

Configuration

The module ships with everything pre-wired (mail template, sequence, report). You only need to make sure your partners have an email address and to review the email template before the first bulk send.

1. Partner email addresses

Open Contacts and verify that each partner you plan to confirm has its Email field set. Lines created for partners without an email switch to No Email state and are not sent; they still appear on the batch so you can fix them and rerun.

2. Email template

Open Settings → Technical → Email Templates and edit Partner Balance Confirmation (l10n_ro_account_partner_confirmation.mail_template_partner_confirmation). The body uses the partner's language (object.partner_id.lang) and auto-attaches the PDF as Balance_confirmation_<partner>.pdf. Adjust the wording, signature or the 5 days reply window to match your internal procedure.

You can swap the template at the batch level via the Email Template field; it only lists templates whose model is l10n.ro.account.partner.confirmation.line.

3. Document numbering

The batch document number is generated from sequence l10n.ro.account.partner.confirmation — prefix CONF/%(year)s/, 5 digits, no per-company restriction. Adjust the sequence at Settings → Technical → Sequences if you need a different format.

For the line numbering displayed on each PDF, set the Last Number field on the batch before clicking Generate. The numeric suffix increments per line; any text prefix is preserved. Example: CONF-2026-100 produces CONF-2026-101, CONF-2026-102, …

4. Access rights

The menu and document are restricted to account.group_account_user. Record-level rules (security/partner_confirmation_security.xml) scope batches to the user's allowed companies.

5. Optional account scoping

If you operate with multiple receivable / payable accounts and want to confirm only a subset (e.g. only 4111 + 4118, leaving 461 out), fill the Accounts filter on the batch. The selector is restricted to asset_receivable, liability_payable, asset_extra_receivable and liability_extra_payable of the same company.

How it works

Open Accounting → Romania → Balance Confirmations and click New.

1. Create the batch

1. Pick the Date (defaults to today). Balances are computed at end-of-day of this date; partial reconciliations with max_date later than this date are reversed.
2. Pick Confirmation Type: Customers, Suppliers or Customers & Suppliers.
3. Optional: restrict to a list of Partners and / or Accounts. Leave both empty to include every partner with an open balance.
4. Optional: type a starting Last Number (e.g. CONF-2026-100) to control the per-line document number.

2. Generate the lines

Click Generate. The module:

• queries account.move.line for posted lines on the chosen account types, grouped per (partner, account, currency);
• creates one batch line per partner with sequential numbering;
• computes the residual at the cutoff date for each line;
• sets the line state to Ready (email present), No Email (missing email) or No Balance (nothing open).

3. Generate the PDFs

Click Generate PDFs. The QWeb report report_partner_confirmation is rendered for every Ready / Error line and saved as an ir.attachment on the line. You can preview / download any PDF from the line form. The batch state moves to PDFs Ready.

4. Send the emails

Click Send Emails. The bundled mail template is sent to each Ready line, with the PDF auto-attached. The line switches to Sent and records sent_date; sending errors set the line to Error with the message in error_message.

When no line is left in Ready, the batch state moves to Sent.

5. Wrap up

Click Done when the campaign is closed. The batch keeps a full trail of every line, attachment and email in the chatter, so you can revisit the campaign later (e.g. when auditors ask for evidence that balance confirmations were sent).

Recomputing a single line

Open any line and click Recompute. The line state goes back to draft, the previous attachment is removed, balances are recomputed at the current cutoff date and the line is re-evaluated for email readiness. Lines already in Sent are skipped to protect history.

Versions

19.0.1.0.0 (2026-05-24)

• Changelog tracking starts at this release.