Openbravo Issue Tracking System - Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0033278ModulesPayment Aging Balance Reportpublic2016-06-15 17:532017-09-27 17:21
Reportermaite 
Assigned Tomarkmm82 
PriorityimmediateSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Regression date2016-05-04
Regression introduced by commithttps://code.openbravo.com/erp/mods/org.openbravo.agingbalance/rev/f23883edecf4 [^]
Regression levelPre packaging ( pi )
Review Assigned Toaferraz
Support ticket
OBNetwork customer
Regression introduced in release
Summary0033278: To show "Supplier reference" functionality (if configured) has been lost during report's refactor
DescriptionIn case Organization is configured as "Purchase Invoice's Reference for Payment Description"= Suplier reference, then supplier reference should be shown instead of documentno in purchase invoice and credit payments
Steps To Reproduce0. Install last available version in Test status
1. Access "España region sur" organization, go to Information tab and set "Purchase Invoice's Reference for Payment Description" as Supplier Reference
2. Register Purchase Invoice for "España region sur". Add any line and process. Set Supplier reference as "invoice 1"
3. Register Payment Out document for "España region sur". Set any Credit Amount and process. Set Supplier reference as "payment 1"
4. Run Payables Aging Schedule report for "España region sur" and "Show details" checked
5. Realize that supplier reference is not shown
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 0033262 closed markmm82 To show "Supplier reference" for credit payments (same as invoices) in case Organization is configured for that 
related to feature request 0024813 closed dmiguelez It would be great to have the Supplier Reference to be displayed in the AP Aging Report 
caused by design defect 0032406 closed vmromanos Aging Reports causing tomcat to crash 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2016-06-15 17:53maiteNew Issue
2016-06-15 17:53maiteAssigned To => Triage Finance
2016-06-15 17:53maiteResolution time => 1466373600
2016-06-15 17:53maiteRelationship addedrelated to 0033262
2016-06-15 18:05maiteResolution time1466373600 => 1467669600
2016-06-15 18:09aferrazRelationship addedcaused by 0032406
2016-06-15 18:10aferrazRegression date => 2016-05-04
2016-06-15 18:10aferrazRegression introduced by commit => https://code.openbravo.com/erp/mods/org.openbravo.agingbalance/rev/f23883edecf4 [^]
2016-06-15 18:10aferrazRegression level => Pre packaging ( pi )
2016-06-15 18:11aferrazAssigned ToTriage Finance => markmm82
2016-06-15 18:52markmm82Statusnew => scheduled
2016-06-15 18:58markmm82Statusscheduled => acknowledged
2016-06-16 19:19aferrazStatusacknowledged => scheduled
2016-06-17 15:37markmm82Note Added: 0087407
2016-06-21 18:12markmm82Note Deleted: 0087407
2016-06-22 16:56markmm82Note Added: 0087807
2016-06-24 14:16hgbotCheckin
2016-06-24 14:16hgbotNote Added: 0087901
2016-06-24 14:16hgbotStatusscheduled => resolved
2016-06-24 14:16hgbotResolutionopen => fixed
2016-06-24 14:16hgbotFixed in SCM revision => http://code.openbravo.com/erp/mods/org.openbravo.agingbalance/rev/2679f3c3c30b1ed847136f964e28df8239848878 [^]
2016-06-24 14:16hgbotCheckin
2016-06-24 14:16hgbotNote Added: 0087902
2016-06-24 14:25aferrazReview Assigned To => aferraz
2016-06-24 14:25aferrazNote Added: 0087903
2016-06-24 14:25aferrazStatusresolved => closed
2016-06-28 12:14hgbotCheckin
2016-06-28 12:14hgbotNote Added: 0088041
2016-06-28 12:14hgbotStatusclosed => resolved
2016-06-28 12:14hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/mods/org.openbravo.agingbalance/rev/2679f3c3c30b1ed847136f964e28df8239848878 [^] => http://code.openbravo.com/erp/mods/org.openbravo.agingbalance/rev/86ac2b9f183606e62023d1a50459fa122e4d66ca [^]
2016-06-28 12:14hgbotCheckin
2016-06-28 12:14hgbotNote Added: 0088042
2016-06-28 18:26hgbotCheckin
2016-06-28 18:26hgbotNote Added: 0088061
2016-06-28 18:26hgbotCheckin
2016-06-28 18:26hgbotNote Added: 0088062
2016-06-28 18:48hgbotCheckin
2016-06-28 18:48hgbotNote Added: 0088063
2016-06-28 18:48hgbotCheckin
2016-06-28 18:48hgbotNote Added: 0088064
2016-06-28 18:52aferrazStatusresolved => closed
2017-09-27 17:21aferrazRelationship addedrelated to 0024813

Notes
(0087807)
markmm82   
2016-06-22 16:56   
Test Plan
0. Install last available version in Test status
1. Access "España region sur" organization, go to Information tab and set "Purchase Invoice's Reference for Payment Description" as Supplier Reference
2. Register Purchase Invoice for "España region sur". Add any line and process. Set Supplier reference as "invoice 1"
3. Register Payment Out document for "España region sur". Set any Credit Amount and process. Set Supplier reference as "payment 1"
4. Run Payables Aging Schedule report for "España region sur" and "Show details" checked
5. Realize that supplier reference is shown: "invoice 1"
(0087901)
hgbot   
2016-06-24 14:16   
Repository: erp/mods/org.openbravo.agingbalance
Changeset: 2679f3c3c30b1ed847136f964e28df8239848878
Author: Mark <markmm82 <at> gmail.com>
Date: Tue Jun 21 12:01:03 2016 -0400
URL: http://code.openbravo.com/erp/mods/org.openbravo.agingbalance/rev/2679f3c3c30b1ed847136f964e28df8239848878 [^]

