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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0028952
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 09. Financial managementmajoralways2015-02-16 13:362015-05-07 22:17
ReporterngarciaView Statuspublic 
Assigned Tofsoto82 
PriorityurgentResolutionfixedFixed in Version3.0PR15Q3
StatusclosedFix in branchpiFixed in SCM revision908de9299675
ProjectionnoneETAnoneTarget Version3.0PR15Q3
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned Toaferraz
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0028952: Period Not Updated in G/L Journal if the Accounting Date belongs to a closed period. It is not possible to unpost it

DescriptionPeriod Not Updated in G/L Journal if the Accounting Date belongs to a closed period. It allows to save a record with an accounting date that does not belong to the period.
Steps To ReproduceAs group admin role:
   Create a G/L Journal for F&B US, Inc.
   Set the Currency to USD
   Leave Accounting Date and Document Date with today's date and check the Period is filled correctly
   Create a Header with the same values, add two lines to it (in order to be balanced) and complete it
   Change the Accounting Date of the Header to a date which belongs to a Closed period
   Check the Period is not updated
   Post it and check it is posted with the accounting date (although the period it belongs to is closed)
   Try to unpost it and check you get the following error message:
      Period Closed. It is not possible to unpost a document in a closed period
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
related to defect 0028943 closedaferraz It should be possible to enter different accounting and document date in GL Journal and Header 
depends on defect 0028973 closedreinaldoguerra G/L Journal can be posted in a closed period. It cannot be unposted then 
causes defect 0031860 closedAtulOpenbravo Cannot save a G/L Journal header with the date of the adjustment period if both periods are opened 

-  Notes
(0074511)
ngarcia (developer)
2015-02-16 14:16

Inconsistent data should be corrected. The processed records in G/L Journal window can have an accounting date which does not belong to the defined period. For posted records, the inconsistency is both in the GL_JOURNAL and FACT_ACCT tables
(0075934)
fsoto82 (developer)
2015-03-24 15:00

As group admin role:
   Create a G/L Journal for F&B US, Inc.
   Set the Currency to USD
   Leave Accounting Date and Document Date with today's date and check the Period is filled correctly
   Create a Header with the same values, add two lines to it (in order to be balanced) and complete it
   Change the Accounting Date of the Header to a date which belongs to a Closed period
   An Error messsge is displayed and is not allowed to save the record if the date belongs to a closed period
(0077043)
hgbot (developer)
2015-05-06 10:17

Repository: erp/devel/pi
Changeset: 908de92996757265cce434502b36adf8860d6450
Author: Fernando Soto <fernando.soto <at> peoplewalking.com>
Date: Mon Mar 23 14:11:56 2015 -0500
URL: http://code.openbravo.com/erp/devel/pi/rev/908de92996757265cce434502b36adf8860d6450 [^]

Fixed bug 28952: Period Not Updated in G/L Journal if Acct Date belongs to a closed period.

Modified SL_Journal_Period class (callout) to display a error message if the Acct. Date belongs to a closed period.
Modified GL_JOURNAL_CHK_RESTRICT_TRG trigger to not allow to save if the Acct. Date belongs to a closed period.
Created UpdateGLJournalDateAcct to fix the data.

---
M src-db/database/model/triggers/GL_JOURNAL_CHK_RESTRICT_TRG.xml
M src/org/openbravo/erpCommon/ad_callouts/SL_Journal_Period.java
---
(0077044)
hgbot (developer)
2015-05-06 10:17

Repository: erp/devel/pi
Changeset: 17cd117fb31b7007346b3a3c14a87b25f297bcd8
Author: Alvaro Ferraz <alvaro.ferraz <at> openbravo.com>
Date: Tue May 05 18:10:20 2015 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/17cd117fb31b7007346b3a3c14a87b25f297bcd8 [^]

Related to issue 28952: Code review

Remove unused lines of code

---
M src-db/database/model/triggers/GL_JOURNAL_CHK_RESTRICT_TRG.xml
M src/org/openbravo/erpCommon/ad_callouts/SL_Journal_Period.java
---
(0077045)
aferraz (manager)
2015-05-06 10:18

Code review + Testing OK
(0077217)
hudsonbot (developer)
2015-05-07 22:17

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/a1817f84bd8b [^]
Maturity status: Test
(0077218)
hudsonbot (developer)
2015-05-07 22:17

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/a1817f84bd8b [^]
Maturity status: Test

- Issue History
Date Modified Username Field Change
2015-02-16 13:36 ngarcia New Issue
2015-02-16 13:36 ngarcia Assigned To => Sandrahuguet
2015-02-16 13:36 ngarcia Modules => Core
2015-02-16 13:36 ngarcia Resolution time => 1426546800
2015-02-16 13:36 ngarcia Triggers an Emergency Pack => No
2015-02-16 13:39 ngarcia Relationship added depends on 0028943
2015-02-16 13:39 ngarcia Issue Monitored: networkb
2015-02-16 14:16 ngarcia Note Added: 0074511
2015-02-17 19:05 ngarcia Relationship added related to 0028973
2015-02-23 13:30 jonalegriaesarte Target Version 3.0PR15Q2 => 3.0PR15Q3
2015-03-02 15:51 fsoto82 Status new => scheduled
2015-03-02 15:51 fsoto82 Assigned To Sandrahuguet => fsoto82
2015-03-02 15:51 fsoto82 fix_in_branch => pi
2015-03-24 15:00 fsoto82 Note Added: 0075934
2015-05-04 17:55 aferraz Relationship deleted depends on 0028943
2015-05-04 17:55 aferraz Relationship deleted related to 0028973
2015-05-04 17:55 aferraz Relationship added related to 0028943
2015-05-04 17:59 aferraz Relationship added depends on 0028973
2015-05-06 10:17 hgbot Checkin
2015-05-06 10:17 hgbot Note Added: 0077043
2015-05-06 10:17 hgbot Status scheduled => resolved
2015-05-06 10:17 hgbot Resolution open => fixed
2015-05-06 10:17 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/908de92996757265cce434502b36adf8860d6450 [^]
2015-05-06 10:17 hgbot Checkin
2015-05-06 10:17 hgbot Note Added: 0077044
2015-05-06 10:18 aferraz Review Assigned To => aferraz
2015-05-06 10:18 aferraz Note Added: 0077045
2015-05-06 10:18 aferraz Status resolved => closed
2015-05-06 10:18 aferraz Fixed in Version => 3.0PR15Q3
2015-05-07 22:17 hudsonbot Checkin
2015-05-07 22:17 hudsonbot Note Added: 0077217
2015-05-07 22:17 hudsonbot Checkin
2015-05-07 22:17 hudsonbot Note Added: 0077218
2016-01-11 14:15 ngarcia Relationship added causes 0031860


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker