Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0019001Openbravo ERP09. Financial managementpublic2011-11-07 01:162012-03-05 12:11
Reporterpjuvara 
Assigned Tovmromanos 
PrioritynormalSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version3.0MP4.1 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0019001: Incorrect accounting date and period in GL Journal Header when system date format is MM-DD-YYYY
DescriptionIf you configure the system to use the US style date format (MM-DD-YYYY), the accounting date of a GL Journal Header is not properly copied from the GL Journal Batch.
Also the period is not correctly derived.
Steps To ReproduceSee attached video.
Proposed Solution
Additional Information
TagsAccountingDemo, VMA-Reviewed
Relationships
blocks design defect 0019002 closed plujan System is not fully working with date format MM-DD-YYYY 
Attached Files? out.ogv (2,878,008) 2011-11-07 01:16
https://issues.openbravo.com/file_download.php?file_id=4726&type=bug
Issue History
Date ModifiedUsernameFieldChange
2011-11-07 01:16pjuvaraNew Issue
2011-11-07 01:16pjuvaraAssigned To => jonalegriaesarte
2011-11-07 01:16pjuvaraFile Added: out.ogv
2011-11-07 01:16pjuvaraModules => Core
2011-11-07 01:20pjuvaraRelationship addedblocks 0019002
2011-11-07 01:43pjuvaraTag Attached: AccountingDemo
2011-12-19 19:12marvintmAssigned Tojonalegriaesarte => dalsasua
2012-02-29 12:43iciordiaAssigned Todalsasua => iciordia
2012-02-29 12:44iciordiaAssigned Toiciordia => vmromanos
2012-02-29 13:01vmromanosTag Attached: VMA-Reviewed
2012-02-29 13:01vmromanosStatusnew => scheduled
2012-02-29 13:01vmromanosfix_in_branch => pi
2012-03-01 15:25hgbotCheckin
2012-03-01 15:25hgbotNote Added: 0045667
2012-03-01 15:25hgbotStatusscheduled => resolved
2012-03-01 15:25hgbotResolutionopen => fixed
2012-03-01 15:25hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/62d24bfb31b9fbb6e1c67759f7b5e2351e659f45 [^]
2012-03-01 15:30vmromanosNote Added: 0045669
2012-03-02 15:40hudsonbotCheckin
2012-03-02 15:40hudsonbotNote Added: 0046012
2012-03-05 12:11gorkaionNote Added: 0046037
2012-03-05 12:11gorkaionStatusresolved => closed

Notes
(0045667)
hgbot   
2012-03-01 15:25   
Repository: erp/devel/pi
Changeset: 62d24bfb31b9fbb6e1c67759f7b5e2351e659f45
Author: Víctor Martínez Romanos <victor.martinez <at> openbravo.com>
Date: Thu Mar 01 15:24:18 2012 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/62d24bfb31b9fbb6e1c67759f7b5e2351e659f45 [^]

Fixed bug 19001: Accounting Date and Period fields in GL/Journal window
When creating new records in the batch tab, the callout that populates
the Period field wasn't launched. However, when creating a new header
record the callout in the Doc. Date, Acct Date and Period was launched,
populating some fields with wrong values.

The fix consists in:
- Removing "Validate on new" flag for the Doc. Date, Acct. Date and Period
for both batch and header tabs
- The default value for the batch's period field is populated through the
same SQL used in the SL_Journal_Period callout
- The header fields are by default populated using the values in the batch
tab
- In case the user changes Acct. Date, Doc. Date or period, the rest of
the fields are automatically calculated through the callout.

---
M src-db/database/sourcedata/AD_COLUMN.xml
---
(0045669)
vmromanos   
2012-03-01 15:30   
No regression risk
Test plan 1:
- Set your system to use US date format (MM-DD-YYYY)
- Create a new GL/Journal batch. Document Date, Acct. Date and Period fields should be properly populated
- Try changing any of the previous fields. The Acct. Date should always be inside the selected Period
- Create a new header record. The Document Date, Acct. Date and Period fields should be the same we had in the batch tab
- Try changing any of the previous fields. The Acct. Date should always be inside the selected Period

Test plan 2:
- Set your system to use Spanish date format (DD-MM-YYYY)
- Create a new GL/Journal batch. Document Date, Acct. Date and Period fields should be properly populated
- Try changing any of the previous fields. The Acct. Date should always be inside the selected Period
- Create a new header record. The Document Date, Acct. Date and Period fields should be the same we had in the batch tab
- Try changing any of the previous fields. The Acct. Date should always be inside the selected Period
(0046012)
hudsonbot   
2012-03-02 15:40   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/544d64e0c159 [^]

Maturity status: Test
(0046037)
gorkaion   
2012-03-05 12:11   
reviewed and tested