Hervé Proust - www.kazacube.com escribió: > Hello, > > I see improvements on an issue I consider as critical for the future of > OpenERP (quality, fiability and coverage of financial reports and also > good level of performance, i.e. capacity to print a general ledger > without timeout...). We agree mostly with requests from c2c. > > Some additional comments: > - Account balance: initial balance is requested by our certified accountant > on one single report (and not by generating one report per fiscal year) > * Fiscal year report: if the report shows the full year N, the initial > balance should be equal to balance beginning of year N (= opening entries for > balance sheet accounts) > * Period report: if the report is limited to one period N, the initial > balance should be equal to balance end of period N-1 (for all acounts..., but > only for the running fiscal year for income statement accounts. That is where > I guess it becomes tricky... ) >
On the 5.0 you have a module called account_financial_report that gives you extra reports, like a 'full balance' report that shows the balance on a given period and the full year: > - Comparison of yearly results: is it possible or planned to add "comparison" > reports as proposed by the module "Account_balance_compare years" to the > standard reports? (which would be presented in columns and not in two reports > in one) > On 5.0, you have the account_balance_reporting module, that lets create report templates for comparisons of two fiscal years/periods: Selecting the template (official Spanish templates are available for the Spanish localization) and fiscal years / periods: Calculated data: Printed example (everything): Printed example (non-zero): Sample P&L template (taken from Spanish localization) - Template information: Sample P&L template - Template lines: Note: A formula like "760,761" means 'the balance of the account with code 760 plus the balance of the account with code 761", parenthesis might be used to negate the values. A formula like "49300+41900" means "the sum of the line with code 49300 and the line with code 41900". Maybe some of this reports (the ones account_financial_report provides) could be integrated into the standard accounting reports in the future 6.X versions... Best regards. -- Borja López Soilán [email protected] Pexego Sistemas Informáticos S.L. Avenida de Magoi 66 - 27002 Lugo (España) Tel./Fax 982801517 http://www.pexego.es AVISO LEGAL - CLÁUSULA DE PRIVACIDAD Este mensaje se dirige exclusivamente a su destinatario y puede contener información privilegiada o confidencial. Si no es usted el destinatario indicado, queda informado de que la utilización, divulgación y/o copia sin autorización está prohibida en virtud de la legislación vigente. Si ha recibido este mensaje por error, le rogamos que nos lo comunique inmediatamente por esta misma vía y proceda a su destrucción. -- 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 Post to : [email protected] Unsubscribe : https://launchpad.net/~openerp-expert-accounting More help : https://help.launchpad.net/ListHelp
