Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0005196 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| backport | [Openbravo ERP] 00. Application dictionary | major | always | 2008-09-23 13:01 | 2009-01-25 19:22 | |||
| Reporter | galderromo | View Status | public | |||||
| Assigned To | alostale | |||||||
| Priority | high | Resolution | fixed | Fixed in Version | 2.40MP2 | |||
| Status | closed | Fix in branch | 2.40 | Fixed in SCM revision | 11164 | |||
| Projection | none | ETA | none | Target Version | ||||
| OS | Linux 32 bit | Database | Oracle | Java version | 1.5.0_15 | |||
| OS Version | Gentoo 2.6.24 | Database version | XE | Ant version | 1.7 | |||
| Product Version | SCM revision | |||||||
| Review Assigned To | ||||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0005196: Doc sequences and database restrictions | |||||||
| Description | Right now, when working with Sales Invoices, WAD generated code updates the document's sequence before is sure the invoice has been created. This way it is possible to update the sequence but not to create the record due to database restrictions. This issue is critica because can generate sequence jumps on Sales Invoices, which is ilegal. In some how, this request is related to 4439 and 5054. | |||||||
| Steps To Reproduce | Suppose you do not want the user to create an invoice with no c_project_id or not user1_id. So you create on the database this restriction (there is no way to do it through the AP). Then, when you press the SAVE button, the WAD generated code updates the sequence and later inserts the record on the database. But the restriction avoids this inserting, so the sequence has been lost. | |||||||
| Proposed Solution | Change the sequence control, and make sure the inserting has been properly done, before updating the sequence. | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|||||||||||||||
|
|||||||||||||||
 Relationships |
|
Notes |
|
|
(0010850) svnbot (reporter) 2008-12-01 15:58 |
Repository: openbravo Revision: 10793 Author: alostale Date: 2008-12-01 15:58:20 +0100 (Mon, 01 Dec 2008) fixed bug 0005196: Doc sequences and database restrictions --- U branches/r2.40/src/org/openbravo/erpCommon/utility/DocumentNo_data.xsql U branches/r2.40/src/org/openbravo/erpCommon/utility/Utility.java U branches/r2.40/src-wad/src/org/openbravo/wad/Wad.java U branches/r2.40/src-wad/src/org/openbravo/wad/datasource.xsqlxml U branches/r2.40/src-wad/src/org/openbravo/wad/javasource.javaxml --- https://dev.openbravo.com/websvn/openbravo/?rev=10793&sc=1 [^] |
|
(0010891) svnbot (reporter) 2008-12-02 15:51 |
Repository: openbravo Revision: 10866 Author: villind Date: 2008-12-02 15:51:50 +0100 (Tue, 02 Dec 2008) Merged r10793. fixed bug 0005196: Doc sequences and database restrictions --- _U branches/bonware/r2.40/ _U branches/bonware/r2.40/config/setup-tool/ _U branches/bonware/r2.40/eclipse.install.source.launch _U branches/bonware/r2.40/export.database.launch U branches/bonware/r2.40/src/org/openbravo/erpCommon/utility/DocumentNo_data.xsql U branches/bonware/r2.40/src/org/openbravo/erpCommon/utility/Utility.java _U branches/bonware/r2.40/src-core/src/org/openbravo/database/OpenbravoDriverManagerConnectionFactory.java U branches/bonware/r2.40/src-wad/src/org/openbravo/wad/Wad.java U branches/bonware/r2.40/src-wad/src/org/openbravo/wad/datasource.xsqlxml U branches/bonware/r2.40/src-wad/src/org/openbravo/wad/javasource.javaxml _U branches/bonware/r2.40/update.database.launch --- https://dev.openbravo.com/websvn/openbravo/?rev=10866&sc=1 [^] |
|
(0011256) svnbot (reporter) 2008-12-12 16:15 |
Repository: openbravo Revision: 11164 Author: rafaroda Date: 2008-12-12 16:15:01 +0100 (Fri, 12 Dec 2008) Fixes bug 0005196 Made fix PotgreSQL compatible --- U branches/r2.40/src/org/openbravo/erpCommon/utility/DocumentNo_data.xsql --- https://dev.openbravo.com/websvn/openbravo/?rev=11164&sc=1 [^] |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2008-09-23 13:01 | cromero | New Issue | |
| 2008-09-23 13:01 | cromero | Assigned To | => alostale |
| 2008-09-23 13:01 | cromero | Status | new => scheduled |
| 2008-12-01 15:58 | svnbot | Checkin | |
| 2008-12-01 15:58 | svnbot | Note Added: 0010850 | |
| 2008-12-01 15:58 | svnbot | Status | scheduled => resolved |
| 2008-12-01 15:58 | svnbot | Resolution | open => fixed |
| 2008-12-01 15:58 | svnbot | svn_revision | => 10793 |
| 2008-12-02 15:51 | svnbot | Checkin | |
| 2008-12-02 15:51 | svnbot | Note Added: 0010891 | |
| 2008-12-02 15:51 | svnbot | svn_revision | 10793 => 10866 |
| 2008-12-12 16:15 | svnbot | Checkin | |
| 2008-12-12 16:15 | svnbot | Note Added: 0011256 | |
| 2008-12-12 16:15 | svnbot | svn_revision | 10866 => 11164 |
| 2008-12-12 16:56 | shuehner | Relationship added | related to 0006395 |
| 2009-01-25 19:22 | psarobe | Regression testing | => No |
| 2009-01-25 19:22 | psarobe | Status | resolved => closed |
| 2009-01-25 19:22 | psarobe | Fixed in Version | => 2.40 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |