Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0017797
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 09. Financial managementmajoralways2011-06-27 19:162011-08-12 13:41
Reporterjaime_chamorroView Statuspublic 
Assigned ToioritzCia 
PriorityhighResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revisionadd1c452cbb9
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product Version2.50SCM revision 
Review Assigned To
Web browser
ModulesPayment Report
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0017797: Payment Report: wrong subtotal amounts by status

DescriptionThe Payment Report does not add up properly at subtotal level for the same status. In fact, the report does not differentiate between payments in and out for the same status.
After checking the corresponding wiki information (http://wiki.openbravo.com/wiki/Projects/PaymentReport/User_Documentation#Sub_Totals [^]) we have detected that there are the same status for both payments in and out. So, the report should differentiate the document type when there is a subtotal.
Steps To ReproduceTo reply the bug please follows the following steps in the example:
NOTE: the following example is already created in the client TEST and PRODUCTIVE environment version 2.50+MP28.
Create the following data:
• Payment Method to use: Write transfer (same configuration for payment in/out):
 Payment In Allowed: marked
 Execution Type: Manual
 Upon Reconciliation Use: Cleared Payment Account
• Business partner both: customer and vendor.
• Purchase Invoice - total amount: 150 €. Transaction and accounting date: 20-06-2011
• Sales Invoice – total amount: 200 € Transaction and accounting date: 20-06-2011
Once all these data have been registered into the system follow the following steps:
A. Financial Management || Receivables & Payables || Analysis Tools || Payment Report || Payment Report
1. Filter by:
 Organization: the regarding one
 Business partner: the created above.
 Cover to currency: the regarding to the invoices created
 Payment type: receivables and payables
 Ordering criteria: by date
2. Press button “Search” >> see attached the result:
3. Subtotal Awaiting Payment: once is a sales invoice (354,43 €) and the other is a purchase invoice (117,00 €). However, there is not possible to differentiate both. There should be a column to differentiate if it is a payment in or out. The subtotal for this status should be the subtraction but not the sum.
4. The same happens with other status like Subtotal Remittance in this example: as you can check in this example these remittance payments are AP Payments. Therefore, the subtotal should have to take into account the document type.
Proposed SolutionThe subtotal should have to take into account the document type. The subtotal for an specific status should be the subtraction but not the sum base on the document type.

Finally, is the Grand Total amount should differentiate to amounts: payment in and payment out. This way, there final result should have sense.
TagsNo tags attached.
Attached Files? file icon Subtotal Payment Report.bmp [^] (2,219,234 bytes) 2011-06-27 19:16

- Relationships [ Relation Graph ] [ Dependency Graph ]
depends on backport 0017940 closedioritzCia Modules Payment Report: wrong subtotal amounts by status 

-  Notes
(0039000)
hgbot (developer)
2011-07-11 18:55

 Repository: erp/devel/pi
Changeset: add1c452cbb91b8504b5a9844126ca015821a0b7
Author: Ioritz Cia <ioritz.cia <at> openbravo.com>
Date: Fri Jul 08 13:57:53 2011 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/add1c452cbb91b8504b5a9844126ca015821a0b7 [^]

Fixes issue 17797: Payment Report: wrong subtotal amounts by status.

---
M modules/org.openbravo.financial.paymentreport/src/org/openbravo/financial/paymentreport/erpCommon/ad_reports/PaymentReportDao.java
---
(0039587)
hudsonbot (developer)
2011-08-01 14:19

 A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/cf2afed6e8ef [^]

Maturity status: Test
(0040164)
maite (developer)
2011-08-12 13:41

 verified

- Issue History
Date Modified Username Field Change
2011-06-27 19:16 jaime_chamorro New Issue
2011-06-27 19:16 jaime_chamorro Assigned To => mirurita
2011-06-27 19:16 jaime_chamorro File Added: Subtotal Payment Report.bmp
2011-06-30 18:52 mirurita Assigned To mirurita => ioritzCia
2011-07-04 18:22 maite Priority high => immediate
2011-07-04 18:22 maite Severity major => critical
2011-07-08 14:10 ioritzCia Project Modules => Openbravo ERP
2011-07-08 14:12 ioritzCia Modules => Payment Report
2011-07-08 14:12 ioritzCia Category Payment Report => 09. Financial management
2011-07-08 14:13 ioritzCia Status new => scheduled
2011-07-08 14:13 ioritzCia fix_in_branch => pi
2011-07-11 09:58 dalsasua Priority immediate => high
2011-07-11 09:58 dalsasua Severity critical => major
2011-07-11 09:58 dalsasua fix_in_branch pi =>
2011-07-11 18:55 hgbot Checkin
2011-07-11 18:55 hgbot Note Added: 0039000
2011-07-11 18:55 hgbot Status scheduled => resolved
2011-07-11 18:55 hgbot Resolution open => fixed
2011-07-11 18:55 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/add1c452cbb91b8504b5a9844126ca015821a0b7 [^]
2011-08-01 14:19 hudsonbot Checkin
2011-08-01 14:19 hudsonbot Note Added: 0039587
2011-08-12 13:41 maite Note Added: 0040164
2011-08-12 13:41 maite Status resolved => closed

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker