Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0009141Openbravo ERP09. Financial managementpublic2009-05-22 12:502009-08-03 16:24
Reporterpmagnin 
Assigned Todalsasua 
PriorityimmediateSeverityminorReproducibilityhave not tried
StatusclosedResolutionno change required 
PlatformOS5OS Version
Product Version2.50 
Target Version2.50Fixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0009141: Invoice number lost in GL Report
DescriptionThe Invoice number is lost in the GL Report after posting the bank statement. The Settlement has this information, the GL Report should have it as well.

This is also a Blatem requirement with High priority.

This issue exists in 2.50 and 2.40
Backport needed.
Steps To Reproduce
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 00078612.35MP5 closed dalsasua Select clause in Bank Statement's description doesn't get the correct line value for General Ledger Report 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-05-22 12:50pmagninNew Issue
2009-05-22 12:50pmagninAssigned To => dalsasua
2009-05-22 13:24dalsasuaStatusnew => scheduled
2009-05-22 13:24dalsasuafix_in_branch => pi
2009-05-22 13:28dalsasuaStatusscheduled => closed
2009-05-22 13:28dalsasuaNote Added: 0016580
2009-05-22 13:28dalsasuaResolutionopen => no change required
2009-05-23 00:00anonymoussf_bug_id0 => 2795622
2009-08-03 16:24rafarodaRelationship addedrelated to 0007861

Notes
(0016580)
dalsasua   
2009-05-22 13:28   
This is the behavior of the application, because Report Cash Flow needs this two different descriptions to work. As proposed in 7924 bug, a work arround consists of building a customized description in accountign schema -> tables -> c_bankstatement -> SQL Description ->
SELECT 'Extracto: ' || C_BANKSTATEMENT.NAME || ' - ' || C_BANKSTATEMENTLINE.LINE || ' - ' || NVL(C_DEBT_PAYMENT.DESCRIPTION,C_BPARTNER.NAME) FROM C_BANKSTATEMENT,C_BANKSTATEMENTLINE, C_DEBT_PAYMENT, C_BPARTNER WHERE C_BANKSTATEMENT.C_BANKSTATEMENT_ID = C_BANKSTATEMENTLINE.C_BANKSTATEMENT_ID AND C_BANKSTATEMENTLINE.C_DEBT_PAYMENT_ID = C_DEBT_PAYMENT.C_DEBT_PAYMENT_ID AND C_DEBT_PAYMENT.C_BPARTNER_ID = C_BPARTNER.C_BPARTNER_ID AND C_BANKSTATEMENT.C_BANKSTATEMENT_ID = @RecordId@ AND C_BANKSTATEMENTLINE.C_BANKSTATEMENTLINE_ID = @Line@

Regards,