openerp-expert-accounting team mailing list archive

[Frédéric Clementi <frederic.clementi@xxxxxxxxxxxxxx>]

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