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 <[email protected]> > 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= > [email protected] [mailto: > openerp-expert-accounting-bounces+colin= > [email protected]] *On Behalf Of *Frédéric > Clementi > *Sent:* 14 September 2011 14:38 > > *To:* [email protected] > *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 > > > > > > <[email protected]> > > > > Le 14 septembre 2011 13:49, Frédéric Clementi < > [email protected]> 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 > > > > <[email protected]> > > > > >
_______________________________________________ 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
