openerp-expert-accounting team mailing list archive

[Borja López Soilán (Pexego) <borjals@xxxxxxxxx>]

By the way, I just noticed that the "Print Journal" ("Print General
Journal", "Print Central Journal") reports where not mentioned.

Those reports are broken too:

  - If I select several journals (like all of them), and I select several periods (all of the periods of one fiscal year):
    => If any of those journals doesn't have moves at all, it will just raise an "No records found for your selection!" exception and won't allow me to continue.
    => If all the journals have at least a move on any period, and any of the journal-period pairs doesn't have moves, it will print an unparsed report (ouch!) and errors like this one will be printed on the log:
        [2010-04-07 16:56:55,282] ERROR:report:[18]: report :
        [2010-04-07 16:56:55,283] ERROR:report:[19]: Traceback (most recent call last):
        [2010-04-07 16:56:55,283] ERROR:report:[20]:   File "/home/datos/Proyectos/openerp/openobject-server/current/bin/report/render/rml2pdf/utils.py", line 114, in _process_text
        [2010-04-07 16:56:55,283] ERROR:report:[21]:     txt = eval(expr,self.localcontext)
        [2010-04-07 16:56:55,283] ERROR:report:[22]:   File "<string>", line 1, in <module>
        [2010-04-07 16:56:55,283] ERROR:report:[23]: IndexError: list index out of range
        [2010-04-07 16:56:55,284] ERROR:report:[24]: 
        [2010-04-07 16:56:55,284] ERROR:report:[25]: list index out of range
        [2010-04-07 16:56:55,284] ERROR:report:[26]: expr: formatLang(sum_credit(line[0].period_id.id, line[0].journal_id.id))

I think this is what should be done:

== Print *** Journal ==
 * Wizard
     * Let the user select journals without moves.
     * Add an option to print the moves by journal (like it does now) or together like there was a single journal (needed on countries like Spain [though we currently can work it around by using the account_financial_reports module])

* Calculation
     * Ignore journals without moves, and journal/periods without moves (don't try to print them).
     * If the "by journal" option was selected, print the moves grouped by journal. If not, print all the moves without grouping, but add a 'journal' column with a reference to the journal code.

-- 
Financial reports to review
https://bugs.launchpad.net/bugs/551630
You received this bug notification because you are a member of OpenERP's
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