Notes |
|
|
It's correct that puts you 0 as m_attributesetvale_id. As you should know m_attributesetvale_id='0' means that the product has no vaue. The reason is because you didn't select any value for that product in the purchase order.
Said this, I imagine that because you have setup medium as value in the product window you were expected to have "medium" as value.
Can you confirm this? What were you expected to happen?
Thanks |
|
|
|
Changed its Priority to Urgent. |
|
|
|
|
|
|
|
|
(0024096)
|
hgbot
|
2010-02-10 13:28
|
|
Repository: erp/devel/pi
Changeset: 82a53e088c45390f918270b016e7f6791daf756f
Author: Rafa Roda Palacios <rafael.roda <at> openbravo.com>
Date: Thu Jan 28 00:55:50 2010 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/82a53e088c45390f918270b016e7f6791daf756f [^]
Issue 11513 Added 'Attribute Set Value Required' check-box field to Product window.
---
M src-db/database/model/tables/M_PRODUCT.xml
M src-db/database/sourcedata/AD_COLUMN.xml
M src-db/database/sourcedata/AD_ELEMENT.xml
M src-db/database/sourcedata/AD_FIELD.xml
---
|
|
|
(0024097)
|
hgbot
|
2010-02-10 13:28
|
|
Repository: erp/devel/pi
Changeset: 8c8099881972797081730f1e168b4fcf7a5ee215
Author: Rafa Roda Palacios <rafael.roda <at> openbravo.com>
Date: Thu Jan 28 03:50:17 2010 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/8c8099881972797081730f1e168b4fcf7a5ee215 [^]
Issue 11513 Added 'Default Attribute Set Value' check-box field to Product window.
---
M src-db/database/model/tables/M_PRODUCT.xml
M src-db/database/sourcedata/AD_COLUMN.xml
M src-db/database/sourcedata/AD_ELEMENT.xml
M src-db/database/sourcedata/AD_FIELD.xml
---
|
|
|
(0024098)
|
hgbot
|
2010-02-10 13:28
|
|
Repository: erp/devel/pi
Changeset: bcced774e9913b4cd7fea51253cb26fd62871ea4
Author: Rafa Roda Palacios <rafael.roda <at> openbravo.com>
Date: Thu Jan 28 10:09:10 2010 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/bcced774e9913b4cd7fea51253cb26fd62871ea4 [^]
Issue 11513 Reverted 'Attribute Set Value Required' and 'Default Attribute Set Value'.
---
M src-db/database/model/tables/M_PRODUCT.xml
M src-db/database/sourcedata/AD_COLUMN.xml
M src-db/database/sourcedata/AD_ELEMENT.xml
M src-db/database/sourcedata/AD_FIELD.xml
---
|
|
|
(0024099)
|
hgbot
|
2010-02-10 13:28
|
|
Repository: erp/devel/pi
Changeset: fdbb6ea24247a87d8054752dc161d3a990f3ca35
Author: Rafa Roda Palacios <rafael.roda <at> openbravo.com>
Date: Thu Jan 28 12:32:12 2010 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/fdbb6ea24247a87d8054752dc161d3a990f3ca35 [^]
Issue 11513 Modified 'Attribute Set Value' field position and display logic.
---
M src-db/database/sourcedata/AD_COLUMN.xml
M src-db/database/sourcedata/AD_FIELD.xml
---
|
|
|
(0024100)
|
hgbot
|
2010-02-10 13:28
|
|
Repository: erp/devel/pi
Changeset: d77e43abfbde6c095d51e6cb8fa25dd311fc8eaa
Author: Rafa Roda Palacios <rafael.roda <at> openbravo.com>
Date: Thu Jan 28 12:42:09 2010 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/d77e43abfbde6c095d51e6cb8fa25dd311fc8eaa [^]
Issue 11513 Added 'Attribute Set Value Type' drop-down field to the Product window.
---
M src-db/database/model/tables/M_PRODUCT.xml
M src-db/database/sourcedata/AD_COLUMN.xml
M src-db/database/sourcedata/AD_ELEMENT.xml
M src-db/database/sourcedata/AD_FIELD.xml
M src-db/database/sourcedata/AD_MESSAGE.xml
M src-db/database/sourcedata/AD_REFERENCE.xml
M src-db/database/sourcedata/AD_REF_LIST.xml
---
|
|
|
(0024101)
|
hgbot
|
2010-02-10 13:28
|
|
Repository: erp/devel/pi
Changeset: 7fdc424ecf415bba6f216729800faafaf7ba953e
Author: Rafa Roda Palacios <rafael.roda <at> openbravo.com>
Date: Thu Jan 28 14:31:33 2010 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/7fdc424ecf415bba6f216729800faafaf7ba953e [^]
Issue 11513 Triggers and procedures evaluate now ATTRSETVALUETYPE column of M_PRODUCT table.
---
M src-db/database/model/functions/MA_WORKEFFORT_VALIDATE.xml
M src-db/database/model/functions/M_INOUT_POST.xml
M src-db/database/model/functions/M_INTERNAL_CONSUMPTION_POST.xml
M src-db/database/model/functions/M_INVENTORY_POST.xml
M src-db/database/model/functions/M_MOVEMENT_POST.xml
M src-db/database/model/functions/M_PRODUCTION_RUN.xml
M src-db/database/model/triggers/M_TRANSACTION_TRG.xml
---
|
|
|
(0024102)
|
hgbot
|
2010-02-10 13:29
|
|
Repository: erp/devel/pi
Changeset: 0058d622f6cc5e3af93665407da0e10525b69b15
Author: Rafa Roda Palacios <rafael.roda <at> openbravo.com>
Date: Tue Feb 02 15:45:24 2010 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/0058d622f6cc5e3af93665407da0e10525b69b15 [^]
Issue 11513 Modified triggers, display logics, selectors and callouts in order to use attribute set value types 'Default' and 'Fixed'.
---
M src-db/database/model/triggers/A_ASSET_TRG.xml
M src-db/database/model/triggers/C_INVOICELINE_TRG.xml
M src-db/database/model/triggers/C_ORDERLINE_TRG2.xml
M src-db/database/model/triggers/M_INOUTLINE_TRG.xml
M src-db/database/model/triggers/M_INTERNAL_CONSUMPTIONLINE_TRG.xml
M src-db/database/model/triggers/M_INVENTORYLINE_TRG.xml
M src-db/database/model/triggers/M_MOVEMENTLINE_TRG.xml
M src-db/database/model/triggers/M_PRODUCTIONLINE_TRG.xml
M src-db/database/model/triggers/M_TRANSACTION_TRG.xml
M src-db/database/sourcedata/AD_AUXILIARINPUT.xml
M src-db/database/sourcedata/AD_CALLOUT.xml
M src-db/database/sourcedata/AD_COLUMN.xml
M src-db/database/sourcedata/AD_FIELD.xml
M src-db/database/sourcedata/AD_MESSAGE.xml
M src-db/database/sourcedata/AD_MODEL_OBJECT.xml
M src-db/database/sourcedata/AD_MODEL_OBJECT_MAPPING.xml
M src/org/openbravo/erpCommon/ad_callouts/SL_GlobalUse_Product.java
M src/org/openbravo/erpCommon/ad_callouts/SL_InOutLine_Product.java
M src/org/openbravo/erpCommon/ad_callouts/SL_Internal_Consumption_Product.java
M src/org/openbravo/erpCommon/ad_callouts/SL_Inventory_Product.java
M src/org/openbravo/erpCommon/ad_callouts/SL_Invoice_Product.java
M src/org/openbravo/erpCommon/ad_callouts/SL_Movement_Product.java
M src/org/openbravo/erpCommon/ad_callouts/SL_Order_Product.java
M src/org/openbravo/erpCommon/ad_callouts/SL_Production_Product.java
M src/org/openbravo/erpCommon/ad_callouts/SL_RequisitionLine_Product.java
M src/org/openbravo/erpCommon/businessUtility/PAttributeSet_data.xsql
M src/org/openbravo/erpCommon/info/ProductComplete_data.xsql
A src-db/database/model/triggers/MA_GLOBALUSE_TRG.xml
A src-db/database/model/triggers/MA_PC_CASE_TRG.xml
A src-db/database/model/triggers/M_REQUISITIONLINE_TRG2.xml
A src-db/database/model/triggers/M_STORAGE_DETAIL_TRG.xml
A src/org/openbravo/erpCommon/ad_callouts/SL_Asset_Product.java
A src/org/openbravo/erpCommon/ad_callouts/SL_PC_Case_Product.java
---
|
|
|
(0024103)
|
hgbot
|
2010-02-10 13:29
|
|
Repository: erp/devel/pi
Changeset: e990915dce93649c36a449cd6c1873030fe8c5fc
Author: Rafa Roda Palacios <rafael.roda <at> openbravo.com>
Date: Tue Feb 02 20:59:42 2010 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/e990915dce93649c36a449cd6c1873030fe8c5fc [^]
Issue 11513 Callouts clean-up.
---
M src/org/openbravo/erpCommon/ad_callouts/SL_Asset_Product.java
M src/org/openbravo/erpCommon/ad_callouts/SL_InOutLine_Product.java
M src/org/openbravo/erpCommon/ad_callouts/SL_PC_Case_Product.java
---
|
|
|
(0024104)
|
hgbot
|
2010-02-10 13:29
|
|
Repository: erp/devel/pi
Changeset: cc053601d7e16031773d47352ed8d3a248666157
Author: Rafa Roda Palacios <rafael.roda <at> openbravo.com>
Date: Tue Feb 02 21:02:39 2010 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/cc053601d7e16031773d47352ed8d3a248666157 [^]
Issue 11513 Modified 'Create/Post Production' and 'Create Standards' processes in order to mind 'Attribute Set Value Type' value.
---
M src-db/database/model/functions/MA_PRODUCTIONRUN_STANDARD.xml
M src-db/database/model/functions/M_PRODUCTION_RUN.xml
---
|
|
|
(0024105)
|
hgbot
|
2010-02-10 13:30
|
|
Repository: erp/devel/pi
Changeset: f95d45b1de1081f5a0da33dbb64079d771b6463b
Author: Rafa Roda Palacios <rafael.roda <at> openbravo.com>
Date: Tue Feb 02 21:08:19 2010 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/f95d45b1de1081f5a0da33dbb64079d771b6463b [^]
Issue 11513 Triggers messaging and triggering clean-up.
---
M src-db/database/model/triggers/A_ASSET_TRG.xml
M src-db/database/model/triggers/C_INVOICELINE_TRG.xml
M src-db/database/model/triggers/C_ORDERLINE_TRG2.xml
M src-db/database/model/triggers/MA_GLOBALUSE_TRG.xml
M src-db/database/model/triggers/MA_PC_CASE_TRG.xml
M src-db/database/model/triggers/M_INOUTLINE_TRG.xml
M src-db/database/model/triggers/M_INTERNAL_CONSUMPTIONLINE_TRG.xml
M src-db/database/model/triggers/M_INVENTORYLINE_TRG.xml
M src-db/database/model/triggers/M_MOVEMENTLINE_TRG.xml
M src-db/database/model/triggers/M_PRODUCTIONLINE_TRG.xml
M src-db/database/model/triggers/M_REQUISITIONLINE_TRG2.xml
M src-db/database/model/triggers/M_STORAGE_DETAIL_TRG.xml
M src-db/database/model/triggers/M_TRANSACTION_TRG.xml
M src-db/database/sourcedata/AD_MESSAGE.xml
---
|
|
|
(0024106)
|
hgbot
|
2010-02-10 13:30
|
|
Repository: erp/devel/pi
Changeset: fc92bf96363a5989241d5dab03e25b2724fc8b1b
Author: Rafa Roda Palacios <rafael.roda <at> openbravo.com>
Date: Tue Feb 02 21:16:24 2010 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/fc92bf96363a5989241d5dab03e25b2724fc8b1b [^]
Issue 11513 Resolves database inconsistencies.
---
M src-db/database/sourcedata/AD_COLUMN.xml
M src-db/database/sourcedata/AD_ELEMENT.xml
M src-db/database/sourcedata/AD_FIELD.xml
M src-db/database/sourcedata/AD_PROCESS_PARA.xml
M src-db/database/sourcedata/AD_REFERENCE.xml
---
|
|
|
(0024107)
|
hgbot
|
2010-02-10 13:30
|
|
Repository: erp/devel/pi
Changeset: b1887cd30523f4251d7b6d55d249c4121c1f92fa
Author: Rafa Roda Palacios <rafael.roda <at> openbravo.com>
Date: Wed Feb 03 22:55:48 2010 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/b1887cd30523f4251d7b6d55d249c4121c1f92fa [^]
Issue 11513 Changed 'Attribute Set Value Type' label by 'Use Attribute Set Value As'.
---
M src-db/database/sourcedata/AD_COLUMN.xml
M src-db/database/sourcedata/AD_ELEMENT.xml
M src-db/database/sourcedata/AD_FIELD.xml
---
|
|
|
(0024108)
|
hgbot
|
2010-02-10 13:30
|
|
Repository: erp/devel/pi
Changeset: 3b83864e518e8cd849614e17c27faa31db480088
Author: Rafa Roda Palacios <rafael.roda <at> openbravo.com>
Date: Wed Feb 03 22:57:58 2010 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/3b83864e518e8cd849614e17c27faa31db480088 [^]
Issue 11513 Renamed 'Fixed' to 'Specification' and added 'Overwrite Specification' list value.
---
M src-db/database/sourcedata/AD_REFERENCE.xml
M src-db/database/sourcedata/AD_REF_LIST.xml
---
|
|
|
(0024109)
|
hgbot
|
2010-02-10 13:30
|
|
Repository: erp/devel/pi
Changeset: de65edc16ba8b0378c43b3a923acd06ace3769d9
Author: Rafa Roda Palacios <rafael.roda <at> openbravo.com>
Date: Wed Feb 03 23:00:50 2010 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/de65edc16ba8b0378c43b3a923acd06ace3769d9 [^]
Issue 11513 Added onCreateDefault to ATTRSETVALUETYPE column and modified M_PRODUCT_ATSETVALTYPE_CHK constraint and message.
---
M src-db/database/model/tables/M_PRODUCT.xml
M src-db/database/sourcedata/AD_MESSAGE.xml
---
|
|
|
(0024110)
|
hgbot
|
2010-02-10 13:30
|
|
Repository: erp/devel/pi
Changeset: 2acb489b0711aca5b0233e04d5ea986f57cb9287
Author: Rafa Roda Palacios <rafael.roda <at> openbravo.com>
Date: Thu Feb 04 12:06:43 2010 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/2acb489b0711aca5b0233e04d5ea986f57cb9287 [^]
Issue 11513 Added 'Require At Least One Value' check-box field to 'Attribute Set' tab.
---
M src-db/database/model/tables/M_ATTRIBUTESET.xml
M src-db/database/sourcedata/AD_COLUMN.xml
M src-db/database/sourcedata/AD_ELEMENT.xml
M src-db/database/sourcedata/AD_FIELD.xml
---
|
|
|
(0024111)
|
hgbot
|
2010-02-10 13:30
|
|
Repository: erp/devel/pi
Changeset: 925aac33a0e83c3c5765e8481678631555ab47a4
Author: Rafa Roda Palacios <rafael.roda <at> openbravo.com>
Date: Thu Feb 04 16:26:11 2010 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/925aac33a0e83c3c5765e8481678631555ab47a4 [^]
Issue 11513 Addition of display logic based on the attribute set.
---
M src-db/database/sourcedata/AD_AUXILIARINPUT.xml
M src-db/database/sourcedata/AD_FIELD.xml
M src-db/database/sourcedata/AD_MESSAGE.xml
M src/org/openbravo/erpCommon/ad_callouts/SL_Asset_Product.java
M src/org/openbravo/erpCommon/ad_callouts/SL_GlobalUse_Product.java
M src/org/openbravo/erpCommon/ad_callouts/SL_InOutLine_Product.java
M src/org/openbravo/erpCommon/ad_callouts/SL_Internal_Consumption_Product.java
M src/org/openbravo/erpCommon/ad_callouts/SL_Inventory_Product.java
M src/org/openbravo/erpCommon/ad_callouts/SL_Invoice_Product.java
M src/org/openbravo/erpCommon/ad_callouts/SL_Movement_Product.java
M src/org/openbravo/erpCommon/ad_callouts/SL_Order_Product.java
M src/org/openbravo/erpCommon/ad_callouts/SL_PC_Case_Product.java
M src/org/openbravo/erpCommon/ad_callouts/SL_Production_Product.java
M src/org/openbravo/erpCommon/ad_callouts/SL_RequisitionLine_Product.java
---
|
|
|
(0024112)
|
hgbot
|
2010-02-10 13:30
|
|
Repository: erp/devel/pi
Changeset: 8c7df5839019c3bd3c0c78e030cdb4e46927233b
Author: Rafa Roda Palacios <rafael.roda <at> openbravo.com>
Date: Thu Feb 04 20:15:31 2010 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/8c7df5839019c3bd3c0c78e030cdb4e46927233b [^]
Issue 11513 Modified Attribute Set Value selector in order to display message when the attribute set value type is Specification.
---
M src-db/database/sourcedata/AD_MESSAGE.xml
M src/org/openbravo/erpCommon/info/AttributeSetInstance.java
---
|
|
|
(0024113)
|
hgbot
|
2010-02-10 13:31
|
|
Repository: erp/devel/pi
Changeset: 9f7a291d9e072d0338d3b98521f8bdb14603d7aa
Author: Rafa Roda Palacios <rafael.roda <at> openbravo.com>
Date: Thu Feb 04 20:18:49 2010 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/9f7a291d9e072d0338d3b98521f8bdb14603d7aa [^]
Issue 11513 Modified the check of the product attribute set value in the completion procedures.
---
M src-db/database/model/functions/MA_WORKEFFORT_VALIDATE.xml
M src-db/database/model/functions/M_INOUT_POST.xml
M src-db/database/model/functions/M_INTERNAL_CONSUMPTION_POST.xml
M src-db/database/model/functions/M_INVENTORY_POST.xml
M src-db/database/model/functions/M_MOVEMENT_POST.xml
M src-db/database/model/functions/M_PRODUCTION_RUN.xml
M src-db/database/model/triggers/M_TRANSACTION_TRG.xml
---
|
|
|
(0024114)
|
hgbot
|
2010-02-10 13:31
|
|
Repository: erp/devel/pi
Changeset: 7b7e3e610909200401259a62280abdfde3c350ec
Author: Rafa Roda Palacios <rafael.roda <at> openbravo.com>
Date: Mon Feb 08 09:24:07 2010 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/7b7e3e610909200401259a62280abdfde3c350ec [^]
Issue 11513 Resolves null pointer exception error in the Attribute Set Value selector.
---
M src/org/openbravo/erpCommon/info/AttributeSetInstance.java
---
|
|
|
(0024115)
|
hgbot
|
2010-02-10 13:31
|
|
Repository: erp/devel/pi
Changeset: e6d965c38a0c32f75a3d8fcafef1f7a730071851
Author: Rafa Roda Palacios <rafael.roda <at> openbravo.com>
Date: Mon Feb 08 19:13:28 2010 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/e6d965c38a0c32f75a3d8fcafef1f7a730071851 [^]
Issue 11513 Issue 12170 Added extra display logic to the Attribute Set Value field.
---
M src-db/database/sourcedata/AD_AUXILIARINPUT.xml
M src-db/database/sourcedata/AD_COLUMN.xml
M src-db/database/sourcedata/AD_FIELD.xml
---
|
|
|
(0024117)
|
hgbot
|
2010-02-10 13:31
|
|
Repository: erp/devel/pi
Changeset: 588712b441100a17b9c84220e19e32b080ca4492
Author: Rafa Roda Palacios <rafael.roda <at> openbravo.com>
Date: Mon Feb 08 19:15:20 2010 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/588712b441100a17b9c84220e19e32b080ca4492 [^]
Issue 11513 Added onCreateDefault value to ISONEATTRSETVALREQUIRED column of M_ATTRIBUTESET table.
---
M src-db/database/model/tables/M_ATTRIBUTESET.xml
---
|
|
|
(0024119)
|
hgbot
|
2010-02-10 13:31
|
|
Repository: erp/devel/pi
Changeset: d566f894014b6224f5065b6cf0599d244acf69b0
Author: Rafa Roda Palacios <rafael.roda <at> openbravo.com>
Date: Mon Feb 08 22:29:59 2010 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/d566f894014b6224f5065b6cf0599d244acf69b0 [^]
Issue 12168 Issue 11513 Added logic to M_PRODUCT trigger in order to avoid setting wrong attribute set values in the Product tab.
---
M src-db/database/model/triggers/M_PRODUCT_TRG.xml
M src-db/database/sourcedata/AD_MESSAGE.xml
---
|
|
|
(0024120)
|
hgbot
|
2010-02-10 13:31
|
|
|
|
(0024149)
|
rafaroda
|
2010-02-11 09:29
(edited on: 2010-02-11 09:36) |
|
Project has been merged back to pi.
Have a look at the Functional Specification http://wiki.openbravo.com/wiki/Projects/Attribute_set_instance_review#Functional_Requirements_Based_on_Business_Processes [^]
If you had some Attribute Set Value defined in the Product tab, it has been given the type Default (ATTRSETVALUETYPE = 'D'). If you want to change it to:
* Specification:
UPDATE M_PRODUCT SET ATTRSETVALUETYPE = 'F'
WHERE M_ATTRIBUTESETINSTANCE_ID IS NOT NULL
* Overwrite Specification:
UPDATE M_PRODUCT SET ATTRSETVALUETYPE = 'O'
WHERE M_ATTRIBUTESETINSTANCE_ID IS NOT NULL
You can check the data with:
SELECT NAME, M_ATTRIBUTESET_ID, M_ATTRIBUTESETINSTANCE_ID, ATTRSETVALUETYPE
FROM M_PRODUCT ORDER BY UPDATED DESC
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|