Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0017584Openbravo ERP07. Sales managementpublic2011-06-09 18:092012-01-02 14:58
ReporterAlex76 
Assigned Tojonalegriaesarte 
PrioritynormalSeveritymajorReproducibilityalways
StatusnewResolutionopen 
PlatformOS20OS VersionCommunity Appliance
Product Version2.50MP26 
Target VersionFixed 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
Summary0017584: Report don't use print format from countries
DescriptionHi

the 2.50 version don't use the field print format in the country definition for the reports. On the Invoice the printformat is with regions to long.

for example:

A-2380 Perchtoldsdorf (Niederösterreich)

The only work around is to change the RptC_Invoice.jrxml and the stored procedure for the location base string.

but i think this field sould to a format for printing, so this is a big bug.

the regions can not be used.
Steps To Reproduce
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Filesxml C_LOCATION_DESCRIPTION.xml (2,307) 2011-06-09 19:11
https://issues.openbravo.com/file_download.php?file_id=4180&type=bug
? RptC_Invoice.jrxml (24,453) 2011-06-09 19:12
https://issues.openbravo.com/file_download.php?file_id=4181&type=bug
? RptC_Invoice_Lines.jrxml (16,471) 2011-06-09 19:12
https://issues.openbravo.com/file_download.php?file_id=4182&type=bug
Issue History
Date ModifiedUsernameFieldChange
2011-06-09 18:09Alex76New Issue
2011-06-09 18:09Alex76Assigned To => dalsasua
2011-06-09 18:09Alex76Modules => Core
2011-06-09 18:12Alex76Tag Attached: 2.50MP26
2011-06-09 18:13shuehnerNote Added: 0038204
2011-06-09 18:13shuehnerversion => 2.50MP26
2011-06-09 18:13shuehnerTag Detached: 2.50MP26
2011-06-09 18:14shuehnerIssue Monitored: shuehner
2011-06-09 19:11Alex76Note Added: 0038206
2011-06-09 19:11Alex76File Added: C_LOCATION_DESCRIPTION.xml
2011-06-09 19:12Alex76File Added: RptC_Invoice.jrxml
2011-06-09 19:12Alex76File Added: RptC_Invoice_Lines.jrxml
2011-06-11 19:50Alex76Note Added: 0038272
2011-07-05 19:20dmitry_mezentsevNote Added: 0038801
2011-07-05 19:20dmitry_mezentsevSeveritycritical => major
2011-07-05 19:20dmitry_mezentsevTarget Version => 3.0MP2
2011-07-20 18:09dalsasuaAssigned Todalsasua => jonalegriaesarte
2011-08-01 13:47dmitry_mezentsevNote Added: 0039576
2011-08-01 13:47dmitry_mezentsevTarget Version3.0MP2 => 3.0MP3
2011-08-31 11:08jonalegriaesarteNote Added: 0040584
2011-08-31 11:08jonalegriaesarteTarget Version3.0MP3 => 3.0MP4
2011-10-04 10:32jonalegriaesarteNote Added: 0041479
2011-10-04 10:32jonalegriaesarteTarget Version3.0MP4 => 3.0MP5
2011-10-31 11:57jonalegriaesarteNote Added: 0042399
2011-10-31 11:57jonalegriaesarteTarget Version3.0MP5 => 3.0MP6
2011-11-25 17:25jonalegriaesarteNote Added: 0043358
2011-11-25 17:25jonalegriaesarteTarget Version3.0MP6 => 3.0MP7
2012-01-02 14:58jonalegriaesarteTarget Version3.0MP7 =>

