Openbravo Issue Tracking System - Modules
View Issue Details
0019084ModulesPayment Reportpublic2011-11-16 12:162014-04-01 21:48
vmromanos 
vmromanos 
normalmajorN/A
closedfixed 
20Debian 5.0
 
 
0019084: Add balance information when grouping and remove some useless fields
Several improvements need to be added to the payment report:

1. Remove the Subtotal for the grouping criteria because it provides useless information

2. Remove the sum of trans. amount because it may sum amounts from different currencies

3. Remove the last grand total line because it provides useless information

4. Add a balance field when grouping. This balance will show the difference between the pending credit to be used and the pending payments. This information is specially useful when grouping by business partner.

The pending credit to take into account belongs to payments with the following status: Withdrawn not cleared, Payment Received, Payment Cleared, Payment Made and Deposited not Clear.

The pending payments to take into account do NOT have the following status: Withdrawn not cleared, Payment Received, Payment Cleared, Payment Made, Deposited not Clear and Voided
See description
No tags attached.
related to feature request 0019083 closed vmromanos Add balance information when grouping and remove some useless fields 
Issue History
2011-11-16 12:16vmromanosNew Issue
2011-11-16 12:16vmromanosAssigned To => vmromanos
2011-11-16 12:16vmromanosIssue generated from0019083
2011-11-16 12:16vmromanosRelationship addedrelated to 0019083
2011-11-16 12:54vmromanosDescription Updatedbug_revision_view_page.php?rev_id=2909#r2909
2011-11-17 11:20vmromanosStatusnew => scheduled
2011-11-17 11:20vmromanosfix_in_branch => pi
2011-11-17 11:21hgbotCheckin
2011-11-17 11:21hgbotNote Added: 0042920
2011-11-17 11:21hgbotStatusscheduled => resolved
2011-11-17 11:21hgbotResolutionopen => fixed
2011-11-17 11:21hgbotFixed in SCM revision => http://code.openbravo.com/erp/mods/org.openbravo.financial.paymentreport/rev/d73ae5e52bbe7e4674538b88d837119726f8dbae [^]
2014-04-01 21:48plujanNote Added: 0065749
2014-04-01 21:48plujanStatusresolved => closed

Notes
(0042920)
hgbot   
2011-11-17 11:21   
Repository: erp/mods/org.openbravo.financial.paymentreport
Changeset: d73ae5e52bbe7e4674538b88d837119726f8dbae
Author: Víctor Martínez Romanos <victor.martinez <at> openbravo.com>
Date: Thu Nov 17 11:20:57 2011 +0100
URL: http://code.openbravo.com/erp/mods/org.openbravo.financial.paymentreport/rev/d73ae5e52bbe7e4674538b88d837119726f8dbae [^]

Fixed issue 19084:

Several improvements added to the payment report:

1. Remove the Subtotal for the grouping criteria because it provides
useless information

2. Remove the sum of trans. amount because it may sum amounts from
different currencies

3. Remove the last grand total line because it provides useless
information

4. Add a balance field when grouping. This balance will show the
difference between the pending credit to be used and the pending
payments. This information is specially useful when grouping by
business partner.

   The pending credit to take into account belongs to payments with the
following status: Withdrawn not cleared, Payment Received, Payment
Cleared, Payment Made and Deposited not Clear.

   The pending payments to take into account do NOT have the following
status: Withdrawn not cleared, Payment Received, Payment Cleared,
Payment Made, Deposited not Clear and Voided


Apart from that, some minor bugs have been fixed:
- Order by clause orders by invoice payment schedule
- Improved code that prints the asterisks in case of credit payments
- In the PDF report, the group criteria band is now shown only when
the user has selected a grouping criteria

---
M src-db/database/sourcedata/AD_TEXTINTERFACES.xml
M src/org/openbravo/financial/paymentreport/erpCommon/ad_reports/PaymentReport.html
M src/org/openbravo/financial/paymentreport/erpCommon/ad_reports/PaymentReport.java
M src/org/openbravo/financial/paymentreport/erpCommon/ad_reports/PaymentReport.xml
M src/org/openbravo/financial/paymentreport/erpCommon/ad_reports/PaymentReportDao.java
M src/org/openbravo/financial/paymentreport/erpCommon/ad_reports/PaymentReportPDF.jrxml
---
(0065749)
plujan   
2014-04-01 21:48   
Marked as Closed since it was in Resolved for too long