Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0020015 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] 07. Sales management | minor | always | 2012-03-14 01:48 | 2012-04-17 05:31 | |||
| Reporter | chelipf | View Status | public | |||||
| Assigned To | Sandrahuguet | |||||||
| Priority | normal | Resolution | fixed | Fixed in Version | ||||
| Status | closed | Fix in branch | pi | Fixed in SCM revision | b4a79546b9e5 | |||
| Projection | none | ETA | none | Target Version | ||||
| OS | Linux 64 bit | Database | PostgreSQL | Java version | 1.6.0_23 | |||
| OS Version | Database version | 8.4.9 | Ant version | 1.8.2 | ||||
| Product Version | 2.50MP33.1 | SCM revision | ||||||
| Review Assigned To | ||||||||
| Web browser | Mozilla Firefox | |||||||
| Modules | Core | |||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0020015: Create Lines From in Sales invoices doesn't set Excludeforwithholding field properly | |||||||
| Description | Excludeforwithholding column of C_INVOICELINE table is a boolean column and it must only accept Y or N values. When "creating lines from" is processed, Excludeforwithholding is set to null. | |||||||
| Steps To Reproduce | - Create a new sales invoice header. - Push create lines from button. | |||||||
| Proposed Solution | - Set Excludeforwithholding column as "not null". - Create a new constraint in order to Excludeforwithholding only accepts Y or N values. - Fix Create Lines From process in order to set Excludeforwithholding to N instead to null. | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||
|
||||||||
 Relationships |
|
Notes |
|
|
(0046436) chelipf (reporter) 2012-03-15 00:35 edited on: 2012-04-04 15:50 |
The same thing happens for purchase invoice. It is related to 0020038 issue. |
|
(0047392) Sandrahuguet (developer) 2012-04-04 16:24 |
Test Plan: Go to Sales Invoice - Create a new sales invoice - Click in Create Lines From And you can see Excludeforwithholding is 'N' |
|
(0047496) vmromanos (manager) 2012-04-12 10:00 |
Test Plan: Go to Sales Invoice - Create a new sales invoice - Click in Create Lines From - Select any order previously created - Select any line of this order - Press OK button Query the database and verify Excludeforwithholding is 'N' The field associated with this column is never shown in the application, so there is no reason for changing the API and creating a module script to fix previous data |
|
(0047503) hgbot (developer) 2012-04-12 10:53 |
Repository: erp/devel/pi Changeset: b4a79546b9e58541ae8798c6d6b91892aa6cb75c Author: Sandra Huguet <sandra.huguet <at> openbravo.com> Date: Wed Apr 04 15:04:25 2012 +0200 URL: http://code.openbravo.com/erp/devel/pi/rev/b4a79546b9e58541ae8798c6d6b91892aa6cb75c [^] Fixed issue 20015 Set Excludeforwithholding to N instead to null Set Excludeforwithholding to N instead to null in c_invoiceline table --- M src/org/openbravo/erpCommon/ad_actionButton/CreateFrom_Invoice_data.xsql --- |
|
(0047504) vmromanos (manager) 2012-04-12 10:53 |
code review + testing OK |
|
(0047632) hudsonbot (developer) 2012-04-17 05:31 |
A changeset related to this issue has been promoted main and to the Central Repository, after passing a series of tests. Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/cedf57621434 [^] Maturity status: Test |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2012-03-14 01:48 | chelipf | New Issue | |
| 2012-03-14 01:48 | chelipf | Assigned To | => vmromanos |
| 2012-03-14 01:48 | chelipf | Web browser | => Mozilla Firefox |
| 2012-03-14 01:48 | chelipf | Modules | => Core |
| 2012-03-15 00:35 | chelipf | Note Added: 0046436 | |
| 2012-03-15 01:12 | chelipf | Issue Monitored: chelipf | |
| 2012-04-04 13:17 | Sandrahuguet | Assigned To | vmromanos => Sandrahuguet |
| 2012-04-04 13:17 | Sandrahuguet | Status | new => scheduled |
| 2012-04-04 13:17 | Sandrahuguet | fix_in_branch | => pi |
| 2012-04-04 15:50 | chelipf | Note Edited: 0046436 | View Revisions |
| 2012-04-04 15:50 | chelipf | Note Edited: 0046436 | View Revisions |
| 2012-04-04 15:59 | Sandrahuguet | Relationship added | related to 0020038 |
| 2012-04-04 16:02 | Sandrahuguet | Relationship deleted | related to 0020038 |
| 2012-04-04 16:24 | Sandrahuguet | Note Added: 0047392 | |
| 2012-04-12 09:42 | vmromanos | Relationship added | related to 0020038 |
| 2012-04-12 10:00 | vmromanos | Note Added: 0047496 | |
| 2012-04-12 10:53 | hgbot | Checkin | |
| 2012-04-12 10:53 | hgbot | Note Added: 0047503 | |
| 2012-04-12 10:53 | hgbot | Status | scheduled => resolved |
| 2012-04-12 10:53 | hgbot | Resolution | open => fixed |
| 2012-04-12 10:53 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/b4a79546b9e58541ae8798c6d6b91892aa6cb75c [^] |
| 2012-04-12 10:53 | vmromanos | Note Added: 0047504 | |
| 2012-04-12 10:53 | vmromanos | Status | resolved => closed |
| 2012-04-17 05:31 | hudsonbot | Checkin | |
| 2012-04-17 05:31 | hudsonbot | Note Added: 0047632 | |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |