Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0011726Openbravo ERPZ. Otherspublic2009-12-10 12:422009-12-30 00:00
Reporterpsarobe 
Assigned Toadrianromero 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.50MP9 
Target Version2.50MP10Fixed in Version2.50MP10 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0011726: Document types: Implement default feature for every window
DescriptionRight now when you define a document as default is not working if others document types are also defined as default. For each window there is defined the document types that you will be able to select in the combo box.
This is configured in the application using validations

The solution to implement this seems to be very easy. Add "order by" clause in the validation
Steps To Reproduce1. Login Openbravo/openbravo as system administrator
2. Go to Application dictionary->Tables and columns
3. Select the table c_invoice
4. Move to columns and select the column transactional type
5. Enter in form view and click in the validation
Proposed SolutionThe validations that need to be changed are:

1. Table: C_INVOICE
2. Table: C_ORDER
3. Table: M_INOUT
4. Table: A_AMORTIZATION
5. Table: C_BANKSTATEMENT
6. Table: C_CASHJOURNAL
7. Table: C_DP_MANAGEMENT
8. Table: GL_JOURNAL
9. Table: C_SETTLEMENT
10. Table: M_MOVEMENT
11. Table: M_INVENTORY
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-12-10 12:42psarobeNew Issue
2009-12-10 12:42psarobeAssigned To => adrianromero
2009-12-10 12:42psarobeStatusnew => scheduled
2009-12-10 12:42psarobefix_in_branch => pi
2009-12-14 13:56hgbotCheckin
2009-12-14 13:56hgbotNote Added: 0022754
2009-12-14 13:56hgbotStatusscheduled => resolved
2009-12-14 13:56hgbotResolutionopen => fixed
2009-12-14 13:56hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/eddb3ac7021a5f6df877d61dadd04598fd72a6e5 [^]
2009-12-14 13:56hgbotCheckin
2009-12-14 13:56hgbotNote Added: 0022756
2009-12-14 13:56hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/eddb3ac7021a5f6df877d61dadd04598fd72a6e5 [^] => http://code.openbravo.com/erp/devel/pi/rev/30243ebe164814b4f760cb85c8fe837767de6f06 [^]
2009-12-14 13:58miruritaNote Added: 0022757
2009-12-15 08:58hudsonbotCheckin
2009-12-15 08:58hudsonbotNote Added: 0022801
2009-12-15 12:37hgbotCheckin
2009-12-15 12:37hgbotNote Added: 0022833
2009-12-15 12:37hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/30243ebe164814b4f760cb85c8fe837767de6f06 [^] => http://code.openbravo.com/erp/devel/pi/rev/46cd75072c4cb78a37a02f510ad052a97aecc968 [^]
2009-12-16 16:47hudsonbotCheckin
2009-12-16 16:47hudsonbotNote Added: 0022875
2009-12-17 09:50hgbotCheckin
2009-12-17 09:50hgbotNote Added: 0022903
2009-12-17 09:50hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/46cd75072c4cb78a37a02f510ad052a97aecc968 [^] => http://code.openbravo.com/erp/devel/pi/rev/b874140fb68c2ab4941b6c7ee2ed3214041ffe25 [^]
2009-12-17 10:16hgbotCheckin
2009-12-17 10:16hgbotNote Added: 0022905
2009-12-17 10:16hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/b874140fb68c2ab4941b6c7ee2ed3214041ffe25 [^] => http://code.openbravo.com/erp/devel/pi/rev/2c53410f2df81bcb37d01f6ea4ca234f86e9d801 [^]
2009-12-19 00:36hudsonbotCheckin
2009-12-19 00:36hudsonbotNote Added: 0022953
2009-12-19 00:36hudsonbotCheckin
2009-12-19 00:36hudsonbotNote Added: 0022955
2009-12-29 13:10psarobeNote Added: 0023139
2009-12-29 13:10psarobeStatusresolved => closed
2009-12-29 13:10psarobeFixed in Version => 2.50MP10
2009-12-30 00:00anonymoussf_bug_id0 => 2923119

Notes
(0022754)
hgbot   
2009-12-14 13:56   
Repository: erp/devel/pi
Changeset: eddb3ac7021a5f6df877d61dadd04598fd72a6e5
Author: Mikel Irurita <mikel.irurita <at> openbravo.com>
Date: Thu Dec 10 19:19:24 2009 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/eddb3ac7021a5f6df877d61dadd04598fd72a6e5 [^]

Fixes issue 0011726: Document types: Implement default feature for every window

---
M src-db/database/sourcedata/AD_COLUMN.xml
M src-db/database/sourcedata/AD_REF_TABLE.xml
---
(0022756)
hgbot   
2009-12-14 13:56   
Repository: erp/devel/pi
Changeset: 30243ebe164814b4f760cb85c8fe837767de6f06
Author: Mikel Irurita <mikel.irurita <at> openbravo.com>
Date: Mon Dec 14 12:22:42 2009 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/30243ebe164814b4f760cb85c8fe837767de6f06 [^]

Fixes issue 0011726: Document types: Implement default feature for every window

