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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0033278
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Modules] Payment Aging Balance Reportmajoralways2016-06-15 17:532017-09-27 17:21
ReportermaiteView Statuspublic 
Assigned Tomarkmm82 
PriorityimmediateResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision86ac2b9f1836
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
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
Regression introduced in release
Summary

0033278: 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
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to defect 0033262 closedmarkmm82 To show "Supplier reference" for credit payments (same as invoices) in case Organization is configured for that 
related to feature request 0024813 closeddmiguelez It would be great to have the Supplier Reference to be displayed in the AP Aging Report 
caused by design defect 0032406 closedvmromanos Aging Reports causing tomcat to crash 

-  Notes
(0087807)
markmm82 (developer)
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 (developer)
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 (developer)
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 (manager)
2016-06-24 14:25

 Code review + Testing OK
(0088041)
hgbot (developer)
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 (developer)
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 (developer)
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 (developer)
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 (developer)
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 (developer)
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
---

- Issue History
Date Modified Username Field Change
2016-06-15 17:53 maite New Issue
2016-06-15 17:53 maite Assigned To => Triage Finance
2016-06-15 17:53 maite Resolution time => 1466373600
2016-06-15 17:53 maite Relationship added related to 0033262
2016-06-15 18:05 maite Resolution time 1466373600 => 1467669600
2016-06-15 18:09 aferraz Relationship added caused by 0032406
2016-06-15 18:10 aferraz Regression date => 2016-05-04
2016-06-15 18:10 aferraz Regression introduced by commit => https://code.openbravo.com/erp/mods/org.openbravo.agingbalance/rev/f23883edecf4 [^]
2016-06-15 18:10 aferraz Regression level => Pre packaging ( pi )
2016-06-15 18:11 aferraz Assigned To Triage Finance => markmm82
2016-06-15 18:52 markmm82 Status new => scheduled
2016-06-15 18:58 markmm82 Status scheduled => acknowledged
2016-06-16 19:19 aferraz Status acknowledged => scheduled
2016-06-17 15:37 markmm82 Note Added: 0087407
2016-06-21 18:12 markmm82 Note Deleted: 0087407
2016-06-22 16:56 markmm82 Note Added: 0087807
2016-06-24 14:16 hgbot Checkin
2016-06-24 14:16 hgbot Note Added: 0087901
2016-06-24 14:16 hgbot Status scheduled => resolved
2016-06-24 14:16 hgbot Resolution open => fixed
2016-06-24 14:16 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/mods/org.openbravo.agingbalance/rev/2679f3c3c30b1ed847136f964e28df8239848878 [^]
2016-06-24 14:16 hgbot Checkin
2016-06-24 14:16 hgbot Note Added: 0087902
2016-06-24 14:25 aferraz Review Assigned To => aferraz
2016-06-24 14:25 aferraz Note Added: 0087903
2016-06-24 14:25 aferraz Status resolved => closed
2016-06-28 12:14 hgbot Checkin
2016-06-28 12:14 hgbot Note Added: 0088041
2016-06-28 12:14 hgbot Status closed => resolved
2016-06-28 12:14 hgbot Fixed in SCM revision http://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:14 hgbot Checkin
2016-06-28 12:14 hgbot Note Added: 0088042
2016-06-28 18:26 hgbot Checkin
2016-06-28 18:26 hgbot Note Added: 0088061
2016-06-28 18:26 hgbot Checkin
2016-06-28 18:26 hgbot Note Added: 0088062
2016-06-28 18:48 hgbot Checkin
2016-06-28 18:48 hgbot Note Added: 0088063
2016-06-28 18:48 hgbot Checkin
2016-06-28 18:48 hgbot Note Added: 0088064
2016-06-28 18:52 aferraz Status resolved => closed
2017-09-27 17:21 aferraz Relationship added related to 0024813

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker