[jira] Created: (OFBIZ-2818) Accounting reports should display consolidated data from divisions
Locked
[jira] Created: (OFBIZ-2818) Accounting reports should display consolidated data from divisions
 
|
Accounting reports should display consolidated data from divisions
------------------------------------------------------------------ Key: OFBIZ-2818 URL: https://issues.apache.org/jira/browse/OFBIZ-2818 Project: OFBiz Issue Type: Improvement Reporter: Sumit Pandit Financial data rollup: All financial reports in Ofbiz should respect the internal organization hierarchy. All children financial data should be rolled up to the parent internal organization as defined in the PartyRelationship entity (Rollup_Group). http://www.nabble.com/Multi-Organization-Rollup-td24456225.html#a24597919 Some implementation notes/suggestions, for each of the data preparation scripts for accounting reports: a) given the parent organization id (organizationPartyId), retrieve the list of divisions under it b) get accounting data for the report for the parent organization id (as it is currently implemented) and put them in a map c) if there are divisions iterate thru them and for each division perform step b and then put the data in the same map (if the key is alrready there then the values are summed up) d) display data from map; if there are divisions display also, at the top of the screen a message saying "Consolidated data for group ABC from divisions A, B, C, D..." -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online. |
[jira] Updated: (OFBIZ-2818) Accounting reports should display consolidated data from divisions
|
|
[ https://issues.apache.org/jira/browse/OFBIZ-2818?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Awdesh Singh Parihar updated OFBIZ-2818: ---------------------------------------- Attachment: OFBiz-2818.patch This patch covers mentioned improvement for two reports. 1) Trial Balance (https://localhost:8443/accounting/control/TrialBalance?organizationPartyId=Company) 2) Gl Account Trial Balance (https://localhost:8443/accounting/control/GlAccountTrialBalance?organizationPartyId=Company) Thanks to Sumit and Rishi -- Awdesh Parihar > Accounting reports should display consolidated data from divisions > ------------------------------------------------------------------ > > Key: OFBIZ-2818 > URL: https://issues.apache.org/jira/browse/OFBIZ-2818 > Project: OFBiz > Issue Type: Improvement > Reporter: Sumit Pandit > Attachments: OFBiz-2818.patch > > > Financial data rollup: All financial reports in Ofbiz should respect the internal organization hierarchy. All children financial data should be rolled up to the parent internal organization as defined in the PartyRelationship entity (Rollup_Group). > http://www.nabble.com/Multi-Organization-Rollup-td24456225.html#a24597919 > Some implementation notes/suggestions, for each of the data preparation scripts for accounting reports: > a) given the parent organization id (organizationPartyId), retrieve the list of divisions under it > b) get accounting data for the report for the parent organization id (as it is currently implemented) and put them in a map > c) if there are divisions iterate thru them and for each division perform step b and then put the data in the same map (if the key is alrready there then the values are summed up) > d) display data from map; if there are divisions display also, at the top of the screen a message saying "Consolidated data for group ABC from divisions A, B, C, D..." -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online. |
[jira] Assigned: (OFBIZ-2818) Accounting reports should display consolidated data from divisions
|
|
In reply to this post by Nicolas Malin (Jira)
[ https://issues.apache.org/jira/browse/OFBIZ-2818?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Anil K Patel reassigned OFBIZ-2818: ----------------------------------- Assignee: Anil K Patel > Accounting reports should display consolidated data from divisions > ------------------------------------------------------------------ > > Key: OFBIZ-2818 > URL: https://issues.apache.org/jira/browse/OFBIZ-2818 > Project: OFBiz > Issue Type: Improvement > Reporter: Sumit Pandit > Assignee: Anil K Patel > Attachments: OFBiz-2818.patch > > > Financial data rollup: All financial reports in Ofbiz should respect the internal organization hierarchy. All children financial data should be rolled up to the parent internal organization as defined in the PartyRelationship entity (Rollup_Group). > http://www.nabble.com/Multi-Organization-Rollup-td24456225.html#a24597919 > Some implementation notes/suggestions, for each of the data preparation scripts for accounting reports: > a) given the parent organization id (organizationPartyId), retrieve the list of divisions under it > b) get accounting data for the report for the parent organization id (as it is currently implemented) and put them in a map > c) if there are divisions iterate thru them and for each division perform step b and then put the data in the same map (if the key is alrready there then the values are summed up) > d) display data from map; if there are divisions display also, at the top of the screen a message saying "Consolidated data for group ABC from divisions A, B, C, D..." -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online. |
[jira] Closed: (OFBIZ-2818) Accounting reports should display consolidated data from divisions
|
|
In reply to this post by Nicolas Malin (Jira)
[ https://issues.apache.org/jira/browse/OFBIZ-2818?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Anil K Patel closed OFBIZ-2818. ------------------------------- Resolution: Fixed Patch in r802495. Thanks Rishi, Sumit and Awdesh for contribution. Also Thanks for Vince and Eva for help in designing tools. > Accounting reports should display consolidated data from divisions > ------------------------------------------------------------------ > > Key: OFBIZ-2818 > URL: https://issues.apache.org/jira/browse/OFBIZ-2818 > Project: OFBiz > Issue Type: Improvement > Reporter: Sumit Pandit > Assignee: Anil K Patel > Attachments: OFBiz-2818.patch > > > Financial data rollup: All financial reports in Ofbiz should respect the internal organization hierarchy. All children financial data should be rolled up to the parent internal organization as defined in the PartyRelationship entity (Rollup_Group). > http://www.nabble.com/Multi-Organization-Rollup-td24456225.html#a24597919 > Some implementation notes/suggestions, for each of the data preparation scripts for accounting reports: > a) given the parent organization id (organizationPartyId), retrieve the list of divisions under it > b) get accounting data for the report for the parent organization id (as it is currently implemented) and put them in a map > c) if there are divisions iterate thru them and for each division perform step b and then put the data in the same map (if the key is alrready there then the values are summed up) > d) display data from map; if there are divisions display also, at the top of the screen a message saying "Consolidated data for group ABC from divisions A, B, C, D..." -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online. |
[jira] Reopened: (OFBIZ-2818) Accounting reports should display consolidated data from divisions
|
|
In reply to this post by Nicolas Malin (Jira)
[ https://issues.apache.org/jira/browse/OFBIZ-2818?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Anil K Patel reopened OFBIZ-2818: --------------------------------- Implement in remaining reports in GL. > Accounting reports should display consolidated data from divisions > ------------------------------------------------------------------ > > Key: OFBIZ-2818 > URL: https://issues.apache.org/jira/browse/OFBIZ-2818 > Project: OFBiz > Issue Type: Improvement > Reporter: Sumit Pandit > Assignee: Anil K Patel > Attachments: OFBiz-2818.patch > > > Financial data rollup: All financial reports in Ofbiz should respect the internal organization hierarchy. All children financial data should be rolled up to the parent internal organization as defined in the PartyRelationship entity (Rollup_Group). > http://www.nabble.com/Multi-Organization-Rollup-td24456225.html#a24597919 > Some implementation notes/suggestions, for each of the data preparation scripts for accounting reports: > a) given the parent organization id (organizationPartyId), retrieve the list of divisions under it > b) get accounting data for the report for the parent organization id (as it is currently implemented) and put them in a map > c) if there are divisions iterate thru them and for each division perform step b and then put the data in the same map (if the key is alrready there then the values are summed up) > d) display data from map; if there are divisions display also, at the top of the screen a message saying "Consolidated data for group ABC from divisions A, B, C, D..." -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online. |
[jira] Updated: (OFBIZ-2818) Accounting reports should display consolidated data from divisions
|
|
In reply to this post by Nicolas Malin (Jira)
[ https://issues.apache.org/jira/browse/OFBIZ-2818?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Awdesh Singh Parihar updated OFBIZ-2818: ---------------------------------------- Attachment: OFBiz-2818.patch Done improvement for remaining report (https://localhost:8443/accounting/control/TrialBalance?organizationPartyId=Company) : - 1) Income Statement 2) Balance Sheet 3) Comparative Balance Sheet 4) Transaction Totals 5) Monthly Trial Balance. Thanks to Sumit -- Awdesh Parihar > Accounting reports should display consolidated data from divisions > ------------------------------------------------------------------ > > Key: OFBIZ-2818 > URL: https://issues.apache.org/jira/browse/OFBIZ-2818 > Project: OFBiz > Issue Type: Improvement > Reporter: Sumit Pandit > Assignee: Anil K Patel > Attachments: OFBiz-2818.patch, OFBiz-2818.patch > > > Financial data rollup: All financial reports in Ofbiz should respect the internal organization hierarchy. All children financial data should be rolled up to the parent internal organization as defined in the PartyRelationship entity (Rollup_Group). > http://www.nabble.com/Multi-Organization-Rollup-td24456225.html#a24597919 > Some implementation notes/suggestions, for each of the data preparation scripts for accounting reports: > a) given the parent organization id (organizationPartyId), retrieve the list of divisions under it > b) get accounting data for the report for the parent organization id (as it is currently implemented) and put them in a map > c) if there are divisions iterate thru them and for each division perform step b and then put the data in the same map (if the key is alrready there then the values are summed up) > d) display data from map; if there are divisions display also, at the top of the screen a message saying "Consolidated data for group ABC from divisions A, B, C, D..." -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online. |
[jira] Commented: (OFBIZ-2818) Accounting reports should display consolidated data from divisions
|
|
In reply to this post by Nicolas Malin (Jira)
[ https://issues.apache.org/jira/browse/OFBIZ-2818?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12741825#action_12741825 ] Sumit Pandit commented on OFBIZ-2818: ------------------------------------- Hello Eva, As per commit at r802495, work is done for two reports - 1) Trial Balance (https://localhost:8443/accounting/control/TrialBalance?organizationPartyId=Company) 2) Gl Account Trial Balance (https://localhost:8443/accounting/control/GlAccountTrialBalance?organizationPartyId=Company) And patch is uploaded for remaining reports - 1) Income Statement 2) Balance Sheet 3) Comparative Balance Sheet 4) Transaction Totals 5) Monthly Trial Balance. Please test the committed code at r802495 and attached patch, to confirm that it is generating report as defined in requirement. Looking for feedback. Thanks Awdesh for his work. > Accounting reports should display consolidated data from divisions > ------------------------------------------------------------------ > > Key: OFBIZ-2818 > URL: https://issues.apache.org/jira/browse/OFBIZ-2818 > Project: OFBiz > Issue Type: Improvement > Reporter: Sumit Pandit > Assignee: Anil K Patel > Attachments: OFBiz-2818.patch, OFBiz-2818.patch > > > Financial data rollup: All financial reports in Ofbiz should respect the internal organization hierarchy. All children financial data should be rolled up to the parent internal organization as defined in the PartyRelationship entity (Rollup_Group). > http://www.nabble.com/Multi-Organization-Rollup-td24456225.html#a24597919 > Some implementation notes/suggestions, for each of the data preparation scripts for accounting reports: > a) given the parent organization id (organizationPartyId), retrieve the list of divisions under it > b) get accounting data for the report for the parent organization id (as it is currently implemented) and put them in a map > c) if there are divisions iterate thru them and for each division perform step b and then put the data in the same map (if the key is alrready there then the values are summed up) > d) display data from map; if there are divisions display also, at the top of the screen a message saying "Consolidated data for group ABC from divisions A, B, C, D..." -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online. |
[jira] Closed: (OFBIZ-2818) Accounting reports should display consolidated data from divisions
|
|
In reply to this post by Nicolas Malin (Jira)
[ https://issues.apache.org/jira/browse/OFBIZ-2818?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Anil K Patel closed OFBIZ-2818. ------------------------------- Resolution: Fixed Patch applied to r808047. > Accounting reports should display consolidated data from divisions > ------------------------------------------------------------------ > > Key: OFBIZ-2818 > URL: https://issues.apache.org/jira/browse/OFBIZ-2818 > Project: OFBiz > Issue Type: Improvement > Reporter: Sumit Pandit > Assignee: Anil K Patel > Attachments: OFBiz-2818.patch, OFBiz-2818.patch > > > Financial data rollup: All financial reports in Ofbiz should respect the internal organization hierarchy. All children financial data should be rolled up to the parent internal organization as defined in the PartyRelationship entity (Rollup_Group). > http://www.nabble.com/Multi-Organization-Rollup-td24456225.html#a24597919 > Some implementation notes/suggestions, for each of the data preparation scripts for accounting reports: > a) given the parent organization id (organizationPartyId), retrieve the list of divisions under it > b) get accounting data for the report for the parent organization id (as it is currently implemented) and put them in a map > c) if there are divisions iterate thru them and for each division perform step b and then put the data in the same map (if the key is alrready there then the values are summed up) > d) display data from map; if there are divisions display also, at the top of the screen a message saying "Consolidated data for group ABC from divisions A, B, C, D..." -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online. |
«
Return to OFBiz - Dev
|
1 view|%1 views
| Free forum by Nabble | Edit this page |