openerp-expert-accounting team mailing list archive

["Frederic Clementi - Camptocamp.com" <551630@xxxxxxxxxxxxxxxxxx>]

We have finished testing new financial reports on the 6.0. I must say
that it is a big step forward.

Quick summary of what we like the most:
- Chart of account can be filtered by period
- All filters in reports works fine. On all reports, you can select periods and posted/draft entries.
- Layout printout issues have been solved 
- "Initial balance" checkbox on General Ledger works perfectly (unticked by default)
- General Ledger and Trial balance are now correct
- And performance has been improved (although we have not done testings with many entries) 

Now... what still does not work? Partner reports initial balance

- There is an "Initial balance" checkbox for the Partner ledger but works only for Partners with transactions during current FY. If there is no move entry during the current year, the initial balance (IB) is simply not shown (neither the partner).
- Opening entries do not appear on the report. (I must specify that the deferral method selected is "unreconciled" for creditors and debtors but does not generate opening entries split by partner ; I see only one grouped entry line with empty partner column. (see my bug report 655595)
On that point, I need clarification please : I think that the partner ledger will work only if the deferral method for debtors & creditors is "unreconciled" otherwise impossible to get initial balance for each partner - is it correct?

- Small layout problem: on partner ledger, please increase size of
column "currency" - we do not want to see the currency symbol on a new
line.

And a final comment, I did not test centralized and general Journal but
I think both reports give exactly the same report.

I leave apart the aged partner report for the moment (we need a fixed
partner ledger first)

Thanks to OpenERP team for this excellent job.

We are getting closer and closer to what we need... !

Frederic

-- 
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: In Progress

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