[
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.
