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.
