Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0021924 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] 09. Financial management | critical | always | 2012-10-11 22:52 | 2012-10-14 14:03 | |||
| Reporter | pjuvara | View Status | public | |||||
| Assigned To | dmiguelez | |||||||
| Priority | immediate | Resolution | unable to reproduce | Fixed in Version | ||||
| Status | closed | Fix in branch | Fixed in SCM revision | |||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | 3.0MP15.1 | SCM revision | ||||||
| Review Assigned To | eduardo_Argal | |||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0021924: Balance sheet does not work when dates are expressed in MM-DD-YYYY | |||||||
| Description | This is a regression. Customer upgraded production environment from MP12.1 to MP15.1. After upgrade, the Balance Sheet & P&L report does not work anymore. The customer is located in the USA and has the system configured with date format MM-DD-YYYY. When you submit the report with date for example 09-30-2012 (balance sheet as of 30-SEP-2012), all the figures in the balance sheet come out to zero. The data is correct. If you run the report without specifying a date, it works (it correctly shows figures as of the end of the year) but if you specify a date it does not. This was working in MP12.1 and it no longer works in MP15.1, so it is a regression. | |||||||
| Steps To Reproduce | Set date format to MM-DD-YYYY. Submit the balance sheet as of a particular date. | |||||||
| Tags | Coworking | |||||||
| Attached Files |  Openbravo - Trial Balance Report - Wrong.png [^] (137,987 bytes) 2012-10-13 03:49
Openbravo - Trial Balance Report-Correct.png [^] (140,298 bytes) 2012-10-13 03:50
| |||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
|
(0053328) pjuvara (reporter) 2012-10-13 03:49 |
The issue appears to be more complex than what originally reported. If you run the Balance Sheet report as of 09-29-2012 (29 SEP 2012), it works fine (or at least it shows something); if you run it on 09-30-2012, it is empty. The records in FACT_ACCT do not justify this behavior, so this is a reporting issue, not a data issue. To validate what is going on, I run the Trial Balance in production. You can see in attachment two outputs, one from 01-SEP-2012 to 29-SEP-2012 (this is correct) and one from 01-SEP-2012 to 30-SEP-2012 (which does not return any data). It is clear that for some reason the system interprets 30-SEP-2012 incorrectly when it is specified as 09-30-2012. See screenshot attached. |
|
(0053340) eduardo_Argal (developer) 2012-10-14 14:03 |
Unable to reproduce. It is working fine |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2012-10-11 22:52 | pjuvara | New Issue | |
| 2012-10-11 22:52 | pjuvara | Assigned To | => dmiguelez |
| 2012-10-11 22:52 | pjuvara | Modules | => Core |
| 2012-10-11 22:52 | pjuvara | Tag Attached: Coworking | |
| 2012-10-13 03:49 | pjuvara | Note Added: 0053328 | |
| 2012-10-13 03:49 | pjuvara | File Added: Openbravo - Trial Balance Report - Wrong.png | |
| 2012-10-13 03:50 | pjuvara | File Added: Openbravo - Trial Balance Report-Correct.png | |
| 2012-10-14 14:03 | eduardo_Argal | Review Assigned To | => eduardo_Argal |
| 2012-10-14 14:03 | eduardo_Argal | Note Added: 0053340 | |
| 2012-10-14 14:03 | eduardo_Argal | Status | new => closed |
| 2012-10-14 14:03 | eduardo_Argal | Resolution | open => unable to reproduce |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |