openerp-expert-accounting team mailing list archive

[Hervé Proust - www.kazacube.com <551630@xxxxxxxxxxxxxxxxxx>]

Hello,

I see improvements on an issue I consider as critical for the future of
OpenERP (quality, fiability and coverage of financial reports and also
good level of performance, i.e. capacity to print a general ledger
without timeout...). We agree mostly with requests from c2c.

Some additional comments:
- Account balance: initial balance is requested by our certified accountant on one single report (and not by generating one report per fiscal year)
  * Fiscal year report: if the report shows the full year N, the initial balance should be equal to balance beginning of year N (= opening entries for balance sheet accounts)
  * Period report: if the report is limited to one period N, the initial balance should be equal to balance end of period N-1 (for all acounts..., but only for the running fiscal year for income statement accounts. That is where I guess it becomes tricky... )
- Translation: trial balance = general balance (and not "solde de compte" in standard french.po)
- Comparison of yearly results: is it possible or planned to add "comparison" reports as proposed by the module "Account_balance_compare years" to the standard reports? (which would be presented in columns and not in two reports in one)
- Layout: is it possible to edit reports with thousands separators?
- Tax report: did you consider modifying the tax report which does not calculate correctly partial payments for payment based VAT declaration? cf. 587707 Print Taxes Report Base on Payments

Best regards

-- 
Financial reports to review for 6.0
https://bugs.launchpad.net/bugs/551630
You received this bug notification because you are a member of OpenERP
Accounting Experts, which is a direct subscriber.

Status in OpenObject Addons Modules: Confirmed

Bug description:
Hello,

As discuss during the community days, all financial reports have to be reviewed.

The list of modification has been created by Quentin, please ask him for more information => here are the most important things to change :

== Account balance  ==

 * Wizard
     * add currency balance amount => check box
     * add comparison with other fiscal year
     * filter => only by date / by periode / none => from ... to for both date and period (period really based on period and not on dates) 
     * filter => dependant to the fiscal year (only see period related to the fiscal year selected)

* Calculation
     * sum of all entries related to the account into the date filter selection

== General ledger ==
 * Wizard
     * add “with opening balance" => to have a new line with the sum of all entries that are before the begin date/periode
     * Use the “Display history” check box => add a new select field (see quentin notes)
     * add cumulative balance column

Calculation
     * list of all entries related to the account into the date filter selection

== Partner balance ==
* Wizard
     * add "balance date"
     * add new selection “partner with movement / balance <> 0 / all
     * Also available on the partner (automatic selection of the partner) => important if multi selection

* Calculation
     * selection of client vs supplier based on the internal account type
     * sum of all entries related to the account into the date filter selection group by partners

== Partner ledger ==
 * Wizard
     * add "balance date"
     * add new selection “partner with movement / balance <> 0 / all
     * Add choice “open amount only / paid amount only / all entries”
     * Add sort option (date, entry number, amount, due date)
     * Also available on the partner (automatic selection of the partner)

* Calculation
     * add store field “last pmt date” => define if paid or date at a specific date
     * selection of client vs supplier based on the internal account type
     * list of entries group by client