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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0015575
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 09. Financial managementminoralways2011-01-05 08:362011-03-23 00:00
ReportermalsasuaView Statuspublic 
Assigned ToAinhoaPagola 
PriorityhighResolutionfixedFixed in Version3.0RC6
StatusclosedFix in branchpiFixed in SCM revision0208d57942c9
ProjectionnoneETAnoneTarget Version2.50MP27
OSLinux 32 bitDatabasePostgreSQLJava version1.6.0_18
OS VersionCommunity ApplianceDatabase version8.3.9Ant version1.7.1
Product Version2.50MP25SCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0015575: accounting date in "gl journal line" is not updated

Descriptionwhen you create a new "gl journal batch" and "gl journal", with accounting date X.
After that, you create a new "gl journal line". This line has got in accounting date X.
If you change the accounting date of "gl journal" and "gl journal batch" to Y, the accounting date in "gl journal lines" continues being X. And if you create a new "gl journal line", the accounting date in the new line is X too.
Steps To Reproduce. new Financial Management || Accounting || Transactions || G/L Journal || Batch
   document date and accounting date is 05/01/2010

. new Financial Management || Accounting || Transactions || G/L Journal || Batch >> Header
   document date and accounting date is 05/01/2010

. new Financial Management || Accounting || Transactions || G/L Journal || Batch >> Header >> Lines
  save it.
. in grid mode, accounting date is 05/01/2010

. in G/L Journal || Batch and G/L Journal || Batch >> Header change the document date and accounting date to 05/02/2010

. go to Financial Management || Accounting || Transactions || G/L Journal || Batch >> Header >> Lines
 in grid mode, accounting date is 05/01/2010

. new Financial Management || Accounting || Transactions || G/L Journal || Batch >> Header >> Lines
 save it.
 in grid mode, the new line has got accounting date 05/01/2010
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
depends on backport 00163482.50MP27 closedAinhoaPagola accounting date in "gl journal line" is not updated 
blocks feature request 0007236 acknowledgedshuehner Tracking issue: Cleanup for 3.00 

-  Notes
(0035035)
AinhoaPagola (reporter)
2011-03-18 12:35
edited on: 2011-03-18 12:36

Accounting date field in "Financial Management || Accounting || Transactions || G/L Journal || Batch >> Header >> Lines" should be removed as it is useless.

The field is going to be hidden and the column set as deprecated [Column DateAcct - Table GL_Journalline]

This column is only used in:
* GL_journalline_acct_v - A view that is not used in the application. It is not included in the application dictionary. This view should be removed in the cleanup proyect.

* Triggers of GL_journalline. [Line] DateAcct is used to convert currencies. The accounting date of the header should be used instead. This is going to be fixed.

(0035102)
hgbot (developer)
2011-03-21 16:20

Repository: erp/devel/pi
Changeset: 0208d57942c9aef5ac7005474c6d5c6395c9d212
Author: Ainhoa Pagola <ainhoa.pagola <at> openbravo.com>
Date: Mon Mar 21 16:19:08 2011 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/0208d57942c9aef5ac7005474c6d5c6395c9d212 [^]

Fixes issue 15575. Account Date in GL Journal Line deprecated.

---
M src-db/database/model/tables/GL_JOURNALLINE.xml
M src-db/database/model/triggers/GL_JL_CHK_RESTRICTIONS_TRG.xml
M src-db/database/model/triggers/GL_JOURNALLINE2_TRG.xml
M src-db/database/sourcedata/AD_COLUMN.xml
M src-db/database/sourcedata/AD_FIELD.xml
---
(0035139)
malsasua (developer)
2011-03-22 11:48

tested: it works fine. i have tested to change the date of header with distinct currency, and the conversion date is the date of header.
All is posted with date of header.

- Issue History
Date Modified Username Field Change
2011-01-05 08:36 malsasua New Issue
2011-01-05 08:36 malsasua Assigned To => dalsasua
2011-01-05 08:36 malsasua Modules => Core
2011-01-10 18:06 malsasua Issue Monitored: networkb
2011-03-17 10:49 AinhoaPagola Assigned To dalsasua => AinhoaPagola
2011-03-17 10:50 AinhoaPagola Status new => scheduled
2011-03-17 10:50 AinhoaPagola fix_in_branch => pi
2011-03-18 12:35 AinhoaPagola Note Added: 0035035
2011-03-18 12:36 AinhoaPagola Note Edited: 0035035 View Revisions
2011-03-18 12:37 AinhoaPagola Relationship added blocks 0007236
2011-03-21 16:20 hgbot Checkin
2011-03-21 16:20 hgbot Note Added: 0035102
2011-03-21 16:20 hgbot Status scheduled => resolved
2011-03-21 16:20 hgbot Resolution open => fixed
2011-03-21 16:20 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/0208d57942c9aef5ac7005474c6d5c6395c9d212 [^]
2011-03-22 11:48 malsasua Note Added: 0035139
2011-03-22 11:48 malsasua Status resolved => closed
2011-03-22 11:48 malsasua Fixed in Version => 3.0RC6
2011-03-23 00:00 anonymous sf_bug_id 0 => 3235745


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker