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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0014396
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 09. Financial managementmajoralways2010-09-01 17:502010-09-22 00:00
ReporterazabaletaView Statuspublic 
Assigned Tovmromanos 
PriorityurgentResolutionfixedFixed in Version2.50MP22
StatusclosedFix in branchpiFixed in SCM revision21c144a94747
ProjectionnoneETAnoneTarget Version2.50MP22
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product Version2.50MP20SCM revision 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0014396: The Aging balance report converts the amount with wrong date

DescriptionIn this commit
https://code.openbravo.com/erp/devel/pi/rev/19b60f6a538f [^]
The amount is converted using the DATEPLANNED date of the payment.

This is wrong, as it should be converted with the INVOICEDATE, as its done in the ReportDebtPayment Report
https://code.openbravo.com/erp/devel/pi/rev/ea3c2d1c6e7d [^]

Asier
Proposed SolutionChange the SQL using the INVOICE DATE instead of DATEPLANNED
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]

-  Notes
(0030567)
azabaleta (viewer)
2010-09-02 09:50

 Which date take to do the conversion, depending on the origin of the payment ?

If the payment comes from an invoice ----> Invoice date
If the payment comes from a manual settlement ---> datetrx
If the payment comes from a settlement ---> datetrx
(0030943)
hgbot (developer)
2010-09-10 15:49

 Repository: erp/devel/pi
Changeset: 21c144a9474751b1c4f83a12c70d59b4e2cc1d2f
Author: Víctor Martínez Romanos <victor.martinez <at> openbravo.com>
Date: Fri Sep 10 15:51:15 2010 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/21c144a9474751b1c4f83a12c70d59b4e2cc1d2f [^]

Fixed bug 14396: The Aging balance report converts the amount with wrong date
In case payment comes from an invoice we use the Invoiced Date
In case payment comes from a settlement we use the trx date

---
M src/org/openbravo/erpCommon/ad_reports/ReportAgingBalance_data.xsql
---
(0030956)
hudsonbot (viewer)
2010-09-11 04:15

 A changeset related to this issue has been promoted to main after passing a series of tests and an OBX has been generated:

Changeset: http://code.openbravo.com/erp/devel/main/rev/21c144a94747 [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/bc66d27c7c23 [^]
Tests: http://builds.openbravo.com/view/int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.18368.obx [^]
(0031255)
psarobe (viewer)
2010-09-21 10:04

 Code review done

- Issue History
Date Modified Username Field Change
2010-09-01 17:50 azabaleta New Issue
2010-09-01 17:50 azabaleta Assigned To => dalsasua
2010-09-01 17:54 vmromanos Assigned To dalsasua => vmromanos
2010-09-02 09:50 azabaleta Note Added: 0030567
2010-09-02 09:59 vmromanos OBNetwork customer => No
2010-09-02 09:59 vmromanos Priority immediate => urgent
2010-09-02 09:59 vmromanos Target Version => 2.50MP22
2010-09-10 11:02 vmromanos Status new => scheduled
2010-09-10 11:02 vmromanos fix_in_branch => pi
2010-09-10 15:49 hgbot Checkin
2010-09-10 15:49 hgbot Note Added: 0030943
2010-09-10 15:49 hgbot Status scheduled => resolved
2010-09-10 15:49 hgbot Resolution open => fixed
2010-09-10 15:49 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/21c144a9474751b1c4f83a12c70d59b4e2cc1d2f [^]
2010-09-11 04:15 hudsonbot Checkin
2010-09-11 04:15 hudsonbot Note Added: 0030956
2010-09-21 10:04 psarobe Note Added: 0031255
2010-09-21 10:04 psarobe Status resolved => closed
2010-09-21 10:04 psarobe Fixed in Version => 2.50MP22
2010-09-22 00:00 anonymous sf_bug_id 0 => 3072970

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker