Odoo Changelog — 2022-06-23

Thursday, June 23, 2022

1 change

New Features(1)

New functionality added to Odoo

[IMP] documents_spreadsheet_account: introducing accounting formula

Enterprisemasterdocuments_spreadsheetspreadsheetspreadsheet_accountMEDIUM

Business users can now pull accounting values such as credits, debits, balances, fiscal year dates, and account groups directly into Odoo spreadsheets. This makes financial reporting more flexible by allowing spreadsheet formulas to target specific accounts, date ranges, and companies without manual data extraction.

Original PR description

This commit introduces accounting specific formulas to
documents_spreadsheet.

Namely:
- `ACC.CREDIT`: returns the sum of credit for a given account
- `ACC.DEBIT`: returns the sum of debit for a given account
- `ACC.BALANCE`: returns the sum of balance for a given account

All functions can target specific accounts over specific date ranges
by providing a code prefix of the former and a date desciption of the
later.

They can also target specific companies.

Task 2782382

#accounting#spreadsheets#financial reporting#formulas