From a8659d996d4fff0d11275c0772f93ff53470dce2 Mon Sep 17 00:00:00 2001
From: jetxarri <javier.echarri@openbravo.com>
Date: Thu, 9 Sep 2021 11:55:47 +0200
Subject: [PATCH] Fixes issue NOE-4807: Do not allow to select product
 categories that are summary in tab product category and window Discounts and
 promotions

---
 src-db/database/sourcedata/AD_COLUMN.xml   |  1 +
 src-db/database/sourcedata/AD_VAL_RULE.xml | 12 ++++++++++++
 2 files changed, 13 insertions(+)

diff --git a/src-db/database/sourcedata/AD_COLUMN.xml b/src-db/database/sourcedata/AD_COLUMN.xml
index 788f4d6f2e..9ddc833886 100644
--- a/src-db/database/sourcedata/AD_COLUMN.xml
+++ b/src-db/database/sourcedata/AD_COLUMN.xml
@@ -165082,6 +165082,7 @@ Usually, company's internal identifiers for various records (products, customers
 <!--801162-->  <COLUMNNAME><![CDATA[M_Product_Category_ID]]></COLUMNNAME>
 <!--801162-->  <AD_TABLE_ID><![CDATA[800066]]></AD_TABLE_ID>
 <!--801162-->  <AD_REFERENCE_ID><![CDATA[19]]></AD_REFERENCE_ID>
+<!--801162-->  <AD_VAL_RULE_ID><![CDATA[B0259CE5E9FA4FF2BD309FAF56540008]]></AD_VAL_RULE_ID>
 <!--801162-->  <FIELDLENGTH><![CDATA[12]]></FIELDLENGTH>
 <!--801162-->  <ISKEY><![CDATA[N]]></ISKEY>
 <!--801162-->  <ISPARENT><![CDATA[N]]></ISPARENT>
diff --git a/src-db/database/sourcedata/AD_VAL_RULE.xml b/src-db/database/sourcedata/AD_VAL_RULE.xml
index 15ad732b06..1ca320f58c 100644
--- a/src-db/database/sourcedata/AD_VAL_RULE.xml
+++ b/src-db/database/sourcedata/AD_VAL_RULE.xml
@@ -2133,6 +2133,18 @@ or (@AD_Module_ID@ is not null and AD_User_ID =  '0')]]></CODE>
 <!--AC836223DC6B4F0D905B087F2BAA5A75-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
 <!--AC836223DC6B4F0D905B087F2BAA5A75--></AD_VAL_RULE>
 
+<!--B0259CE5E9FA4FF2BD309FAF56540008--><AD_VAL_RULE>
+<!--B0259CE5E9FA4FF2BD309FAF56540008-->  <AD_VAL_RULE_ID><![CDATA[B0259CE5E9FA4FF2BD309FAF56540008]]></AD_VAL_RULE_ID>
+<!--B0259CE5E9FA4FF2BD309FAF56540008-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--B0259CE5E9FA4FF2BD309FAF56540008-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--B0259CE5E9FA4FF2BD309FAF56540008-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--B0259CE5E9FA4FF2BD309FAF56540008-->  <NAME><![CDATA[Only allow leaf categories]]></NAME>
+<!--B0259CE5E9FA4FF2BD309FAF56540008-->  <DESCRIPTION><![CDATA[Only allow leaf categories]]></DESCRIPTION>
+<!--B0259CE5E9FA4FF2BD309FAF56540008-->  <TYPE><![CDATA[S]]></TYPE>
+<!--B0259CE5E9FA4FF2BD309FAF56540008-->  <CODE><![CDATA[Issummary = 'N']]></CODE>
+<!--B0259CE5E9FA4FF2BD309FAF56540008-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--B0259CE5E9FA4FF2BD309FAF56540008--></AD_VAL_RULE>
+
 <!--B0B962BC60AE4BF18F811EF818D8F138--><AD_VAL_RULE>
 <!--B0B962BC60AE4BF18F811EF818D8F138-->  <AD_VAL_RULE_ID><![CDATA[B0B962BC60AE4BF18F811EF818D8F138]]></AD_VAL_RULE_ID>
 <!--B0B962BC60AE4BF18F811EF818D8F138-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
-- 
2.31.0