0026053: Excludeforwithholding column of C_INVOICELINE table must be not null because it is a yes/no column.

Description

Excludeforwithholding column of C_INVOICELINE table can not be set as null. A boolean column only accept two values, yes and no. If you allow null values then it is not a boolean column.

The problem is that it is allways set as null for sales invoices.

It also applies to 3.0MP31.2 version.

Steps To Reproduce

Create a sales invoice line and save it.

Proposed Solution

Check the attached patch.

Tags

No tags attached.

Attached Files

C_INVOICELINE.diff [^] (2,048 bytes) 2014-03-20 22:08 [Show Content] [Hide Content]

diff -u -r mercurial250/OpenbravoERP-2.50MP51/src-db/database/model/tables/C_INVOICELINE.xml /opt/OpenbravoERP-2.50MP51/src-db/database/model/tables/C_INVOICELINE.xml
--- mercurial250/OpenbravoERP-2.50MP51/src-db/database/model/tables/C_INVOICELINE.xml	2014-02-10 16:47:29.960196531 -0500
+++ /opt/OpenbravoERP-2.50MP51/src-db/database/model/tables/C_INVOICELINE.xml	2014-03-20 15:38:10.045262475 -0500
@@ -141,8 +141,8 @@
         <default><![CDATA[0]]></default>
         <onCreateDefault/>
       </column>
-      <column name="EXCLUDEFORWITHHOLDING" primaryKey="false" required="false" type="CHAR" size="1" autoIncrement="false">
-        <default/>
+      <column name="EXCLUDEFORWITHHOLDING" primaryKey="false" required="true" type="CHAR" size="1" autoIncrement="false">
+        <default><![CDATA[N]]></default>
         <onCreateDefault/>
       </column>
       <column name="ISEDITLINENETAMT" primaryKey="false" required="false" type="CHAR" size="1" autoIncrement="false">
diff -u -r mercurial250/OpenbravoERP-2.50MP51/src-db/database/sourcedata/AD_COLUMN.xml /opt/OpenbravoERP-2.50MP51/src-db/database/sourcedata/AD_COLUMN.xml
--- mercurial250/OpenbravoERP-2.50MP51/src-db/database/sourcedata/AD_COLUMN.xml	2014-02-10 16:47:32.260196547 -0500
+++ /opt/OpenbravoERP-2.50MP51/src-db/database/sourcedata/AD_COLUMN.xml	2014-03-20 15:50:42.841267683 -0500
@@ -253768,9 +253768,10 @@
 <!--1002100010-->  <AD_TABLE_ID><![CDATA[333]]></AD_TABLE_ID>
 <!--1002100010-->  <AD_REFERENCE_ID><![CDATA[20]]></AD_REFERENCE_ID>
 <!--1002100010-->  <FIELDLENGTH><![CDATA[1]]></FIELDLENGTH>
+<!--1002100010-->  <DEFAULTVALUE><![CDATA[N]]></DEFAULTVALUE>
 <!--1002100010-->  <ISKEY><![CDATA[N]]></ISKEY>
 <!--1002100010-->  <ISPARENT><![CDATA[N]]></ISPARENT>
-<!--1002100010-->  <ISMANDATORY><![CDATA[N]]></ISMANDATORY>
+<!--1002100010-->  <ISMANDATORY><![CDATA[Y]]></ISMANDATORY>
 <!--1002100010-->  <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
 <!--1002100010-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
 <!--1002100010-->  <SEQNO><![CDATA[53]]></SEQNO>

Relationships [ Relation Graph ] [ Dependency Graph ]

Notes
There are no notes attached to this issue.

Issue History
Date Modified	Username	Field	Change
2014-03-20 22:08	chelipf	New Issue
2014-03-20 22:08	chelipf	Assigned To	=> dmiguelez
2014-03-20 22:08	chelipf	File Added: C_INVOICELINE.diff
2014-03-20 22:08	chelipf	Web browser	=> Mozilla Firefox
2014-03-20 22:08	chelipf	Modules	=> Core
2014-03-20 22:08	chelipf	Triggers an Emergency Pack	=> No