openerp-expert-accounting team mailing list archive

[Luc Maurer <luc.maurer@xxxxxxxxxxxxxx>]

Hello All,

Many thanks Colin => we have tested the multi-currency, normally, all is ok.

Could all partner make a lobying to OpenERP SA because they do not want to
commit the new Webkit report into the trunk..... I hope that if lot's of
people are telling them to do it, they will change they mind ;-)

Regards
*
Luc Maurer*
Directeur et associé

*Camptocamp SA*
PSE A
1015 Lausanne
Suisse

Mobile : +41 79 606 07 73
Direct : +41 21 619 10 12

*Camptocamp France SAS*
48 avenue du Lac du Bourget
73372 Le Bourget du Lac
France

Mobile : +41 79 606 07 73
Direct : +33 479 44 44 95
www.camptocamp.com


On Mon, Sep 19, 2011 at 14:56, Colin MacMillan <colin@xxxxxxxxxxxxxxxxxxxxxx
> wrote:

> Frédéric, just finish testing the reports.  I have to say all looking good
> here.
>
>
>
> Particularly like that both reports picking up opening balances correctly.
> ‘Report date’ field in Partner Ledger – golden feature and working
> perfectly.
>
>
>
> The only thing I have not tested is multi-currency as my database is
> lacking meaningful data.
>
>
>
> Superb :)
>
>
>
>
>
> *From:* openerp-expert-accounting-bounces+colin=
> publicus-solutions.com@xxxxxxxxxxxxxxxxxxx [mailto:
> openerp-expert-accounting-bounces+colin=
> publicus-solutions.com@xxxxxxxxxxxxxxxxxxx] *On Behalf Of *Frédéric
> Clementi
> *Sent:* 14 September 2011 14:38
> *To:* openerp-expert-accounting@xxxxxxxxxxxxxxxxxxx
> *Subject:* Re: [Openerp-expert-accounting] Shiny brand new webkit
> financial reports
>
>
>
> Manay many thanks for those who already try to test the module and face
> problems:
>
>
>
> Please consider 2 things :
>
> 1st - OpenERP apps takes time to get updated with recent fixes so rather
> use the branch : lp:c2c-financial-addons/6.0
>
> 2nd : Demo data are unfortunately creating only opening/closing period
> ('special') so untick the checkbox in all periods (except the opening one)
> ... ;)
>
> Do not give up !
>
>
> Frédéric CLEMENTI
> Business Solutions
> Camptocamp SA
> Tel : + 41 (0)21 619 1041
> http://www.camptocamp.com
>
>
>
>
>
>  <frederic.clementi@xxxxxxxxxxxxxx>
>
>
>
> Le 14 septembre 2011 13:49, Frédéric Clementi <
> frederic.clementi@xxxxxxxxxxxxxx> a écrit :
>
> Hi Folks,
>
>
>
> We already tweeted the information so I think most of you are already aware
> that Camptocamp is developping financial repports using the webkit render
> engine.
>
>
>
> We really took the necessary time to get reports:
>
> - Reliable (complex used cases tested),
>
> - Fast (14min for 100 000 move lines / 2143 pages) - I remind that
> performance is reached with no extra dedicated server - a simple webkit
> library added !)
>
> - and Generic (we think these reports can be used in any country and any
> business)
>
>
>
> Nevertheless, we also really would like to get feedback from the community.
>
>
>
>
>
> You can already download the v6 module from Openerp apps :
> http://apps.openerp.com/addon/6244?filter={%22order_by%22%3A+%22click_counter+desc%22%2C+%22text_search%22%3A+%22webkit%22}&page=0<http://apps.openerp.com/addon/6244?filter=%7B%22order_by%22%3A+%22click_counter+desc%22%2C+%22text_search%22%3A+%22webkit%22%7D&page=0>
>
>
>
> We have backported this module to v5 (we will publish it soon) and we will
> maintain this module for future version ...unless OpenERP accept to use it
> as standard financial reports which would be even better of course :)
>
>
>
> So far we are done with the general ledger and the partner ledger (PL
> report being in fact, if you give a closer look, the equivalent of 3 reports
> : all partner entries, open invoices only and open invoices as of...'report
> date'-> see below).
>
>
>
> We plan mid-october to also add the trial balance and partner balance (with
> previous year comparisons) ; the aged partner balance should hopefully
> follow later (but not sure yet we will find the time)
>
>
>
>
>
> Here are the functionalities we have added to the GL & PL reports :
>
>
>
> **The General leder: details of all entries posted in your books sorted by
> account.*
> - Correct opening balance calculation : even if you do not have created
> your opening entries yet. If you did so, system will simply uses your
> opening entries amounts otherwise it will be calculated backwards until the
> last opening entries posted. (it remains important to post opening entries
> if you do not want to loose performance but with few data it is not
> mandatory anymore)
>
> - Filter by account in the wizard (no need to go to the Chart of account to
> do this anymore) or by view account (the report will display all regular
> children account) ie: you can select all P&L accounts.
>
> - Thanks to a new checkbox in account form, you will have possibility to
> centralize any accounts you like. ie: you do not want to see all entries
> posted under the account ‘VAT on sales’ ; you will only see aggregated
> amounts by periods. This option can save hundreds of useless pages !
> - The report will now print only account' with movements OR with a balance
> not null'. No more endless report with accounts with no data. (the field:
> display account is hidden in the wizard). This mean that even with a
> long/unclean chart of account, you see still have a sexy report with only
> usefull data (...as 'sexy' a financial report can be of course)
> - Reports now show cumulative balances
> - You can filter, for exemple from the 02/2011 to 06/2011 with an opening
> balance that will includes not only previous years data but also data from
> begining of fiscal year until the period start of your filter ; so you will
> always match with your trial balance.
> - User name added on foot page (+ date, time, page of course)
> - Counterpart account displayed for each transaction (3 accounts max.) to
> ease searching.
> - Better ergonomy on the wizard: important information at the top, filters
> in the middle, options at the bottom, more specific filtering on a different
> tab. No more unique wizard layout for all financial reports (ie: we have
> removed the journal tab useless for the GL report)
> - And an improved style
>
> **The partner ledger: details of entries relative to payable & receivable
> accounts posted in your books sorted by account and partner.*
> - Filter by partner now possible (eventually!)
> - Possibility to print 'unreconcilied transactions only' *at any date in
> the past* (thanks to the brand-new field: last_rec_date which calculated
> the last move line reconciled date). No more pain to get open invoices at
> the last closing date.
> - Now you can see accounts then Partner with subtotals for each account
> allowing you to check you data with trial balance and partner balance for
> instance & accounts are ordered the same way than in the Chart of account
> - period have been added (date only is uncompleted)
> - Reconciliation mark column added
>
> - A new date called 'report date' in the wizard gives you the possibility
> to print open invoices like if you were positionning yourself at a later
> date. ie : you can print 2011 open invoices still considered as open on the
> 31/03/2012. This financial tool, (which is not commonly provided with many
> accounting software) is usually used for the closing process (example :
> provision estimation on receivables).
> -* same as GL report:* The report will now print only account with
> movements OR with a balance not null. No more endless report with accounts
> with no data. (field: display account is hidden)
> - *same as GL report: *opening balance is fully calculated ; no need to
> generate opening entry anymore
> - *same as GL report: *Reports now show cumulative balances
> - *same as GL report: *You can filter, for exemple from the 02/2011 to
> 06/2011 with an opening balance that will includes not only previous years
> data but also data from begining of  fiscal year until the period start of
> your filter ; so you will always match with your trial balance.
> - *same as GL report: *User name added on foot page (+ date, time, page of
> course)
> - *same as GL report: *Better ergonomy on the wizard:
> - And an improved style
>
> We also kept all good functionnalities of current RML reports.
>
>
>
> Please test this module, it will have no impact on existing reports you will simply see 2 extra reports called 'webkit General ledger' and webkit 'Partner ledger'.
>
> So do not hesitate to test and send your feedback to : frederic.clementi AT camptocamp DOT com
>
> Many thanks
>
>
>
> Frédéric CLEMENTI
> Business Solutions
> Camptocamp SA
> Tel : + 41 (0)21 619 1041
>
>
>
>
> http://www.camptocamp.com
>
>
>
>  <frederic.clementi@xxxxxxxxxxxxxx>
>
>
>
>
>
> _______________________________________________
> Mailing list: https://launchpad.net/~openerp-expert-accounting
> Post to     : openerp-expert-accounting@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~openerp-expert-accounting
> More help   : https://help.launchpad.net/ListHelp
>
>