Fixes issue 29041: Period is not automatically populated in G/L Journal window
authorAlvaro Ferraz <alvaro.ferraz@openbravo.com>
Tue, 24 Feb 2015 14:12:20 +0100
changeset 26077 46a20957f70c
parent 26076 05e90afd7678
child 26078 e72f5b99ab8b
Fixes issue 29041: Period is not automatically populated in G/L Journal window

Defaultvalue from C_Period_ID column in GL_JournalBatch table has been changed to get current date instead of accounting date, which is null when creating a new record.
src-db/database/sourcedata/AD_COLUMN.xml
--- a/src-db/database/sourcedata/AD_COLUMN.xml	Wed Feb 25 18:18:59 2015 +0100
+++ b/src-db/database/sourcedata/AD_COLUMN.xml	Tue Feb 24 14:12:20 2015 +0100
@@ -23412,7 +23412,7 @@
 <!--1654-->  <AD_REFERENCE_ID><![CDATA[18]]></AD_REFERENCE_ID>
 <!--1654-->  <AD_REFERENCE_VALUE_ID><![CDATA[233]]></AD_REFERENCE_VALUE_ID>
 <!--1654-->  <FIELDLENGTH><![CDATA[22]]></FIELDLENGTH>
-<!--1654-->  <DEFAULTVALUE><![CDATA[@SQL= SELECT C_Period_ID FROM C_Period WHERE C_Year_ID IN (SELECT C_Year_ID FROM C_Year WHERE C_Calendar_ID =(SELECT C_Calendar_ID FROM AD_ORG WHERE AD_Client_ID= @AD_Client_ID@ AND AD_ORG_ID=(SELECT AD_ORG_GETCALENDAROWNER( @AD_Org_ID@ ) from dual))) AND to_date( @DateAcct@ ) BETWEEN StartDate AND EndDate AND PeriodType='S' AND exists (select 1 from c_periodcontrol where c_periodcontrol.c_period_id = c_period.c_period_id AND periodstatus = 'O')]]></DEFAULTVALUE>
+<!--1654-->  <DEFAULTVALUE><![CDATA[@SQL= SELECT C_Period_ID FROM C_Period WHERE C_Year_ID IN (SELECT C_Year_ID FROM C_Year WHERE C_Calendar_ID =(SELECT C_Calendar_ID FROM AD_ORG WHERE AD_Client_ID= @AD_Client_ID@ AND AD_ORG_ID=(SELECT AD_ORG_GETCALENDAROWNER( @AD_Org_ID@ ) from dual))) AND to_date( @#Date@ ) BETWEEN StartDate AND EndDate AND PeriodType='S' AND exists (select 1 from c_periodcontrol where c_periodcontrol.c_period_id = c_period.c_period_id AND periodstatus = 'O')]]></DEFAULTVALUE>
 <!--1654-->  <ISKEY><![CDATA[N]]></ISKEY>
 <!--1654-->  <ISPARENT><![CDATA[N]]></ISPARENT>
 <!--1654-->  <ISMANDATORY><![CDATA[N]]></ISMANDATORY>