Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0011726 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] Z. Others | major | always | 2009-12-10 12:42 | 2009-12-30 00:00 | |||
| Reporter | psarobe | View Status | public | |||||
| Assigned To | adrianromero | |||||||
| Priority | urgent | Resolution | fixed | Fixed in Version | 2.50MP10 | |||
| Status | closed | Fix in branch | pi | Fixed in SCM revision | 2c53410f2df8 | |||
| Projection | none | ETA | none | Target Version | 2.50MP10 | |||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | 2.50MP9 | SCM revision | ||||||
| Merge Request Status | ||||||||
| Review Assigned To | ||||||||
| OBNetwork customer | No | |||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Support ticket | ||||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0011726: Document types: Implement default feature for every window | |||||||
| Description | Right 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 Reproduce | 1. 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 Solution | The 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 | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
|
(0022754) hgbot (developer) 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 (developer) 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 (viewer) 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 (viewer) 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 (developer) 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 (viewer) 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 (developer) 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 (developer) 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 (viewer) 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 (viewer) 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 (viewer) 2009-12-29 13:10 |
QA done by Eng development team |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2009-12-10 12:42 | psarobe | New Issue | |
| 2009-12-10 12:42 | psarobe | Assigned To | => adrianromero |
| 2009-12-10 12:42 | psarobe | OBNetwork customer | => No |
| 2009-12-10 12:42 | psarobe | Status | new => scheduled |
| 2009-12-10 12:42 | psarobe | fix_in_branch | => pi |
| 2009-12-14 13:56 | hgbot | Checkin | |
| 2009-12-14 13:56 | hgbot | Note Added: 0022754 | |
| 2009-12-14 13:56 | hgbot | Status | scheduled => resolved |
| 2009-12-14 13:56 | hgbot | Resolution | open => fixed |
| 2009-12-14 13:56 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/eddb3ac7021a5f6df877d61dadd04598fd72a6e5 [^] |
| 2009-12-14 13:56 | hgbot | Checkin | |
| 2009-12-14 13:56 | hgbot | Note Added: 0022756 | |
| 2009-12-14 13:56 | hgbot | Fixed in SCM revision | http://code.openbravo.com/erp/devel/pi/rev/eddb3ac7021a5f6df877d61dadd04598fd72a6e5 [^] => http://code.openbravo.com/erp/devel/pi/rev/30243ebe164814b4f760cb85c8fe837767de6f06 [^] |
| 2009-12-14 13:58 | mirurita | Note Added: 0022757 | |
| 2009-12-15 08:58 | hudsonbot | Checkin | |
| 2009-12-15 08:58 | hudsonbot | Note Added: 0022801 | |
| 2009-12-15 12:37 | hgbot | Checkin | |
| 2009-12-15 12:37 | hgbot | Note Added: 0022833 | |
| 2009-12-15 12:37 | hgbot | Fixed in SCM revision | http://code.openbravo.com/erp/devel/pi/rev/30243ebe164814b4f760cb85c8fe837767de6f06 [^] => http://code.openbravo.com/erp/devel/pi/rev/46cd75072c4cb78a37a02f510ad052a97aecc968 [^] |
| 2009-12-16 16:47 | hudsonbot | Checkin | |
| 2009-12-16 16:47 | hudsonbot | Note Added: 0022875 | |
| 2009-12-17 09:50 | hgbot | Checkin | |
| 2009-12-17 09:50 | hgbot | Note Added: 0022903 | |
| 2009-12-17 09:50 | hgbot | Fixed in SCM revision | http://code.openbravo.com/erp/devel/pi/rev/46cd75072c4cb78a37a02f510ad052a97aecc968 [^] => http://code.openbravo.com/erp/devel/pi/rev/b874140fb68c2ab4941b6c7ee2ed3214041ffe25 [^] |
| 2009-12-17 10:16 | hgbot | Checkin | |
| 2009-12-17 10:16 | hgbot | Note Added: 0022905 | |
| 2009-12-17 10:16 | hgbot | Fixed in SCM revision | http://code.openbravo.com/erp/devel/pi/rev/b874140fb68c2ab4941b6c7ee2ed3214041ffe25 [^] => http://code.openbravo.com/erp/devel/pi/rev/2c53410f2df81bcb37d01f6ea4ca234f86e9d801 [^] |
| 2009-12-19 00:36 | hudsonbot | Checkin | |
| 2009-12-19 00:36 | hudsonbot | Note Added: 0022953 | |
| 2009-12-19 00:36 | hudsonbot | Checkin | |
| 2009-12-19 00:36 | hudsonbot | Note Added: 0022955 | |
| 2009-12-29 13:10 | psarobe | Note Added: 0023139 | |
| 2009-12-29 13:10 | psarobe | Status | resolved => closed |
| 2009-12-29 13:10 | psarobe | Fixed in Version | => 2.50MP10 |
| 2009-12-30 00:00 | anonymous | sf_bug_id | 0 => 2923119 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |