Skip to Content

PMIS Account Financial Report

Beta License: AGPL-3 PMISuite/stock-accounting Version: 18.0

Extends OCA's account_financial_report with selected fiscal-date domains, QWeb report changes, and company-currency handling for XLSX exports. It uses the existing OCA menus, wizards, and report actions.

Table of contents

Date behavior

The shared fiscal_date comes from pmis_account_dates. The changes are limited to the following paths:

  • Trial Balance: initial balance and period computation domains use fiscal_date. The overridden QWeb initial, debit, credit, period-balance, and ending-balance drill-down domains use it too.

  • General Ledger: the QWeb initial/previous balance drill-down domain uses fiscal_date; the period computation still uses the accounting date.

  • Journal Ledger: QWeb displays each line's fiscal date. Entry selection still uses the accounting date, and the XLSX date column remains unchanged.

  • VAT Report: QWeb net and tax drill-down domains use fiscal_date. The underlying net and tax computations still use the accounting date.

  • Open Items: the shared unreconciled-line cutoff domain uses fiscal_date. Other upstream date and reconciliation logic is retained.

This addon does not convert every report to fiscal dates or switch reports to tax_date. When fiscal and accounting dates differ, a fiscal-date drill-down can show a different set of lines from the accounting-date total. The General Ledger, Journal Ledger, Open Items, and Aged Partner Balance XLSX date columns retain their upstream accounting-date behavior.

XLSX company currency

The XLSX report wrapper takes the company from serialized report data when available and passes it through the rendering context. Currency lookup can therefore succeed even if the transient wizard no longer exists. Without a usable company in that context, lookup falls back to OCA's implementation.

Configuration

Dependencies are account, date_range, report_xlsx, account_financial_report, and pmis_account_dates.

There is no PMIS date-mode toggle. The overrides apply when installed. Configure fiscal-date defaults through the shared accounting-dates addon and any installed date-policy extensions. OCA owns report access, wizard options, currencies, and Aged Partner Balance interval configuration.

Usage

  1. Open the required report under Reporting > OCA accounting reports in the accounting application.

  2. Select the company, period, accounts, and entry options in the OCA wizard.

  3. Generate the report or XLSX export using the existing actions.

  4. When inspecting report lines, account for the date differences described above, especially when following General Ledger or VAT drill-down links.

Bug Tracker

Bugs are tracked on PMISuite Repository Issues. In case of trouble, please check there if your issue has already been reported. If you spotted it first, help us smashing it by providing a detailed and welcomed feedback.

Credits

Authors

Contributors

  • Matjaž Mozetič

Maintainers

LUXIM MATMOZ

Current maintainer:

sysadminmatmoz

Luxim is an independent R&D and deployment company focused on solving complex problems in the Odoo ecosystem.

Odoo Community Association

Luxim is an active member of OCA (Odoo Community Association).