Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0009294Openbravo ERP07. Sales managementpublic2009-06-02 13:172009-06-06 00:00
psarobe 
gmauleon 
immediatemajorhave not tried
closedfixed 
5
pi 
pi 
Core
No
0009294: Happens in Postgres. The description of the payment is null after completing an invoice
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
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

The documentno must appear in postgres

About what should be present inside () I don't have any suggestions
No tags attached.
Issue History
2009-06-02 13:17psarobeNew Issue
2009-06-02 13:17psarobeAssigned To => rafaroda
2009-06-02 13:18psarobeStatusnew => scheduled
2009-06-02 13:18psarobefix_in_branch => pi
2009-06-02 14:37rafarodaNote Added: 0016872
2009-06-02 14:37rafarodaStatusscheduled => feedback
2009-06-02 16:11psarobefix_in_branchpi =>
2009-06-02 16:11psarobeProposed Solution updated
2009-06-02 16:11psarobeSteps to Reproduce Updated
2009-06-02 16:11psarobeStatusfeedback => scheduled
2009-06-02 16:11psarobefix_in_branch => pi
2009-06-02 16:14rafarodaAssigned Torafaroda => gmauleon
2009-06-02 16:14rafarodafix_in_branchpi =>
2009-06-02 16:14rafarodaDescription Updated
2009-06-03 13:38hgbotCheckin
2009-06-03 13:38hgbotNote Added: 0016916
2009-06-03 13:38hgbotStatusscheduled => resolved
2009-06-03 13:38hgbotResolutionopen => fixed
2009-06-03 13:38hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/2ea030117f07e56979ddc643999af82a6b59f2e3 [^]
2009-06-03 16:00jreymolNote Added: 0016922
2009-06-03 18:25hgbotCheckin
2009-06-03 18:25hgbotNote Added: 0016925
2009-06-03 18:25hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/2ea030117f07e56979ddc643999af82a6b59f2e3 [^] => http://code.openbravo.com/erp/devel/pi/rev/140e6c4cca1953e848dd9fb05d379351128034c2 [^]
2009-06-05 07:44sureshbabuStatusresolved => closed
2009-06-05 07:44sureshbabuNote Added: 0016976
2009-06-05 07:44sureshbabuFixed in Version => pi
2009-06-06 00:00anonymoussf_bug_id0 => 2802048

Notes
(0016872)
rafaroda   
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   
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   
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   
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   
2009-06-05 07:44   
Now the description is filled with "* <invoice document number * ( )"