Openbravo Issue Tracking System - Modules |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0028302 | Modules | Payment Aging Balance Report | public | 2014-11-27 12:56 | 2015-03-13 11:22 |
|
| Reporter | maite | |
| Assigned To | fsoto82 | |
| Priority | immediate | Severity | major | Reproducibility | always |
| Status | closed | Resolution | fixed | |
| Platform | | OS | 5 | OS Version | |
| Product Version | | |
| Target Version | | Fixed in Version | | |
| Merge Request Status | |
| Regression date | |
| Regression introduced by commit | |
| Regression level | |
| Review Assigned To | aferraz |
| Support ticket | |
| OBNetwork customer | |
| Regression introduced in release | |
|
| Summary | 0028302: Include preference to configure if VOID invoices should be included in report or not |
| Description | Invoices in VOID status are currently excluded from Aging report (due to related issue 21336). This is wrong as VOId invoice which has payment plan info should also appear in the report (in negative) to be able to obtain real data situation.
|
| Steps To Reproduce | 1. Create sales invoice for any bp and any amount
2. Create payment associated to that invoice, paying total invoice
3. Void previous sales invoice. Reversed Sales Invoice will be automatically created. Both Invoices will have "Voided" status
4. Run Aging report and realize that Reversed Sales Invoice does not appear |
| Proposed Solution | In order to maintain current behaviour, solution will be (decides with Eduardo):
- To include a checkbox in the report to decide if "Voided invoices needs to be included"
- This checkbox will be checked by default (so voided invoices will be included) and hidden
- Include a preference in case user decides to show that checkbox
- Depending on checkbox's value, "createObCriteria" method of AgingDao.java needs to include following clause or not : hsqlScript.append(" and i.documentStatus <> 'VO'");
- Document that change in http://wiki.openbravo.com/wiki/Projects/Payment_Aging_Balance/User_Documentation [^] |
| Additional Information | |
| Tags | No tags attached. |
| Relationships | | related to | defect | 0021336 | | closed | dmiguelez | Voided invoices appear in report, under some circumstances |
|
| Attached Files | |
|
| Issue History |
| Date Modified | Username | Field | Change |
| 2014-11-27 12:56 | maite | New Issue | |
| 2014-11-27 12:56 | maite | Assigned To | => dmiguelez |
| 2014-11-27 12:56 | maite | Resolution time | => 1420066800 |
| 2014-11-27 12:56 | maite | Assigned To | dmiguelez => eduardo_Argal |
| 2014-11-27 12:56 | maite | Issue Monitored: networkb | |
| 2014-11-27 12:57 | maite | Relationship added | related to 0021336 |
| 2014-11-27 13:25 | maite | Proposed Solution updated | |
| 2014-12-02 20:27 | fsoto82 | Status | new => scheduled |
| 2014-12-02 20:27 | fsoto82 | Assigned To | eduardo_Argal => fsoto82 |
| 2014-12-02 20:27 | fsoto82 | fix_in_branch | => pi |
| 2015-02-16 16:39 | hgbot | Checkin | |
| 2015-02-16 16:39 | hgbot | Note Added: 0074517 | |
| 2015-02-16 16:39 | hgbot | Status | scheduled => resolved |
| 2015-02-16 16:39 | hgbot | Resolution | open => fixed |
| 2015-02-16 16:39 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/mods/org.openbravo.agingbalance/rev/7ff2135d399c075650c00213801beccd415de649 [^] |
| 2015-02-16 17:18 | aferraz | Review Assigned To | => aferraz |
| 2015-02-16 17:18 | aferraz | Note Added: 0074520 | |
| 2015-02-16 17:18 | aferraz | Status | resolved => closed |
| 2015-02-17 11:25 | hgbot | Checkin | |
| 2015-02-17 11:25 | hgbot | Note Added: 0074547 | |
| 2015-02-17 12:00 | hgbot | Checkin | |
| 2015-02-17 12:00 | hgbot | Note Added: 0074548 | |
| 2015-02-27 09:35 | hgbot | Checkin | |
| 2015-02-27 09:35 | hgbot | Note Added: 0075013 | |
| 2015-03-09 20:24 | hgbot | Checkin | |
| 2015-03-09 20:24 | hgbot | Note Added: 0075351 | |
| 2015-03-13 11:22 | hgbot | Checkin | |
| 2015-03-13 11:22 | hgbot | Note Added: 0075530 | |
| 2015-03-13 11:22 | hgbot | Checkin | |
| 2015-03-13 11:22 | hgbot | Note Added: 0075531 | |
| 2015-03-13 11:22 | hgbot | Checkin | |
| 2015-03-13 11:22 | hgbot | Note Added: 0075532 | |
|
Notes |
|
|
(0074517)
|
|
hgbot
|
|
2015-02-16 16:39
|
|
Repository: erp/mods/org.openbravo.agingbalance
Changeset: 7ff2135d399c075650c00213801beccd415de649
Author: Fernando Soto <fernando.soto <at> peoplewalking.com>
Date: Fri Feb 13 08:16:44 2015 -0500
URL: http://code.openbravo.com/erp/mods/org.openbravo.agingbalance/rev/7ff2135d399c075650c00213801beccd415de649 [^]
Fixed bug 28302: New preference to configure if VOID invoices should be included in report
Created the preference "Enable void documents filter in Aging Reports" (AGING_ShowVoidCheckbox).
If set to Y, then a checkbox is shown to select if the void documents should be excluded from the report.
---
M src-db/database/sourcedata/AD_TEXTINTERFACES.xml
M src/org/openbravo/agingbalance/ad_reports/AgingDao.java
M src/org/openbravo/agingbalance/ad_reports/AgingInquiry.html
M src/org/openbravo/agingbalance/ad_reports/AgingInquiry.xml
M src/org/openbravo/agingbalance/ad_reports/AgingProcess.java
M src/org/openbravo/agingbalance/ad_reports/AgingScheduleDetailHTML.jrxml
M web/org.openbravo.agingbalance/js/aging-html-functions.js
A src-db/database/sourcedata/AD_REF_LIST.xml
---
|
|
|
|
|
|
|
|
(0074547)
|
|
hgbot
|
|
2015-02-17 11:25
|
|
|
|
|
(0074548)
|
|
hgbot
|
|
2015-02-17 12:00
|
|
|
|
|
(0075013)
|
|
hgbot
|
|
2015-02-27 09:35
|
|
|
|
|
(0075351)
|
|
hgbot
|
|
2015-03-09 20:24
|
|
Repository: erp/mods/org.openbravo.agingbalance
Changeset: d48966438691b73a65abf0ee5f7b1e12bc26ccd2
Author: Fernando Soto <fernando.soto <at> peoplewalking.com>
Date: Mon Mar 09 11:21:08 2015 -0500
URL: http://code.openbravo.com/erp/mods/org.openbravo.agingbalance/rev/d48966438691b73a65abf0ee5f7b1e12bc26ccd2 [^]
Related to issue 28302: removed use of sessionStorage and other fixes
set checked the "Voided invoices needs to be included" checkbox by default
if the preference is not set, the include the voided invoices by default
---
M src/org/openbravo/agingbalance/ad_reports/AgingProcess.java
M web/org.openbravo.agingbalance/js/aging-html-functions.js
---
|
|
|
|
(0075530)
|
|
hgbot
|
|
2015-03-13 11:22
|
|
Repository: erp/mods/org.openbravo.agingbalance
Changeset: 8dd2e075e74483329304bdaab3215504c46dbc4c
Author: Fernando Soto <fernando.soto <at> peoplewalking.com>
Date: Mon Mar 09 11:21:08 2015 -0500
URL: http://code.openbravo.com/erp/mods/org.openbravo.agingbalance/rev/8dd2e075e74483329304bdaab3215504c46dbc4c [^]
Related to issue 28302: removed use of sessionStorage and other fixes
set checked the "Voided invoices needs to be included" checkbox by default
if the preference is not set, the include the voided invoices by default
---
M src/org/openbravo/agingbalance/ad_reports/AgingProcess.java
M web/org.openbravo.agingbalance/js/aging-html-functions.js
---
|
|
|
|
(0075531)
|
|
hgbot
|
|
2015-03-13 11:22
|
|
|
|
|
(0075532)
|
|
hgbot
|
|
2015-03-13 11:22
|
|
|