Notes
(0038204)
shuehner   
2011-06-09 18:13   
Adding product version as noted by reporter.
(0038206)
Alex76   
2011-06-09 19:11   
Location stored precedure workaround.
(0038272)
Alex76   
2011-06-11 19:50   
Here is the SQL without the Stored Procedure and it works too (with Query String and Field definition):


    <queryString>
        <![CDATA[SELECT C_INVOICE.C_INVOICE_ID, C_BPARTNER.NAME, C_BPARTNER.TAXID AS CIF, AD_USER.NAME AS CONTACT_NAME, C_LOCATION.ADDRESS1,
C_LOCATION.POSTAL, C_LOCATION.CITY, C_REGION.NAME AS REGION,C_COUNTRY.NAME AS COUNTRY,C_BPARTNER_LOCATION.PHONE AS PHONE, C_BPARTNER_LOCATION.FAX AS FAX,
C_INVOICE.DATEINVOICED, C_INVOICE.DOCUMENTNO, C_BPARTNER.VALUE AS CODE_BPARTNER,
AD_CLIENT.DESCRIPTION AS ENTITY, AD_ORG_LOCATION.ADDRESS1 AS AD_ORG_ADDRESS1, AD_ORG_LOCATION.POSTAL AS AD_ORG_POSTAL, AD_ORG_LOCATION.CITY AS AD_ORG_CITY, AD_ORG_REGION.NAME AS AD_ORG_REGION_NAME, AD_ORG_COUNTRY.NAME AS AD_ORG_COUNTRY_NAME, C_CURRENCY.ISO_CODE AS CURRENCY_CODE,C_CURRENCY.CURSYMBOL AS SYMBOL,
C_PAYMENTTERM.NAME AS PAYTERM, AD_ORGINFO.ad_org_id AS ORGANIZATIONID, C_INVOICE.docstatus AS STATUS, AD_ORG.NAME AS ORG_NAME, AD_ORGINFO.TAXID AS ORG_TAXID,
C_BPARTNER.TAXID AS BP_TAXID, SHOWLOGO, SHOWCOMPANYDATA, HEADERMARGIN
FROM C_INVOICE
     LEFT JOIN C_BPARTNER ON C_INVOICE.C_BPARTNER_ID = C_BPARTNER.C_BPARTNER_ID
     LEFT JOIN AD_USER ON C_INVOICE.AD_USER_ID = AD_USER.AD_USER_ID
     LEFT JOIN C_BPARTNER_LOCATION ON C_INVOICE.C_BPARTNER_LOCATION_ID = C_BPARTNER_LOCATION.C_BPARTNER_LOCATION_ID
     LEFT JOIN C_LOCATION ON C_BPARTNER_LOCATION.C_LOCATION_ID = C_LOCATION.C_LOCATION_ID
     LEFT JOIN C_REGION ON C_LOCATION.C_REGION_ID = C_REGION.C_REGION_ID
     LEFT JOIN C_COUNTRY ON C_LOCATION.C_COUNTRY_ID = C_COUNTRY.C_COUNTRY_ID
     LEFT JOIN C_PAYMENTTERM ON C_INVOICE.C_PAYMENTTERM_ID = C_PAYMENTTERM.C_PAYMENTTERM_ID
     LEFT JOIN C_CURRENCY ON C_INVOICE.C_CURRENCY_ID = C_CURRENCY.C_CURRENCY_ID
     LEFT JOIN AD_ORG ON AD_ORG.ad_org_id = (SELECT o.AD_ORG_ID FROM AD_ORG o JOIN AD_OrgType t USING (AD_ORGTYPE_ID) WHERE AD_ISORGINCLUDED(C_INVOICE.AD_ORG_ID, o.ad_org_id, C_INVOICE.ad_client_id)<>-1 AND (t.IsLegalEntity='Y' OR t.IsAcctLegalEntity='Y'))
     LEFT JOIN AD_ORGINFO ON AD_ORG.ad_org_id = AD_ORGINFO.ad_org_id
     LEFT JOIN AD_CLIENT ON C_INVOICE.ad_client_id = AD_CLIENT.ad_client_id
     LEFT JOIN C_LOCATION AD_ORG_LOCATION ON AD_ORG_LOCATION.C_LOCATION_ID = AD_ORGINFO.C_LOCATION_ID
     LEFT JOIN C_REGION AD_ORG_REGION ON AD_ORG_LOCATION.C_REGION_ID=AD_ORG_REGION.C_REGION_ID
     LEFT JOIN C_COUNTRY AD_ORG_COUNTRY ON AD_ORG_LOCATION.C_COUNTRY_ID = AD_ORG_COUNTRY.C_COUNTRY_ID
     LEFT JOIN C_POC_DOCTYPE_TEMPLATE ON C_POC_DOCTYPE_TEMPLATE.C_DOCTYPE_ID = C_INVOICE.C_DOCTYPE_ID


WHERE C_INVOICE.C_INVOICE_ID IN ($P{DOCUMENT_ID})
]]>
    </queryString>
    <field name="C_INVOICE_ID" class="java.lang.String"/>
    <field name="NAME" class="java.lang.String"/>
    <field name="CIF" class="java.lang.String"/>
    <field name="CONTACT_NAME" class="java.lang.String"/>
    <field name="ADDRESS1" class="java.lang.String"/>
    <field name="POSTAL" class="java.lang.String"/>
    <field name="CITY" class="java.lang.String"/>
    <field name="REGION" class="java.lang.String"/>
    <field name="COUNTRY" class="java.lang.String"/>
    <field name="AD_ORG_ADDRESS1" class="java.lang.String"/>
    <field name="AD_ORG_POSTAL" class="java.lang.String"/>
    <field name="AD_ORG_CITY" class="java.lang.String"/>
    <field name="AD_ORG_REGION_NAME" class="java.lang.String"/>
    <field name="AD_ORG_COUNTRY_NAME" class="java.lang.String"/>
    <field name="PHONE" class="java.lang.String"/>
    <field name="FAX" class="java.lang.String"/>
    <field name="DATEINVOICED" class="java.util.Date"/>
    <field name="DOCUMENTNO" class="java.lang.String"/>
    <field name="CODE_BPARTNER" class="java.lang.String"/>
    <field name="ENTITY" class="java.lang.String"/>
    <field name="CURRENCY_CODE" class="java.lang.String"/>
    <field name="SYMBOL" class="java.lang.String"/>
    <field name="PAYTERM" class="java.lang.String"/>
    <field name="ORGANIZATIONID" class="java.lang.String"/>
    <field name="STATUS" class="java.lang.String"/>
    <field name="ORG_NAME" class="java.lang.String"/>
    <field name="ORG_TAXID" class="java.lang.String"/>
    <field name="BP_TAXID" class="java.lang.String"/>
    <field name="SHOWLOGO" class="java.lang.String"/>
    <field name="SHOWCOMPANYDATA" class="java.lang.String"/>
    <field name="HEADERMARGIN" class="java.lang.String"/>
    <variable name="TOTAL_LINENETAMT" class="java.math.BigDecimal" resetType="Group" resetGroup="C_INVOICE_ID"/>
    <variable name="TOTAL_TAXAMT" class="java.math.BigDecimal" resetType="Group" resetGroup="C_INVOICE_ID"/>
    <variable name="SHOWLOGO" class="java.lang.String"/>
    <variable name="SHOWCOMPANYDATA" class="java.lang.String"/>
(0038801)
dmitry_mezentsev   
2011-07-05 19:20   
Lowing priority because there is a workaround (which is attached).
At the same time added 3.0 MP2 tag to review the issue.
(0039576)
dmitry_mezentsev   
2011-08-01 13:47   
Due to the load with other issues we were not able to research this one for MP2, are planning MP3 for it now.
(0040584)
jonalegriaesarte   
2011-08-31 11:08   
Due to the load with other issues we were not able to research this one for MP3, are planning MP4 for it now.
(0041479)
jonalegriaesarte   
2011-10-04 10:32   
Due to other priorities it will be solved in the next MP
(0042399)
jonalegriaesarte   
2011-10-31 11:57   
Due to the load with other issues we were not able to research this one for MP5, are planning MP6 for it now. Sorry for the inconveniences.
(0043358)
jonalegriaesarte   
2011-11-25 17:25   
Targer version changed to MP7 due to other priorities