details: /erp/devel/main/rev/1c966a5ea33e
changeset: 8527:1c966a5ea33e
user: Ratnakaram Suresh <ratnakaram.suresh <at> openbravo.com>
date: Tue Oct 12 10:07:07 2010 +0530
summary: Fixes issue 14652 BOM window: Change the name of the button
\"Create/post production\"
details: /erp/devel/main/rev/db409a855f2d
changeset: 8528:db409a855f2d
user: Sivaraman Rajagopal <sivaraman.rajagopal <at> openbravo.com>
date: Tue Oct 12 10:39:38 2010 +0530
summary: Fixes issue 14606: You can process a Bank Statement with a Line with
invalid Accounting Date
C_CHK_OPEN_PERIOD has been used to validate if bank statement lines don't have
invalid date. Error message will be displayed in case invalidity.
No impacts.
details: /erp/devel/main/rev/813c8d5808cc
changeset: 8529:813c8d5808cc
user: RM packaging bot <staff.rm <at> openbravo.com>
date: Tue Oct 12 19:39:28 2010 +0000
summary: CI: promote changesets from pi to main
diffstat:
src-db/database/model/functions/C_BANKSTATEMENT_POST.xml | 16 ++++++++++++++++
src-db/database/sourcedata/AD_FIELD.xml | 2 +-
src-db/database/sourcedata/AD_MODULE.xml | 4 ++--
src-db/database/sourcedata/AD_PROCESS.xml | 3 ++-
4 files changed, 21 insertions(+), 4 deletions(-)
diffs (93 lines):
diff -r 68df5d5fde2c -r 813c8d5808cc
src-db/database/model/functions/C_BANKSTATEMENT_POST.xml
--- a/src-db/database/model/functions/C_BANKSTATEMENT_POST.xml Mon Oct 11
15:15:28 2010 +0200
+++ b/src-db/database/model/functions/C_BANKSTATEMENT_POST.xml Tue Oct 12
19:39:28 2010 +0000
@@ -65,6 +65,7 @@
TYPE RECORD IS REF CURSOR;
Cur_Parameter RECORD;
Cur_BankstatementDebtpayment RECORD;
+ Cur_BankstatementLine RECORD;
-- Parameter Variables
-- Parameter Variables
v_Processed CHAR(1) ;
@@ -80,6 +81,8 @@
v_BS_Date DATE;
v_AD_Org_ID VARCHAR2(32);
v_AD_Client_ID VARCHAR2(32) ;
+ v_ValutadatePeriod_ID NUMBER(10) ;
+ v_DateacctPeriod_ID NUMBER(10) ;
FINISH_PROCESS BOOLEAN:=false;
BEGIN
-- Update AD_PInstance
@@ -371,6 +374,19 @@
RAISE_APPLICATION_ERROR(-20000, '@Inline@'||v_line||'
'||'@DebtAmountsSamemoneyNoMatch@') ;
END IF;
END IF;--FINISH_PROCESS
+ FOR Cur_BankstatementLine IN
+ (SELECT valutadate,
+ dateacct
+ FROM C_BANKSTATEMENTLINE
+ WHERE C_BANKSTATEMENT_ID = v_Record_ID
+ AND ISACTIVE='Y')
+ LOOP
+ v_ValutadatePeriod_ID := C_CHK_OPEN_PERIOD (v_AD_Org_ID,
Cur_BankstatementLine.valutadate, 'CMB',NULL);
+ v_DateacctPeriod_ID := C_CHK_OPEN_PERIOD (v_AD_Org_ID,
Cur_BankstatementLine.dateacct, 'CMB',NULL);
+ IF (v_ValutadatePeriod_ID <> 1 OR v_DateacctPeriod_ID <> 1) THEN
+ RAISE_APPLICATION_ERROR(-20000, '@PeriodNotAvailable@') ;
+ END IF;
+ END LOOP;
IF(NOT FINISH_PROCESS) THEN
SELECT COUNT(*),
MAX(bsl.Line)
diff -r 68df5d5fde2c -r 813c8d5808cc src-db/database/sourcedata/AD_FIELD.xml
--- a/src-db/database/sourcedata/AD_FIELD.xml Mon Oct 11 15:15:28 2010 +0200
+++ b/src-db/database/sourcedata/AD_FIELD.xml Tue Oct 12 19:39:28 2010 +0000
@@ -45975,7 +45975,7 @@
<!--3790--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
<!--3790--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
<!--3790--> <ISACTIVE><![CDATA[Y]]></ISACTIVE>
-<!--3790--> <NAME><![CDATA[Create/Post Production]]></NAME>
+<!--3790--> <NAME><![CDATA[Create/Process Production]]></NAME>
<!--3790--> <DESCRIPTION><![CDATA[Create production lines, if not created -
otherwise process the production]]></DESCRIPTION>
<!--3790--> <HELP><![CDATA[Create/Post Production will generate the
production lines and process the production. If the production lines already
exists, the production will be processed]]></HELP>
<!--3790--> <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
diff -r 68df5d5fde2c -r 813c8d5808cc src-db/database/sourcedata/AD_MODULE.xml
--- a/src-db/database/sourcedata/AD_MODULE.xml Mon Oct 11 15:15:28 2010 +0200
+++ b/src-db/database/sourcedata/AD_MODULE.xml Tue Oct 12 19:39:28 2010 +0000
@@ -6,7 +6,7 @@
<!--0--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
<!--0--> <ISACTIVE><![CDATA[Y]]></ISACTIVE>
<!--0--> <NAME><![CDATA[Core]]></NAME>
-<!--0--> <VERSION><![CDATA[2.50.18452]]></VERSION>
+<!--0--> <VERSION><![CDATA[2.50.18528]]></VERSION>
<!--0--> <DESCRIPTION><![CDATA[Core module is the base one]]></DESCRIPTION>
<!--0--> <HELP><![CDATA[Core module is the base one, all developments in core
are included as part of the standard Openbravo ERP.]]></HELP>
<!--0--> <URL><![CDATA[www.openbravo.com]]></URL>
@@ -22,7 +22,7 @@
<!--0--> <ISTRANSLATIONMODULE><![CDATA[N]]></ISTRANSLATIONMODULE>
<!--0--> <HASREFERENCEDATA><![CDATA[Y]]></HASREFERENCEDATA>
<!--0--> <REFERENCEDATAINFO><![CDATA[Standard document types for orders,
invoices, etc. and settings]]></REFERENCEDATAINFO>
-<!--0--> <VERSION_LABEL><![CDATA[dev]]></VERSION_LABEL>
+<!--0--> <VERSION_LABEL><![CDATA[CI]]></VERSION_LABEL>
<!--0--> <ISCOMMERCIAL><![CDATA[N]]></ISCOMMERCIAL>
<!--0--></AD_MODULE>
diff -r 68df5d5fde2c -r 813c8d5808cc src-db/database/sourcedata/AD_PROCESS.xml
--- a/src-db/database/sourcedata/AD_PROCESS.xml Mon Oct 11 15:15:28 2010 +0200
+++ b/src-db/database/sourcedata/AD_PROCESS.xml Tue Oct 12 19:39:28 2010 +0000
@@ -692,7 +692,7 @@
<!--137--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
<!--137--> <ISACTIVE><![CDATA[Y]]></ISACTIVE>
<!--137--> <VALUE><![CDATA[M_Production]]></VALUE>
-<!--137--> <NAME><![CDATA[Create/Post Production]]></NAME>
+<!--137--> <NAME><![CDATA[Create/Process Production]]></NAME>
<!--137--> <DESCRIPTION><![CDATA[Create production lines, if not created -
otherwise process the production]]></DESCRIPTION>
<!--137--> <HELP><![CDATA[Create/Post Production will generate the production
lines and process the production. If the production lines already exists, the
production will be processed]]></HELP>
<!--137--> <ACCESSLEVEL><![CDATA[3]]></ACCESSLEVEL>
@@ -702,6 +702,7 @@
<!--137--> <ISDIRECTPRINT><![CDATA[N]]></ISDIRECTPRINT>
<!--137--> <ISBACKGROUND><![CDATA[N]]></ISBACKGROUND>
<!--137--> <ISJASPER><![CDATA[N]]></ISJASPER>
+<!--137--> <ISEXTERNALSERVICE><![CDATA[N]]></ISEXTERNALSERVICE>
<!--137--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
<!--137--> <UIPATTERN><![CDATA[S]]></UIPATTERN>
<!--137--></AD_PROCESS>
------------------------------------------------------------------------------
Beautiful is writing same markup. Internet Explorer 9 supports
standards for HTML5, CSS3, SVG 1.1, ECMAScript5, and DOM L2 & L3.
Spend less time writing and rewriting code and more time creating great
experiences on the web. Be a part of the beta today.
http://p.sf.net/sfu/beautyoftheweb
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
