Openbravo Issue Tracking System - Openbravo ERP |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0009294 | Openbravo ERP | 07. Sales management | public | 2009-06-02 13:17 | 2009-06-06 00:00 |
|
| Reporter | psarobe | |
| Assigned To | gmauleon | |
| Priority | immediate | Severity | major | Reproducibility | have not tried |
| Status | closed | Resolution | fixed | |
| Platform | | OS | 5 | OS Version | |
| Product Version | pi | |
| Target Version | | Fixed in Version | pi | |
| 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 |
| Additional Information | |
| Tags | No tags attached. |
| Relationships | |
| Attached Files | |
|
| 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 |
|
Notes |
|
|
|
Pablo,
Please inform about what should be the correct behavior and the steps to reproduce the issue.
Thanks. |
|
|
|
(0016916)
|
|
hgbot
|
|
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
---
|
|
|
|
|
maybe is intended but:
COALESCE('' ,v_BPartnerName)
will always produce '' regardless v_BPartnerName.
maybe developer wanted to write:
COALESCE(v_BPartnerName,'')
regards, |
|
|
|
(0016925)
|
|
hgbot
|
|
2009-06-03 18:25
|
|
|
|
|
|
|
Now the description is filled with "* <invoice document number * ( )" |
|