openerp-expert-accounting team mailing list archive

[Joël Grand-Guillaume @ CampToCamp <joel.grandguillaume@xxxxxxxxxxxxxx>]

Hi all,


I must say that I (obviously) agree with Luc ;) ! Joke put a side, I think that this issue is not a little one. People won't invest in an ERP which doesn't provide the right numbers or not conform to the law...

>From that point, all financial report are not ok regarding to the law
(at least in CH and FR).

As Luc said, we already did the job for 4.2, and it was a huge work ! I
link to this post the concerned module in a zip file (contains 4 modules
for 4.2). This could help to improve the existing (how do we compute
stuff, what kind of option are we using in the wizard, etc...). I also
put the c2c_fiscal_year_close module we did, as financial report are
very related to this topic. Note that report in
c2c_finance_report_extended are more complete even if they don't run
with RML but with our c2c_reporting_tools module...

>From there, and with a certain will of course, I think it's possible to
have something good for 5.0 without spending weeks on them, just by
taking what we've done !

So, I ask you OpenERP SA to consider this as a strong request from
Partner side ! More over, you said you'll fix every troubles regarding
Country related Accounting law & OpenERP, so we are in this case now !

Thanks in advance to consider our request seriously ! We will help as
much as we can to help you if you need guidance through this process...
just ask.

Best regards,



** Attachment added: "c2c_finance_report_modules.zip"
   http://launchpadlibrarian.net/43352010/c2c_finance_report_modules.zip

-- 
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