---
M src-db/database/sourcedata/AD_COLUMN.xml
M src-db/database/sourcedata/AD_REF_TABLE.xml
---
(0022757)
mirurita   
2009-12-14 13:58   
The solution consist of adding a ORDER BY clause to order document types by isdefault column descending.

Affected tables:

* C_Invoice(C_DocTypeTarget_ID)
+Added an ORDER BY clause to C_DocType Table Reference: C_DocType.isdefault DESC

* C_Order(C_DocTypeTarget_ID)
+Added an ORDER BY clause to C_DocType Table Reference: C_DocType.isdefault DESC

* M_InOut(C_DocType_ID)
+Added an ORDER BY clause to C_DocType Table Reference: C_DocType.isdefault DESC

*C_DP_Management(C_DocType_ID)
+Change the reference to Table: C_DocType

*C_ExternalPOS(C_DocType_ID)
+Change the reference to Table: C_DocType

*C_Settlement(C_DocType_ID)
+Added ORDER BY clause to the default value of the column:
@SQL=SELECT C_DocType_ID from C_DocType WHERE AD_ISORGINCLUDED(@AD_Org_ID@,C_DocType.AD_Org_ID, @#AD_Client_ID@) <> -1 AND C_DocType.DocBaseType=@DOCTYPE_SETTLEMENT@ ORDER BY C_DocType.isdefault DESC

*GL_Journal(C_DocType_ID)
+Already has a default value.
(0022801)
hudsonbot   
2009-12-15 08:58   
---
A changeset related to this issue has been promoted to main after passing a series of tests and an OBX has been generated:

Changeset: http://code.openbravo.com/erp/devel/main/rev/d8660a4ab9a7 [^]
Tests: http://builds.openbravo.com/view/devel-int/ [^]
OBX: http://builds.openbravo.com/erp/obx/core/OpenbravoERP-2.50CI.15731.obx [^]
---
(0022833)
hgbot   
2009-12-15 12:37   
Repository: erp/devel/pi
Changeset: 46cd75072c4cb78a37a02f510ad052a97aecc968
Author: Mikel Irurita <mikel.irurita <at> openbravo.com>
Date: Tue Dec 15 11:43:13 2009 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/46cd75072c4cb78a37a02f510ad052a97aecc968 [^]

Fixes issue 0011726: Document types: * organization problem with combo reload

---
M src-db/database/sourcedata/AD_REF_TABLE.xml
---
(0022875)
hudsonbot   
2009-12-16 16:47   
---
A changeset related to this issue has been promoted to main after passing a series of tests and an OBX has been generated:

Changeset: http://code.openbravo.com/erp/devel/main/rev/46cd75072c4c [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/1767de909fe7 [^]
Tests: http://builds.openbravo.com/view/devel-int/ [^]
OBX: http://builds.openbravo.com/erp/obx/core/OpenbravoERP-2.50CI.15751.obx [^]
---
(0022903)
hgbot   
2009-12-17 09:50   
Repository: erp/devel/pi
Changeset: b874140fb68c2ab4941b6c7ee2ed3214041ffe25
Author: Mikel Irurita <mikel.irurita <at> openbravo.com>
Date: Thu Dec 17 09:49:43 2009 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/b874140fb68c2ab4941b6c7ee2ed3214041ffe25 [^]

Fixes issue 0011726: Document types. Added new table reference C_DocType_Trx

---
M src-db/database/sourcedata/AD_COLUMN.xml
M src-db/database/sourcedata/AD_REFERENCE.xml
M src-db/database/sourcedata/AD_REF_TABLE.xml
---
(0022905)
hgbot   
2009-12-17 10:16   
Repository: erp/devel/pi
Changeset: 2c53410f2df81bcb37d01f6ea4ca234f86e9d801
Author: Mikel Irurita <mikel.irurita <at> openbravo.com>
Date: Thu Dec 17 10:15:57 2009 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/2c53410f2df81bcb37d01f6ea4ca234f86e9d801 [^]

Fixes issue 11726: Document Type for C_ExternalPOS table

---
M src-db/database/sourcedata/AD_COLUMN.xml
---
(0022953)
hudsonbot   
2009-12-19 00:36   
---
A changeset related to this issue has been promoted to main after passing a series of tests and an OBX has been generated:

Changeset: http://code.openbravo.com/erp/devel/main/rev/b874140fb68c [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/867059305a34 [^]
Tests: http://builds.openbravo.com/view/devel-int/ [^]
OBX: http://builds.openbravo.com/erp/obx/core/OpenbravoERP-2.50CI.15773.obx [^]
---
(0022955)
hudsonbot   
2009-12-19 00:36   
---
A changeset related to this issue has been promoted to main after passing a series of tests and an OBX has been generated:

Changeset: http://code.openbravo.com/erp/devel/main/rev/2c53410f2df8 [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/867059305a34 [^]
Tests: http://builds.openbravo.com/view/devel-int/ [^]
OBX: http://builds.openbravo.com/erp/obx/core/OpenbravoERP-2.50CI.15773.obx [^]
---
(0023139)
psarobe   
2009-12-29 13:10   
QA done by Eng development team