Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0009294 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] 07. Sales management | major | have not tried | 2009-06-02 13:17 | 2009-06-06 00:00 | |||
| Reporter | psarobe | View Status | public | |||||
| Assigned To | gmauleon | |||||||
| Priority | immediate | Resolution | fixed | Fixed in Version | pi | |||
| Status | closed | Fix in branch | Fixed in SCM revision | 140e6c4cca19 | ||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Any | Database | PostgreSQL | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | pi | SCM revision | ||||||
| Merge Request Status | ||||||||
| Review Assigned To | ||||||||
| OBNetwork customer | OBPS | |||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Support ticket | ||||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0009294: Happens in Postgres. The description of the payment is null after completing an invoice | |||||||
| Description | When you complete an invoice, the erp creates a payment. The description of that payment is filled with a null value and this is wrong. In Oracle it does not happen. But what it happens in oracle is that it fills the description with the value of the documentno but also puts you (). Foe example 12099(). This is also strange. So please review the postgre behavior and the oracle behavior | |||||||
| Steps To Reproduce | 1. Login 2. Go to Sales management->Transactions->Sales invoice 3. Create an invoice with lines 4. Complete the invoice. Move to Payment tab 5. No description is filled. This is wrong | |||||||
| Proposed Solution | The documentno must appear in postgres About what should be present inside () I don't have any suggestions | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
|
(0016872) rafaroda (viewer) 2009-06-02 14:37 |
Pablo, Please inform about what should be the correct behavior and the steps to reproduce the issue. Thanks. |
|
(0016916) hgbot (developer) 2009-06-03 13:38 |
Repository: erp/devel/pi Changeset: 2ea030117f07e56979ddc643999af82a6b59f2e3 Author: Gorka Mauleon <gorka.mauleon <at> openbravo.com> Date: Wed Jun 03 13:38:20 2009 +0200 URL: http://code.openbravo.com/erp/devel/pi/rev/2ea030117f07e56979ddc643999af82a6b59f2e3 [^] fixes bug 0009294: Happens in Postgres. The description of the payment is null after completing an invoice --- M src-db/database/model/functions/C_INVOICE_POST.xml --- |
|
(0016922) jreymol (viewer) 2009-06-03 16:00 |
maybe is intended but: COALESCE('' ,v_BPartnerName) will always produce '' regardless v_BPartnerName. maybe developer wanted to write: COALESCE(v_BPartnerName,'') regards, |
|
(0016925) hgbot (developer) 2009-06-03 18:25 |
Repository: erp/devel/pi Changeset: 140e6c4cca1953e848dd9fb05d379351128034c2 Author: Gorka Mauleon <gorka.mauleon <at> openbravo.com> Date: Wed Jun 03 18:25:31 2009 +0200 URL: http://code.openbravo.com/erp/devel/pi/rev/140e6c4cca1953e848dd9fb05d379351128034c2 [^] related to issue 9294 The description of the payment is null after completing an invoice --- M src-db/database/model/functions/C_INVOICE_POST.xml --- |
|
(0016976) sureshbabu (viewer) 2009-06-05 07:44 |
Now the description is filled with "* <invoice document number * ( )" |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2009-06-02 13:17 | psarobe | New Issue | |
| 2009-06-02 13:17 | psarobe | Assigned To | => rafaroda |
| 2009-06-02 13:17 | psarobe | OBNetwork customer | => Yes |
| 2009-06-02 13:18 | psarobe | Status | new => scheduled |
| 2009-06-02 13:18 | psarobe | fix_in_branch | => pi |
| 2009-06-02 14:37 | rafaroda | Note Added: 0016872 | |
| 2009-06-02 14:37 | rafaroda | Status | scheduled => feedback |
| 2009-06-02 16:11 | psarobe | fix_in_branch | pi => |
| 2009-06-02 16:11 | psarobe | Proposed Solution updated | |
| 2009-06-02 16:11 | psarobe | Steps to Reproduce Updated | |
| 2009-06-02 16:11 | psarobe | Status | feedback => scheduled |
| 2009-06-02 16:11 | psarobe | fix_in_branch | => pi |
| 2009-06-02 16:14 | rafaroda | Assigned To | rafaroda => gmauleon |
| 2009-06-02 16:14 | rafaroda | fix_in_branch | pi => |
| 2009-06-02 16:14 | rafaroda | Description Updated | |
| 2009-06-03 13:38 | hgbot | Checkin | |
| 2009-06-03 13:38 | hgbot | Note Added: 0016916 | |
| 2009-06-03 13:38 | hgbot | Status | scheduled => resolved |
| 2009-06-03 13:38 | hgbot | Resolution | open => fixed |
| 2009-06-03 13:38 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/2ea030117f07e56979ddc643999af82a6b59f2e3 [^] |
| 2009-06-03 16:00 | jreymol | Note Added: 0016922 | |
| 2009-06-03 18:25 | hgbot | Checkin | |
| 2009-06-03 18:25 | hgbot | Note Added: 0016925 | |
| 2009-06-03 18:25 | hgbot | Fixed in SCM revision | http://code.openbravo.com/erp/devel/pi/rev/2ea030117f07e56979ddc643999af82a6b59f2e3 [^] => http://code.openbravo.com/erp/devel/pi/rev/140e6c4cca1953e848dd9fb05d379351128034c2 [^] |
| 2009-06-05 07:44 | sureshbabu | Status | resolved => closed |
| 2009-06-05 07:44 | sureshbabu | Note Added: 0016976 | |
| 2009-06-05 07:44 | sureshbabu | Fixed in Version | => pi |
| 2009-06-06 00:00 | anonymous | sf_bug_id | 0 => 2802048 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |