openerp-expert-accounting team mailing list archive
-
openerp-expert-accounting team
-
Mailing list archive
-
Message #00794
Re: [Bug 551630] Re: Financial reports to review for 6.0
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) <
david@xxxxxxxxxxxxxxxxxx> 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
> david@xxxxxxxxxxxxxxxxxx
>
> On Mon, Sep 13, 2010 at 7:27 AM, Carlos Liebana
> <carlos.liebana@xxxxxxx>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>
> > =ting.es@xxxxxxxxxxxxxxxxxxx] En nombre de Fabien (Open ERP)
> > Enviado el: lunes, 13 de septiembre de 2010 13:02
> > Para: openerp-expert-accounting@xxxxxxxxxxxxxxxxxxx
> > 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 : openerp-expert-accounting@xxxxxxxxxxxxxxxxxxx
> > 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 : openerp-expert-accounting@xxxxxxxxxxxxxxxxxxx
> > 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
References