Fixes issue 33278: Fixed "Supplier reference" functionality in Aging Balance

In case Organization is configured as "Purchase Invoice's Reference for Payment Description"= Suplier reference, then supplier reference is shown instead of documentno in purchase invoice

---
M src/org/openbravo/agingbalance/ad_reports/AgingDao_data.xsql
A src-db/database/model/functions/AGING_GETDOCNO.xml
---
(0087902)
hgbot   
2016-06-24 14:16   
Repository: erp/mods/org.openbravo.agingbalance
Changeset: efa201a047f992f473eeea6b46b70bcd219c9848
Author: Alvaro Ferraz <alvaro.ferraz <at> openbravo.com>
Date: Wed Jun 22 14:10:45 2016 +0200
URL: http://code.openbravo.com/erp/mods/org.openbravo.agingbalance/rev/efa201a047f992f473eeea6b46b70bcd219c9848 [^]

Related to issue 33278: Update module version

---
M src-db/database/sourcedata/AD_MODULE.xml
---
(0087903)
aferraz   
2016-06-24 14:25   
Code review + Testing OK
(0088041)
hgbot   
2016-06-28 12:14   
Repository: erp/mods/org.openbravo.agingbalance
Changeset: 86ac2b9f183606e62023d1a50459fa122e4d66ca
Author: Mark <markmm82 <at> gmail.com>
Date: Tue Jun 21 12:01:03 2016 -0400
URL: http://code.openbravo.com/erp/mods/org.openbravo.agingbalance/rev/86ac2b9f183606e62023d1a50459fa122e4d66ca [^]

Fixes issue 33278: Fixed "Supplier reference" functionality in Aging Balance

In case Organization is configured as "Purchase Invoice's Reference for Payment Description"= Suplier reference, then supplier reference is shown instead of documentno in purchase invoice

---
M src/org/openbravo/agingbalance/ad_reports/AgingDao_data.xsql
A src-db/database/model/functions/AGING_GETDOCNO.xml
---
(0088042)
hgbot   
2016-06-28 12:14   
Repository: erp/mods/org.openbravo.agingbalance
Changeset: ec57f82612c9ae51f5ef5838f04f9621e497d285
Author: Alvaro Ferraz <alvaro.ferraz <at> openbravo.com>
Date: Tue Jun 28 12:03:29 2016 +0200
URL: http://code.openbravo.com/erp/mods/org.openbravo.agingbalance/rev/ec57f82612c9ae51f5ef5838f04f9621e497d285 [^]

Related to issue 33278: Update module version

---
M src-db/database/sourcedata/AD_MODULE.xml
---
(0088061)
hgbot   
2016-06-28 18:26   
Repository: erp/mods/org.openbravo.agingbalance
Changeset: e48ec056c4a9bf2efd239997e25d9f3fc97698e7
Author: Alvaro Ferraz <alvaro.ferraz <at> openbravo.com>
Date: Tue Jun 28 17:51:57 2016 +0200
URL: http://code.openbravo.com/erp/mods/org.openbravo.agingbalance/rev/e48ec056c4a9bf2efd239997e25d9f3fc97698e7 [^]

Related to issue 33278: Code review improvements

Set p_poreference and p_documentno parameters as NVARCHAR instead of VARCHAR to avoid error in Oracle.

---
M src-db/database/model/functions/AGING_GETDOCNO.xml
---
(0088062)
hgbot   
2016-06-28 18:26   
Repository: erp/mods/org.openbravo.agingbalance
Changeset: 8c0f6efc858900a461b55b86809b3625dc1718ef
Author: Alvaro Ferraz <alvaro.ferraz <at> openbravo.com>
Date: Tue Jun 28 17:52:59 2016 +0200
URL: http://code.openbravo.com/erp/mods/org.openbravo.agingbalance/rev/8c0f6efc858900a461b55b86809b3625dc1718ef [^]

Related to issue 33278: Update module version

---
M src-db/database/sourcedata/AD_MODULE.xml
---
(0088063)
hgbot   
2016-06-28 18:48   
Repository: erp/mods/org.openbravo.agingbalance
Changeset: 1bf6784bcdbfaaf091d83ce2a828a8933bb18877
Author: Alvaro Ferraz <alvaro.ferraz <at> openbravo.com>
Date: Tue Jun 28 17:51:57 2016 +0200
URL: http://code.openbravo.com/erp/mods/org.openbravo.agingbalance/rev/1bf6784bcdbfaaf091d83ce2a828a8933bb18877 [^]

Related to issue 33278: Code review improvements

Set p_poreference and p_documentno parameters as NVARCHAR instead of VARCHAR to avoid error in Oracle.

---
M src-db/database/model/functions/AGING_GETDOCNO.xml
---
(0088064)
hgbot   
2016-06-28 18:48   
Repository: erp/mods/org.openbravo.agingbalance
Changeset: 3d31e95e30d2ab5efedbcf416fc1e6d6c6fcf280
Author: Alvaro Ferraz <alvaro.ferraz <at> openbravo.com>
Date: Tue Jun 28 18:32:56 2016 +0200
URL: http://code.openbravo.com/erp/mods/org.openbravo.agingbalance/rev/3d31e95e30d2ab5efedbcf416fc1e6d6c6fcf280 [^]

Related to issue 33278: Update module version

---
M src-db/database/sourcedata/AD_MODULE.xml
---