Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0021924Openbravo ERP09. Financial managementpublic2012-10-11 22:522012-10-14 14:03
Reporterpjuvara 
Assigned Todmiguelez 
PriorityimmediateSeveritycriticalReproducibilityalways
StatusclosedResolutionunable to reproduce 
PlatformOS5OS Version
Product Version3.0MP15.1 
Target VersionFixed in Version 
Merge Request Status
Review Assigned Toeduardo_Argal
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0021924: Balance sheet does not work when dates are expressed in MM-DD-YYYY
DescriptionThis 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 ReproduceSet date format to MM-DD-YYYY.
Submit the balance sheet as of a particular date.
Proposed Solution
Additional Information
TagsCoworking
Relationships
Attached Filespng Openbravo - Trial Balance Report - Wrong.png (137,987) 2012-10-13 03:49
https://issues.openbravo.com/file_download.php?file_id=5651&type=bug
png

png Openbravo - Trial Balance Report-Correct.png (140,298) 2012-10-13 03:50
https://issues.openbravo.com/file_download.php?file_id=5652&type=bug
png
Issue History
Date ModifiedUsernameFieldChange
2012-10-11 22:52pjuvaraNew Issue
2012-10-11 22:52pjuvaraAssigned To => dmiguelez
2012-10-11 22:52pjuvaraModules => Core
2012-10-11 22:52pjuvaraOBNetwork customer => Yes
2012-10-11 22:52pjuvaraTag Attached: Coworking
2012-10-13 03:49pjuvaraNote Added: 0053328
2012-10-13 03:49pjuvaraFile Added: Openbravo - Trial Balance Report - Wrong.png
2012-10-13 03:50pjuvaraFile Added: Openbravo - Trial Balance Report-Correct.png
2012-10-14 14:03eduardo_ArgalReview Assigned To => eduardo_Argal
2012-10-14 14:03eduardo_ArgalNote Added: 0053340
2012-10-14 14:03eduardo_ArgalStatusnew => closed
2012-10-14 14:03eduardo_ArgalResolutionopen => unable to reproduce

Notes
(0053328)
pjuvara   
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   
2012-10-14 14:03   
Unable to reproduce. It is working fine