Guys, juts a remark: iReport is probably better than anything we had previously in OpenERP indeed. That being said, I think the ultimate report engine is rather BIRT: http://www.infoq.com/articles/birt2-intro Pentaho/iReport and Jasper have some advantages over BIRT like metadata (do we have a Jasper or Pentaho metadata "provider" for OpenERP or do you plug it directly on the DB?), but there are even guys now attempting to plug BIRT over Pentaho metadata and I think this could be great: http://www.osbi.fr/?p=1664
Regards, Raphaël Valyi Founder and ERP Consultant +55 21 3010 9965 http://www.akretion.com <http://www.akretion.com.br/> <http://www.osbi.fr/?p=1664> On Mon, Sep 13, 2010 at 8:43 AM, David Mitchell (www.novapointgroup.com) < [email protected]> wrote: > This is one reason why we're doing reports in Jasper using the > jasper_reports module when we can. The layout flexibility is very strong > and > you can make very nice visual reports (invoice, etc), and even business > intelligence reports with embedded flash. We encourage everyone to check > out > some of the capabilities of iReport as a designer. (It is used by > OpenBravo, > OpenTaps, etc). > There are some areas where additional development is needed to improve the > interface between OpenERP and iReports, but it does work. We have it > working > on v6 as well. > > David Mitchell > NovaPoint Group > [email protected] > > On Mon, Sep 13, 2010 at 7:27 AM, Carlos Liebana > <[email protected]>wrote: > > > Off topic but related: About reports, in general, maybe it's about time > > to redesign them (in design terms). IMHO and also from the feedback of > > our implementations, standard reports (invoices, quotations, etc) in v5 > > are ugly. > > > > -----Mensaje original----- > > De: openerp-expert-accounting-bounces+carlos.liebana=ting.es@ > > lists.launchpad.net [mailto: > > > openerp-expert-accounting-bounces+carlos.liebana<openerp-expert-accounting-bounces%2Bcarlos.liebana> > > [email protected]] En nombre de Fabien (Open ERP) > > Enviado el: lunes, 13 de septiembre de 2010 13:02 > > Para: [email protected] > > Asunto: [Openerp-expert-accounting] [Bug 551630] Re: Financial reports to > > review for 6.0 > > > > Frederic, > > > > You did a great job. I reviewed your document and send to the developers > > for implementation. > > > > I put my comments in dark bold in document. Keep in mind that if I > > strikeout some lines, it's not because it's a bad idea but simply > > because it does not fit our goals for v6.0. New features may be > > implemented for v6.1. > > > > Thanks for the contribution. > > > > -- > > 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 > > > > > > _______________________________________________ > > Mailing list: https://launchpad.net/~openerp-expert-accounting< > https://launchpad.net/%7Eopenerp-expert-accounting> > > Post to : [email protected] > > Unsubscribe : https://launchpad.net/~openerp-expert-accounting< > https://launchpad.net/%7Eopenerp-expert-accounting> > > More help : https://help.launchpad.net/ListHelp > > > > -- > > 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 > > > > > > > > _______________________________________________ > > Mailing list: https://launchpad.net/~openerp-expert-accounting< > https://launchpad.net/%7Eopenerp-expert-accounting> > > Post to : [email protected] > > Unsubscribe : https://launchpad.net/~openerp-expert-accounting< > https://launchpad.net/%7Eopenerp-expert-accounting> > > More help : https://help.launchpad.net/ListHelp > > > > -- > Financial reports to review for 6.0 > https://bugs.launchpad.net/bugs/551630 > You received this bug notification because you are subscribed to > OpenObject Addons. > > 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 > > > -- 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 _______________________________________________ Mailing list: https://launchpad.net/~openerp-expert-accounting Post to : [email protected] Unsubscribe : https://launchpad.net/~openerp-expert-accounting More help : https://help.launchpad.net/ListHelp
