Odoo Server (MOVED TO GITHUB)

Indicators in financial reports

Asked by Bushair

Hi,
Can you please tell me what does the "Expression:" filed indicates in the
Financial Management ‣ Configuration ‣ Custom Reporting ‣ New Reporting Item Formula menu?

What value should i give for this field?

thanks
Bushair

Question information

Language:
English Edit question
Status:
Solved
For:
Odoo Server (MOVED TO GITHUB) Edit question
Assignee:
No assignee Edit question
Solved by:
Vinay Rana (OpenERP)
Solved:
Last query:
Last reply:
Revision history for this message
Vinay Rana (OpenERP) (vra-openerp) said : 		#1

Hello Bushair,

You can see the help with example in "Legend of operators".There is one chart module name l10n_lu.You can install and check with demo data in Custom reporting.

Hope this will help you.
Thanks.

Revision history for this message
Bushair (bushairka) said : 		#2

Hi,
Thanks for the suggestions
i have installed the module l10n_lu,
In custom reporting i could see the following details.

 Code Name
 [Edit] ind new indicator [Delete]
 [Edit] ind new indicator [Delete]
 [Edit] BILAN Bilan [Delete]
 [Edit] Actif Actif [Delete]
 [Edit] BIMMO Valeurs immobilisées [Delete]
 [Edit] BSTOCK Stocks [Delete]
 [Edit] BREAL Réalisable [Delete]
 [Edit] BDISPO Disponible [Delete]
 [Edit] PASSIF Passif [Delete]
 [Edit] BCAP Capitaux propores [Delete]
 [Edit] BRESNET Résultat net [Delete]
 [Edit] CRES Compte des résultats [Delete]
 [Edit] CRESACTIF Résultat Actif [Delete]
 [Edit] CCHAR Total des charges [Delete]
 [Edit] CRESPASSIF Résultat Passif [Delete]
 [Edit] CRESPROD Total des produits [Delete]
 [Edit] CBENEF Résultat (Bénéfice) [Delete]
 [Edit] IIMMO Immobilisations [Delete]
 [Edit] CIMMO Couverture des immobilisations [Delete]
 [Edit] ITRE Trésorerie [Delete]
 [Edit] IFR Indice du fond de roulement [Delete]
 [Edit] RTRE Ratio de trésorerie

i didnt get what you meant by example in "Legend of operators"?

can you please explain me in brief what is this?

Thanks

Revision history for this message
Best Vinay Rana (OpenERP) (vra-openerp) said : 		#3

Hello Bushair,

Open all in form view and see there are some label in this separator. for example balance(['5']) means it will show you the balance of account which has code = '5' , you can add one more argument inside that .
Example: (balance(['6','45'],-1) - credit(['7'])) / report('RPT1')"
Note: The second argument 'fiscal year' and 'period' are optional arguments.If the value is -1,previous fiscalyear or period is considered."
Report Amount: report('REPORT_CODE'): REPORT_CODE is self object code if you want to link some custom reporting data result with another data.
You just see the balance when you will print the Fiscal Statement report, before printing the report you need to done some entry in account chart which is already installed.
Hope this will help you.

Thanks.

Revision history for this message
Bushair (bushairka) said : 		#4

Hi,
Thank you very much for the detailed information

thanks
Bushair