I run openERP 7.0 on debian. I have conveniently configured the chart of account to suit a guest house the way I want it. I realized though that in the Balance Sheet reports generated by openERP, I get a format that looks something like this:
Name Balance Liability -35837.78 GHÂ¢ Profit (Loss) to report -34283.18 GHÂ¢
Assets 35837.78 GHÂ¢
This is not very desirable as I require a reporting style thus:
Fixed Assets xxx Current Assets xxx Less Current Liabilities xxx Net Current Assets xxx
Capital Account Stated Capital xxx
I have done some research and found that publicus wrote a module that is quite similar to what I need but that's for version 6 or 6.1 (not sure) and I have not found anything yet on openERP v.7. Does any one know if it is possible in v7 to edit the reporting style to suit different needs and how?
Have you had a look in Accounting > Configuration > Financial Reports > Account Reports. Have a look through what is there to see how the existing ones link to the current balance sheet. Then you should be able to create your own custom types to match the format you want, such as a 'Custom Balance Sheet' as the parent, (type 'View'). 'Fixed Assets', 'Current Assets' etc can then be it's children with the type of 'Account Type' and the relevant Account Types selected in the list at the bottom of the screen. This will require you to have setup your own 'Account Types', such as Fixed Assets etc, and linked these to the accounts in your chart of account.
You can then print your customised report from Accounting > Reporting > Financial Report, by selecting the 'Custom Balance Sheet' from the list next to 'Account Reports'.
It may take some playing to get it right, but hopefully this helps :)
Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!
About This Community
|Asked: 4/16/13, 11:58 AM|
|Seen: 5815 times|
|Last updated: 7/18/15, 2:16 PM|