[jira] [Comment Edited] (OFBIZ-6646) Option either to show parent GL account in accounting reports (BS & IS) or to customize the report

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

[jira] [Comment Edited] (OFBIZ-6646) Option either to show parent GL account in accounting reports (BS & IS) or to customize the report

Nicolas Malin (Jira)

    [ https://issues.apache.org/jira/browse/OFBIZ-6646?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14901830#comment-14901830 ]

Nu Huynh edited comment on OFBIZ-6646 at 9/22/15 2:58 AM:
----------------------------------------------------------

@ Jacques: Hi. I'm not a developer. Is this the place for end users to report our issues and opinions? I ended up here thanks to Hans (from Antweb). Please let me know if I should demonstrate my issue further.

@ Rong: I know there is no way at the moment and end users can create their own reports with Excel but if reporting is a very repetitive and tedious job, it will be very helpful to show all parent GL accounts and their balances (the second option that I suggest if customization is more complicated). For example, one of our accountants handle 20 departments and she has to prepare at least 2 monthly reports (BS & IS) for each of them within the first 5 days of a month. That is a total of 40 reports to do in 5 days of every month.


was (Author: nuhuynh):
@ Jacques: Hi. I'm not a developer. Is this the place for end users to report our issues and opinions? I ended up here thanks to Hans (from Antweb)

@ Rong: I know there is no way at the moment and end users can create their own reports with Excel but if reporting is a very repetitive and tedious job, it will be very helpful to show all parent GL accounts and their balances (the second option that I suggest if customization is more complicated). For example, one of our accountants handle 20 departments and she has to prepare at least 2 monthly reports (BS & IS) for each of them within the first 5 days of a month. That is a total of 40 reports to do in 5 days of every month.

> Option either to show parent GL account in accounting reports (BS & IS) or to customize the report
> --------------------------------------------------------------------------------------------------
>
>                 Key: OFBIZ-6646
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-6646
>             Project: OFBiz
>          Issue Type: Improvement
>          Components: accounting
>            Reporter: Nu Huynh
>
> Currently, balance sheet and income statement only show lowest level / child GL accounts having at least one transaction, hence a balance, in a period. However, as an end user, I find it is necessary to show all Parent GL accounts which balance is the sum of all its child accounts.
> For us, they are more than just to show up in the "Navigate accounts" section. They are main sections of our own reports. The standard format of reports in Ofbiz is too condensed and the users do not have the option to customize this.
> I have tried to customize the Income Statement by creating some new GL account classes e.g "Non Operation Expenses" via Entity Data Maintenance but they don't show up in Income Statement. So I guess it is not that straightforward to customize reports.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)