Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0015575Openbravo ERP09. Financial managementpublic2011-01-05 08:362011-03-23 00:00
Reportermalsasua 
Assigned ToAinhoaPagola 
PriorityhighSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS VersionCommunity Appliance
Product Version2.50MP25 
Target Version2.50MP27Fixed in Version3.0RC6 
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
Summary0015575: 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
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
depends on backport 00163482.50MP27 closed AinhoaPagola accounting date in "gl journal line" is not updated 
blocks feature request 0007236 acknowledged shuehner Tracking issue: Cleanup for 3.00 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2011-01-05 08:36malsasuaNew Issue
2011-01-05 08:36malsasuaAssigned To => dalsasua
2011-01-05 08:36malsasuaModules => Core
2011-01-10 18:06malsasuaIssue Monitored: networkb
2011-03-17 10:49AinhoaPagolaAssigned Todalsasua => AinhoaPagola
2011-03-17 10:50AinhoaPagolaStatusnew => scheduled
2011-03-17 10:50AinhoaPagolafix_in_branch => pi
2011-03-18 12:35AinhoaPagolaNote Added: 0035035
2011-03-18 12:36AinhoaPagolaNote Edited: 0035035bug_revision_view_page.php?bugnote_id=0035035#r1646
2011-03-18 12:37AinhoaPagolaRelationship addedblocks 0007236
2011-03-21 16:20hgbotCheckin
2011-03-21 16:20hgbotNote Added: 0035102
2011-03-21 16:20hgbotStatusscheduled => resolved
2011-03-21 16:20hgbotResolutionopen => fixed
2011-03-21 16:20hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/0208d57942c9aef5ac7005474c6d5c6395c9d212 [^]
2011-03-22 11:48malsasuaNote Added: 0035139
2011-03-22 11:48malsasuaStatusresolved => closed
2011-03-22 11:48malsasuaFixed in Version => 3.0RC6
2011-03-23 00:00anonymoussf_bug_id0 => 3235745

Notes
(0035035)
AinhoaPagola   
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   
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   
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.