You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ofbiz.apache.org by "Jacopo Cappellato (JIRA)" <ji...@apache.org> on 2007/12/06 20:49:43 UTC
[jira] Created: (OFBIZ-1496) Implement a report to show the
debit/credi totals of all the transactions in a date range by gl account
Implement a report to show the debit/credi totals of all the transactions in a date range by gl account
-------------------------------------------------------------------------------------------------------
Key: OFBIZ-1496
URL: https://issues.apache.org/jira/browse/OFBIZ-1496
Project: OFBiz
Issue Type: Sub-task
Components: accounting
Affects Versions: SVN trunk
Reporter: Jacopo Cappellato
There is already an empty screen definition for the report:
https://localhost:8443/accounting/control/TransactionTotals?organizationPartyId=Company
Add to the report a call to a bsh script (or minilang code) and forms to complete the screen.
There will be a search form with from/thru dates and a submit button.
Once submitted, under the form the screen will show two identical list forms: one containing unposted amounts and one containing posted amounts; each form will have the same fields of the Trial Balance:
https://localhost:8443/accounting/control/TrialBalance?organizationPartyId=Company
I can provide more details, if needed, to get the data but basically we'll have to create a bsh script (and possibly a view-entity definition) to select records (in the selected date range and for the organizationPartyId) from the AcctgTransEntry entity and summarize by glAccountId the credit total and debit total of each row.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (OFBIZ-1496) Reports: Implement a report to show
the debit/credi totals of all the transactions in a date range by gl
account
Posted by "Ratnesh Upadhyay (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OFBIZ-1496?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Ratnesh Upadhyay updated OFBIZ-1496:
------------------------------------
Attachment: DebitCreditTransectionTotal.patch
Resolving all the conflicts of previous patch and here the updated patch as per the requirments.
Submitted By :
Ratnesh Upadhyay
Rishi Solanki
> Reports: Implement a report to show the debit/credi totals of all the transactions in a date range by gl account
> ----------------------------------------------------------------------------------------------------------------
>
> Key: OFBIZ-1496
> URL: https://issues.apache.org/jira/browse/OFBIZ-1496
> Project: OFBiz
> Issue Type: Sub-task
> Components: accounting
> Affects Versions: SVN trunk
> Reporter: Jacopo Cappellato
> Assignee: Anil K Patel
> Attachments: DebitCreditTransectionTotal.patch, DebitCreditTransectionTotal.patch
>
>
> There is already an empty screen definition for the report:
> https://localhost:8443/accounting/control/TransactionTotals?organizationPartyId=Company
> Add to the report a call to a bsh script (or minilang code) and forms to complete the screen.
> There will be a search form with from/thru dates and a submit button.
> Once submitted, under the form the screen will show two identical list forms: one containing unposted amounts and one containing posted amounts; each form will have the same fields of the Trial Balance:
> https://localhost:8443/accounting/control/TrialBalance?organizationPartyId=Company
> I can provide more details, if needed, to get the data but basically we'll have to create a bsh script (and possibly a view-entity definition) to select records (in the selected date range and for the organizationPartyId) from the AcctgTransEntry entity and summarize by glAccountId the credit total and debit total of each row.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Closed: (OFBIZ-1496) Reports: Implement a report to show the
debit/credi totals of all the transactions in a date range by gl account
Posted by "Vikas Mayur (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OFBIZ-1496?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Vikas Mayur closed OFBIZ-1496.
------------------------------
Resolution: Fixed
Rishi Solanki, Sumit Pandit, Ratnesh Upadhyay,
Your patch is in rev 620794.
Thanks !
Vikas
> Reports: Implement a report to show the debit/credi totals of all the transactions in a date range by gl account
> ----------------------------------------------------------------------------------------------------------------
>
> Key: OFBIZ-1496
> URL: https://issues.apache.org/jira/browse/OFBIZ-1496
> Project: OFBiz
> Issue Type: Sub-task
> Components: accounting
> Affects Versions: SVN trunk
> Reporter: Jacopo Cappellato
> Assignee: Vikas Mayur
> Attachments: DebitCreditTransectionTotal.patch, DebitCreditTransectionTotal.patch, DebitCreditTransectionTotal.patch
>
>
> There is already an empty screen definition for the report:
> https://localhost:8443/accounting/control/TransactionTotals?organizationPartyId=Company
> Add to the report a call to a bsh script (or minilang code) and forms to complete the screen.
> There will be a search form with from/thru dates and a submit button.
> Once submitted, under the form the screen will show two identical list forms: one containing unposted amounts and one containing posted amounts; each form will have the same fields of the Trial Balance:
> https://localhost:8443/accounting/control/TrialBalance?organizationPartyId=Company
> I can provide more details, if needed, to get the data but basically we'll have to create a bsh script (and possibly a view-entity definition) to select records (in the selected date range and for the organizationPartyId) from the AcctgTransEntry entity and summarize by glAccountId the credit total and debit total of each row.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (OFBIZ-1496) Reports: Implement a report to show
the debit/credi totals of all the transactions in a date range by gl
account
Posted by "Sumit Pandit (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OFBIZ-1496?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Sumit Pandit updated OFBIZ-1496:
--------------------------------
Attachment: DebitCreditTransectionTotal.patch
We are working on this issue and for the same we have done the following :
1) we have created a view entity named "GlAccOrgAndAcctgTransAndEntry" using GlAccountOrganization, AcctgTransEntry, and AccTrans Entities.
2).we prepared screens and forms to Implement a report to show the debit/credi totals of all the transactions in a date range by gl account.
3).you can see the effects on Accounting > General Ledger > Accounting > Reports > AccountingTransactionTotals.
we created the view entity with the required fields as given in the issue, if any one who have the extensive knowledge of accounting component please suggest us, Are any more fields required for the above view entity ?
Submitted by :
Ratnesh Upadhyay
Rishi Solanki
Sumit Pandit
> Reports: Implement a report to show the debit/credi totals of all the transactions in a date range by gl account
> ----------------------------------------------------------------------------------------------------------------
>
> Key: OFBIZ-1496
> URL: https://issues.apache.org/jira/browse/OFBIZ-1496
> Project: OFBiz
> Issue Type: Sub-task
> Components: accounting
> Affects Versions: SVN trunk
> Reporter: Jacopo Cappellato
> Assignee: Anil K Patel
> Attachments: DebitCreditTransectionTotal.patch
>
>
> There is already an empty screen definition for the report:
> https://localhost:8443/accounting/control/TransactionTotals?organizationPartyId=Company
> Add to the report a call to a bsh script (or minilang code) and forms to complete the screen.
> There will be a search form with from/thru dates and a submit button.
> Once submitted, under the form the screen will show two identical list forms: one containing unposted amounts and one containing posted amounts; each form will have the same fields of the Trial Balance:
> https://localhost:8443/accounting/control/TrialBalance?organizationPartyId=Company
> I can provide more details, if needed, to get the data but basically we'll have to create a bsh script (and possibly a view-entity definition) to select records (in the selected date range and for the organizationPartyId) from the AcctgTransEntry entity and summarize by glAccountId the credit total and debit total of each row.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Reopened: (OFBIZ-1496) Reports: Implement a report to show
the debit/credi totals of all the transactions in a date range by gl
account
Posted by "Vikas Mayur (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OFBIZ-1496?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Vikas Mayur reopened OFBIZ-1496:
--------------------------------
> Reports: Implement a report to show the debit/credi totals of all the transactions in a date range by gl account
> ----------------------------------------------------------------------------------------------------------------
>
> Key: OFBIZ-1496
> URL: https://issues.apache.org/jira/browse/OFBIZ-1496
> Project: OFBiz
> Issue Type: Sub-task
> Components: accounting
> Affects Versions: SVN trunk
> Reporter: Jacopo Cappellato
> Assignee: Vikas Mayur
> Attachments: DebitCreditTransectionTotal.patch, DebitCreditTransectionTotal.patch, DebitCreditTransectionTotal.patch
>
>
> There is already an empty screen definition for the report:
> https://localhost:8443/accounting/control/TransactionTotals?organizationPartyId=Company
> Add to the report a call to a bsh script (or minilang code) and forms to complete the screen.
> There will be a search form with from/thru dates and a submit button.
> Once submitted, under the form the screen will show two identical list forms: one containing unposted amounts and one containing posted amounts; each form will have the same fields of the Trial Balance:
> https://localhost:8443/accounting/control/TrialBalance?organizationPartyId=Company
> I can provide more details, if needed, to get the data but basically we'll have to create a bsh script (and possibly a view-entity definition) to select records (in the selected date range and for the organizationPartyId) from the AcctgTransEntry entity and summarize by glAccountId the credit total and debit total of each row.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (OFBIZ-1496) Reports: Implement a report to show
the debit/credi totals of all the transactions in a date range by gl
account
Posted by "Jacopo Cappellato (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OFBIZ-1496?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12568049#action_12568049 ]
Jacopo Cappellato commented on OFBIZ-1496:
------------------------------------------
After a very quick review it looks very good; I'd say that Anil can commit it when he feels comfortable with it, we can better test later when it is committed in trunk.
There is only one chunk that I'm not sure it is correct:
@@ -540,6 +543,11 @@
<label text="${uiLabelMap.AccountingTransactionTotals}"/>
</container>
</container>
+ <include-form name="FindTransactionTotals" location="component://accounting/widget/ReportFinancialSummaryForms.xml"/>
+ <label style="head3" text="${uiLabelMap.AccountingTransactionTotalsPosted}"/>
+ <include-form name="TransactionTotalPostedlList" location="component://accounting/widget/ReportFinancialSummaryForms.xml"/>
+ <label style="head3" text="${uiLabelMap.AccountingTransactionTotalsUnPosted}"/>
+ <include-form name="TransactionTotalUnpostedlList" location="component://accounting/widget/ReportFinancialSummaryForms.xml"/>
</container>
</decorator-section>
</decorator-screen>
At first sight it seems to me that the <container> elements are not in the right position... could you please check this?
Thanks!
> Reports: Implement a report to show the debit/credi totals of all the transactions in a date range by gl account
> ----------------------------------------------------------------------------------------------------------------
>
> Key: OFBIZ-1496
> URL: https://issues.apache.org/jira/browse/OFBIZ-1496
> Project: OFBiz
> Issue Type: Sub-task
> Components: accounting
> Affects Versions: SVN trunk
> Reporter: Jacopo Cappellato
> Assignee: Anil K Patel
> Attachments: DebitCreditTransectionTotal.patch, DebitCreditTransectionTotal.patch, DebitCreditTransectionTotal.patch
>
>
> There is already an empty screen definition for the report:
> https://localhost:8443/accounting/control/TransactionTotals?organizationPartyId=Company
> Add to the report a call to a bsh script (or minilang code) and forms to complete the screen.
> There will be a search form with from/thru dates and a submit button.
> Once submitted, under the form the screen will show two identical list forms: one containing unposted amounts and one containing posted amounts; each form will have the same fields of the Trial Balance:
> https://localhost:8443/accounting/control/TrialBalance?organizationPartyId=Company
> I can provide more details, if needed, to get the data but basically we'll have to create a bsh script (and possibly a view-entity definition) to select records (in the selected date range and for the organizationPartyId) from the AcctgTransEntry entity and summarize by glAccountId the credit total and debit total of each row.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Assigned: (OFBIZ-1496) Reports: Implement a report to show
the debit/credi totals of all the transactions in a date range by gl
account
Posted by "Vikas Mayur (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OFBIZ-1496?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Vikas Mayur reassigned OFBIZ-1496:
----------------------------------
Assignee: Vikas Mayur (was: Anil K Patel)
> Reports: Implement a report to show the debit/credi totals of all the transactions in a date range by gl account
> ----------------------------------------------------------------------------------------------------------------
>
> Key: OFBIZ-1496
> URL: https://issues.apache.org/jira/browse/OFBIZ-1496
> Project: OFBiz
> Issue Type: Sub-task
> Components: accounting
> Affects Versions: SVN trunk
> Reporter: Jacopo Cappellato
> Assignee: Vikas Mayur
> Attachments: DebitCreditTransectionTotal.patch, DebitCreditTransectionTotal.patch, DebitCreditTransectionTotal.patch
>
>
> There is already an empty screen definition for the report:
> https://localhost:8443/accounting/control/TransactionTotals?organizationPartyId=Company
> Add to the report a call to a bsh script (or minilang code) and forms to complete the screen.
> There will be a search form with from/thru dates and a submit button.
> Once submitted, under the form the screen will show two identical list forms: one containing unposted amounts and one containing posted amounts; each form will have the same fields of the Trial Balance:
> https://localhost:8443/accounting/control/TrialBalance?organizationPartyId=Company
> I can provide more details, if needed, to get the data but basically we'll have to create a bsh script (and possibly a view-entity definition) to select records (in the selected date range and for the organizationPartyId) from the AcctgTransEntry entity and summarize by glAccountId the credit total and debit total of each row.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Closed: (OFBIZ-1496) Reports: Implement a report to show the
debit/credi totals of all the transactions in a date range by gl account
Posted by "Vikas Mayur (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OFBIZ-1496?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Vikas Mayur closed OFBIZ-1496.
------------------------------
Resolution: Fixed
> Reports: Implement a report to show the debit/credi totals of all the transactions in a date range by gl account
> ----------------------------------------------------------------------------------------------------------------
>
> Key: OFBIZ-1496
> URL: https://issues.apache.org/jira/browse/OFBIZ-1496
> Project: OFBiz
> Issue Type: Sub-task
> Components: accounting
> Affects Versions: SVN trunk
> Reporter: Jacopo Cappellato
> Assignee: Vikas Mayur
> Attachments: DebitCreditTransectionTotal.patch, DebitCreditTransectionTotal.patch, DebitCreditTransectionTotal.patch
>
>
> There is already an empty screen definition for the report:
> https://localhost:8443/accounting/control/TransactionTotals?organizationPartyId=Company
> Add to the report a call to a bsh script (or minilang code) and forms to complete the screen.
> There will be a search form with from/thru dates and a submit button.
> Once submitted, under the form the screen will show two identical list forms: one containing unposted amounts and one containing posted amounts; each form will have the same fields of the Trial Balance:
> https://localhost:8443/accounting/control/TrialBalance?organizationPartyId=Company
> I can provide more details, if needed, to get the data but basically we'll have to create a bsh script (and possibly a view-entity definition) to select records (in the selected date range and for the organizationPartyId) from the AcctgTransEntry entity and summarize by glAccountId the credit total and debit total of each row.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (OFBIZ-1496) Reports: Implement a report to show
the debit/credi totals of all the transactions in a date range by gl
account
Posted by "Jacopo Cappellato (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OFBIZ-1496?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jacopo Cappellato updated OFBIZ-1496:
-------------------------------------
Summary: Reports: Implement a report to show the debit/credi totals of all the transactions in a date range by gl account (was: Implement a report to show the debit/credi totals of all the transactions in a date range by gl account)
> Reports: Implement a report to show the debit/credi totals of all the transactions in a date range by gl account
> ----------------------------------------------------------------------------------------------------------------
>
> Key: OFBIZ-1496
> URL: https://issues.apache.org/jira/browse/OFBIZ-1496
> Project: OFBiz
> Issue Type: Sub-task
> Components: accounting
> Affects Versions: SVN trunk
> Reporter: Jacopo Cappellato
> Assignee: Anil K Patel
>
> There is already an empty screen definition for the report:
> https://localhost:8443/accounting/control/TransactionTotals?organizationPartyId=Company
> Add to the report a call to a bsh script (or minilang code) and forms to complete the screen.
> There will be a search form with from/thru dates and a submit button.
> Once submitted, under the form the screen will show two identical list forms: one containing unposted amounts and one containing posted amounts; each form will have the same fields of the Trial Balance:
> https://localhost:8443/accounting/control/TrialBalance?organizationPartyId=Company
> I can provide more details, if needed, to get the data but basically we'll have to create a bsh script (and possibly a view-entity definition) to select records (in the selected date range and for the organizationPartyId) from the AcctgTransEntry entity and summarize by glAccountId the credit total and debit total of each row.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Assigned: (OFBIZ-1496) Implement a report to show the
debit/credi totals of all the transactions in a date range by gl account
Posted by "Anil K Patel (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OFBIZ-1496?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Anil K Patel reassigned OFBIZ-1496:
-----------------------------------
Assignee: Anil K Patel
> Implement a report to show the debit/credi totals of all the transactions in a date range by gl account
> -------------------------------------------------------------------------------------------------------
>
> Key: OFBIZ-1496
> URL: https://issues.apache.org/jira/browse/OFBIZ-1496
> Project: OFBiz
> Issue Type: Sub-task
> Components: accounting
> Affects Versions: SVN trunk
> Reporter: Jacopo Cappellato
> Assignee: Anil K Patel
>
> There is already an empty screen definition for the report:
> https://localhost:8443/accounting/control/TransactionTotals?organizationPartyId=Company
> Add to the report a call to a bsh script (or minilang code) and forms to complete the screen.
> There will be a search form with from/thru dates and a submit button.
> Once submitted, under the form the screen will show two identical list forms: one containing unposted amounts and one containing posted amounts; each form will have the same fields of the Trial Balance:
> https://localhost:8443/accounting/control/TrialBalance?organizationPartyId=Company
> I can provide more details, if needed, to get the data but basically we'll have to create a bsh script (and possibly a view-entity definition) to select records (in the selected date range and for the organizationPartyId) from the AcctgTransEntry entity and summarize by glAccountId the credit total and debit total of each row.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (OFBIZ-1496) Reports: Implement a report to show
the debit/credi totals of all the transactions in a date range by gl
account
Posted by "Vikas Mayur (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OFBIZ-1496?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12568121#action_12568121 ]
Vikas Mayur commented on OFBIZ-1496:
------------------------------------
Jacopo, I have enclosed that snippet into the containter element and also added the style elements to both the Forms and Screen. Rishi has tested the final patch and it work like a charm !
> Reports: Implement a report to show the debit/credi totals of all the transactions in a date range by gl account
> ----------------------------------------------------------------------------------------------------------------
>
> Key: OFBIZ-1496
> URL: https://issues.apache.org/jira/browse/OFBIZ-1496
> Project: OFBiz
> Issue Type: Sub-task
> Components: accounting
> Affects Versions: SVN trunk
> Reporter: Jacopo Cappellato
> Assignee: Vikas Mayur
> Attachments: DebitCreditTransectionTotal.patch, DebitCreditTransectionTotal.patch, DebitCreditTransectionTotal.patch
>
>
> There is already an empty screen definition for the report:
> https://localhost:8443/accounting/control/TransactionTotals?organizationPartyId=Company
> Add to the report a call to a bsh script (or minilang code) and forms to complete the screen.
> There will be a search form with from/thru dates and a submit button.
> Once submitted, under the form the screen will show two identical list forms: one containing unposted amounts and one containing posted amounts; each form will have the same fields of the Trial Balance:
> https://localhost:8443/accounting/control/TrialBalance?organizationPartyId=Company
> I can provide more details, if needed, to get the data but basically we'll have to create a bsh script (and possibly a view-entity definition) to select records (in the selected date range and for the organizationPartyId) from the AcctgTransEntry entity and summarize by glAccountId the credit total and debit total of each row.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (OFBIZ-1496) Reports: Implement a report to show
the debit/credi totals of all the transactions in a date range by gl
account
Posted by "Rishi Solanki (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OFBIZ-1496?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Rishi Solanki updated OFBIZ-1496:
---------------------------------
Attachment: DebitCreditTransectionTotal.patch
Here is the latest patch for the same, with removed NPE (Null Pointer Exception) possibilities in bsh,
and some minor modifications.
Submitted By :
Rishi Solanki
> Reports: Implement a report to show the debit/credi totals of all the transactions in a date range by gl account
> ----------------------------------------------------------------------------------------------------------------
>
> Key: OFBIZ-1496
> URL: https://issues.apache.org/jira/browse/OFBIZ-1496
> Project: OFBiz
> Issue Type: Sub-task
> Components: accounting
> Affects Versions: SVN trunk
> Reporter: Jacopo Cappellato
> Assignee: Anil K Patel
> Attachments: DebitCreditTransectionTotal.patch, DebitCreditTransectionTotal.patch, DebitCreditTransectionTotal.patch
>
>
> There is already an empty screen definition for the report:
> https://localhost:8443/accounting/control/TransactionTotals?organizationPartyId=Company
> Add to the report a call to a bsh script (or minilang code) and forms to complete the screen.
> There will be a search form with from/thru dates and a submit button.
> Once submitted, under the form the screen will show two identical list forms: one containing unposted amounts and one containing posted amounts; each form will have the same fields of the Trial Balance:
> https://localhost:8443/accounting/control/TrialBalance?organizationPartyId=Company
> I can provide more details, if needed, to get the data but basically we'll have to create a bsh script (and possibly a view-entity definition) to select records (in the selected date range and for the organizationPartyId) from the AcctgTransEntry entity and summarize by glAccountId the credit total and debit total of each row.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.