Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0014396Openbravo ERP09. Financial managementpublic2010-09-01 17:502010-09-22 00:00
Reporterazabaleta 
Assigned Tovmromanos 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.50MP20 
Target Version2.50MP22Fixed in Version2.50MP22 
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
Summary0014396: 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
Steps To Reproduce
Proposed SolutionChange the SQL using the INVOICE DATE instead of DATEPLANNED
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2010-09-01 17:50azabaletaNew Issue
2010-09-01 17:50azabaletaAssigned To => dalsasua
2010-09-01 17:54vmromanosAssigned Todalsasua => vmromanos
2010-09-02 09:50azabaletaNote Added: 0030567
2010-09-02 09:59vmromanosOBNetwork customer => No
2010-09-02 09:59vmromanosPriorityimmediate => urgent
2010-09-02 09:59vmromanosTarget Version => 2.50MP22
2010-09-10 11:02vmromanosStatusnew => scheduled
2010-09-10 11:02vmromanosfix_in_branch => pi
2010-09-10 15:49hgbotCheckin
2010-09-10 15:49hgbotNote Added: 0030943
2010-09-10 15:49hgbotStatusscheduled => resolved
2010-09-10 15:49hgbotResolutionopen => fixed
2010-09-10 15:49hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/21c144a9474751b1c4f83a12c70d59b4e2cc1d2f [^]
2010-09-11 04:15hudsonbotCheckin
2010-09-11 04:15hudsonbotNote Added: 0030956
2010-09-21 10:04psarobeNote Added: 0031255
2010-09-21 10:04psarobeStatusresolved => closed
2010-09-21 10:04psarobeFixed in Version => 2.50MP22
2010-09-22 00:00anonymoussf_bug_id0 => 3072970

Notes
(0030567)
azabaleta   
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   
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   
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   
2010-09-21 10:04   
Code review done