openerp-expert-accounting team mailing list archive

[Colin MacMillan <colin@xxxxxxxxxxxxxxxxxxxxxx>]

Hi Frédéric,

I would think that allowing the user to choose the number of levels is a
good option.  I guess this would mean that should the report be printed on a
higher level than is what is ultimately defined, then the ‘skipped’ levels
would then form consolidated totals, in place of their child views/accounts?



I’m not sure what to advise here.  Our feeling is that the way the P&L /
Balance Sheet, Trial Balance is produced at the moment, using COA structure
definition, is not flexible enough which is why we created the account_fstr
module.



I believe a separate more generic template tool, away from the COA structure
for these reports is required.  This is how SAP does it.



Many thanks

Colin







*From:* Frédéric Clementi [mailto:frederic.clementi@xxxxxxxxxxxxxx]
*Sent:* 20 September 2011 09:32
*To:* Colin MacMillan
*Cc:* openerp-expert-accounting@xxxxxxxxxxxxxxxxxxx
*Subject:* Re: [Openerp-expert-accounting] Shiny brand new webkit financial
reports



Thank you Colin I am happy you the 'report date' feature does not seem so
complex (I was a bit worry on this one)



FYI, we are almost done with the trial balance : you will able to compares
balances on any fy/period/date (over 3 years if you like), check out your
openings (dedicated column) and even use the report as BS / PL reports



On this point, I have a question, we want to add simple feature based on
levels (to avoid to overload account view). You would simply select a field
like 'hide account balance' after level (3, 4, 5...)



I see one issue, in some countries, Chart of account is not flexible (like
UK or Swiss one) and some account level 3 need to displayed on a P/L or BS
reports at the same level than an account level 4 or 5 for instance. So, I
am wondering if it will be generic enough.



Frederic

2011/9/19 Colin MacMillan <colin@xxxxxxxxxxxxxxxxxxxxxx>

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>