Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0016852Openbravo ERP07. Sales managementpublic2011-04-19 15:202012-04-02 06:09
Reporterroklenardic 
Assigned Todmiguelez 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version3.0RC5 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0016852: Logo does not print on Draft invoices
DescriptionWhen a Sales Invoice is in draft status, printing it to a PDF does not render the logo regardless of the ShowLogo setting.

This happens because the C_Invoice table has two columns:
1) c_doctype_id
2_ c_doctypetarget_id

and the first one (c_doctype_id) is only filled in after completing an invoice and the RptC_Invoice.jrxml joins by the first one:

LEFT JOIN C_POC_DOCTYPE_TEMPLATE ON C_POC_DOCTYPE_TEMPLATE.C_DOCTYPE_ID = C_INVOICE.C_DOCTYPE_ID,
Steps To Reproduce
Proposed Solutionchange the join so that it joins by c_doctypetarget_id


LEFT JOIN C_POC_DOCTYPE_TEMPLATE ON C_POC_DOCTYPE_TEMPLATE.C_DOCTYPE_ID = C_INVOICE.C_DOCTYPETARGET_ID,
Additional Information
TagsOB3-Reviewed, VMA-Reviewed
Relationships
has duplicate defect 0019099 closed vmromanos Logo does not appear in JR when printing documents (i.e. invoices) in Draft status 
related to defect 0019967pi closed dmiguelez Logo does not print on Draft orders 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2011-04-19 15:20roklenardicNew Issue
2011-04-19 15:20roklenardicAssigned To => adrianromero
2011-04-19 15:20roklenardicModules => Core
2011-04-19 15:20roklenardicOBNetwork customer => No
2011-06-03 10:58dalsasuaAssigned Toadrianromero => dalsasua
2011-07-20 18:16dalsasuaAssigned Todalsasua => jonalegriaesarte
2011-10-29 17:34psarobeTag Attached: OB3-Reviewed
2011-10-29 17:34psarobeStatusnew => scheduled
2011-10-29 17:34psarobefix_in_branch => pi
2012-02-15 19:04iciordiaAssigned Tojonalegriaesarte => vmromanos
2012-02-16 17:19vmromanosTag Attached: VMA-Reviewed
2012-03-05 11:31dmiguelezAssigned Tovmromanos => dmiguelez
2012-03-05 16:22dmiguelezNote Added: 0046048
2012-03-06 17:33dmiguelezRelationship addedrelated to 0019967
2012-03-12 18:19hgbotCheckin
2012-03-12 18:19hgbotNote Added: 0046292
2012-03-12 18:19hgbotStatusscheduled => resolved
2012-03-12 18:19hgbotResolutionopen => fixed
2012-03-12 18:19hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/bd164e45643627071280182feae6bd232c8d0a03 [^]
2012-03-14 13:44vmromanosNote Added: 0046399
2012-03-14 13:44vmromanosStatusresolved => closed
2012-04-02 06:09hudsonbotCheckin
2012-04-02 06:09hudsonbotNote Added: 0047101
2012-04-10 17:14vmromanosRelationship addedhas duplicate 0019099

Notes
(0046048)
dmiguelez   
2012-03-05 16:22   
Test plan:

- Login as F&B International Group Admin.
- Create a new Sales Invoice with at least one Line.
- Print it without completing it. Notice that the Company Logo appears.
(0046292)
hgbot   
2012-03-12 18:19   
Repository: erp/devel/pi
Changeset: bd164e45643627071280182feae6bd232c8d0a03
Author: David Miguelez <david.miguelez <at> openbravo.com>
Date: Wed Mar 07 18:30:38 2012 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/bd164e45643627071280182feae6bd232c8d0a03 [^]

Fixes issue 16852: Changed join sentence in SQL query.

---
M src/org/openbravo/erpReports/RptC_Invoice.jrxml
---
(0046399)
vmromanos   
2012-03-14 13:44   
code review + testing OK
(0047101)
hudsonbot   
2012-04-02 06:09   
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/7814864461ac [^]

Maturity status: Test