Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0019967
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 07. Sales managementminoralways2012-03-06 17:322012-04-02 06:09
ReporterdmiguelezView Statuspublic 
Assigned Todmiguelez 
PrioritynormalResolutionfixedFixed in Version
StatusclosedFix in branchpiFixed in SCM revisiona8628d0d3e00
ProjectionnoneETAnoneTarget Versionpi
OSLinux 32 bitDatabasePostgreSQLJava version1.6.0_18
OS VersionCommunity ApplianceDatabase version8.3.9Ant version1.7.1
Product VersionSCM revision 
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
Summary

0019967: Logo does not print on Draft orders

DescriptionWhen a Sales Order is in draft status, printing it to a PDF does not render the logo regardless of the ShowLogo setting.

This happens because the C_Order 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 order 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_ORDER.C_DOCTYPE_ID,
Steps To Reproduce- Login as Openbravo/openbravo
- Create a new Sales Order and try print it before competing it.
- Notice that the image is not shown.
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_ORDER.C_DOCTYPETARGET_ID,
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to defect 0016852 closeddmiguelez Logo does not print on Draft invoices 

-  Notes
(0046149)
dmiguelez (viewer)
2012-03-07 18:17

 Test plan:

- Login as F&B International Group Admin.
- Create a new Sales Order with at least one Line.
- Print it without completing it. Notice that the Company Logo appears.
(0046291)
hgbot (developer)
2012-03-12 18:19

 Repository: erp/devel/pi
Changeset: a8628d0d3e0040bc6c9b26d98339c9d055cc11e1
Author: David Miguelez <david.miguelez <at> openbravo.com>
Date: Wed Mar 07 18:31:46 2012 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/a8628d0d3e0040bc6c9b26d98339c9d055cc11e1 [^]

Fixes issue 0019967: Changed join sentece in query.

---
M src/org/openbravo/erpReports/C_OrderJR.jrxml
M src/org/openbravo/erpReports/RptC_OrderPO.jrxml
---
(0046400)
vmromanos (viewer)
2012-03-14 13:44

 code review + testing OK
(0047100)
hudsonbot (viewer)
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

- Issue History
Date Modified Username Field Change
2012-03-06 17:32 dmiguelez New Issue
2012-03-06 17:32 dmiguelez Assigned To => dmiguelez
2012-03-06 17:32 dmiguelez Modules => Core
2012-03-06 17:32 dmiguelez OBNetwork customer => No
2012-03-06 17:33 dmiguelez Status new => scheduled
2012-03-06 17:33 dmiguelez fix_in_branch => pi
2012-03-06 17:33 dmiguelez Relationship added related to 0016852
2012-03-07 18:17 dmiguelez Note Added: 0046149
2012-03-12 18:19 hgbot Checkin
2012-03-12 18:19 hgbot Note Added: 0046291
2012-03-12 18:19 hgbot Status scheduled => resolved
2012-03-12 18:19 hgbot Resolution open => fixed
2012-03-12 18:19 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/a8628d0d3e0040bc6c9b26d98339c9d055cc11e1 [^]
2012-03-14 13:44 vmromanos Note Added: 0046400
2012-03-14 13:44 vmromanos Status resolved => closed
2012-04-02 06:09 hudsonbot Checkin
2012-04-02 06:09 hudsonbot Note Added: 0047100

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker