Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||||||
| ID | ||||||||||||
| 0017584 | ||||||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||||||
| feature request | [Openbravo ERP] 07. Sales management | major | always | 2011-06-09 18:09 | 2012-01-02 14:58 | |||||||
| Reporter | Alex76 | View Status | public | |||||||||
| Assigned To | jonalegriaesarte | |||||||||||
| Priority | normal | Resolution | open | Fixed in Version | ||||||||
| Status | new | Fix in branch | Fixed in SCM revision | |||||||||
| Projection | none | ETA | none | Target Version | ||||||||
| OS | Linux 32 bit | Database | PostgreSQL | Java version | 1.6.0_18 | |||||||
| OS Version | Community Appliance | Database version | 8.3.9 | Ant version | 1.7.1 | |||||||
| Product Version | 2.50MP26 | SCM revision | ||||||||||
| Review Assigned To | ||||||||||||
| Web browser | ||||||||||||
| Modules | Core | |||||||||||
| Regression level | ||||||||||||
| Regression date | ||||||||||||
| Regression introduced in release | ||||||||||||
| Regression introduced by commit | ||||||||||||
| Triggers an Emergency Pack | No | |||||||||||
| Summary | 0017584: Report don't use print format from countries | |||||||||||
| Description | Hi 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. | |||||||||||
| Tags | No tags attached. | |||||||||||
| Attached Files |  C_LOCATION_DESCRIPTION.xml [^] (2,307 bytes) 2011-06-09 19:11 RptC_Invoice.jrxml [^] (24,453 bytes) 2011-06-09 19:12 RptC_Invoice_Lines.jrxml [^] (16,471 bytes) 2011-06-09 19:12 | |||||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
|
(0038204) shuehner (administrator) 2011-06-09 18:13 |
Adding product version as noted by reporter. |
|
(0038206) Alex76 (reporter) 2011-06-09 19:11 |
Location stored precedure workaround. |
|
(0038272) Alex76 (reporter) 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 (developer) 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 (developer) 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 (reporter) 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 (reporter) 2011-10-04 10:32 |
Due to other priorities it will be solved in the next MP |
|
(0042399) jonalegriaesarte (reporter) 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 (reporter) 2011-11-25 17:25 |
Targer version changed to MP7 due to other priorities |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2011-06-09 18:09 | Alex76 | New Issue | |
| 2011-06-09 18:09 | Alex76 | Assigned To | => dalsasua |
| 2011-06-09 18:09 | Alex76 | Modules | => Core |
| 2011-06-09 18:12 | Alex76 | Tag Attached: 2.50MP26 | |
| 2011-06-09 18:13 | shuehner | Note Added: 0038204 | |
| 2011-06-09 18:13 | shuehner | version | => 2.50MP26 |
| 2011-06-09 18:13 | shuehner | Tag Detached: 2.50MP26 | |
| 2011-06-09 18:14 | shuehner | Issue Monitored: shuehner | |
| 2011-06-09 19:11 | Alex76 | Note Added: 0038206 | |
| 2011-06-09 19:11 | Alex76 | File Added: C_LOCATION_DESCRIPTION.xml | |
| 2011-06-09 19:12 | Alex76 | File Added: RptC_Invoice.jrxml | |
| 2011-06-09 19:12 | Alex76 | File Added: RptC_Invoice_Lines.jrxml | |
| 2011-06-11 19:50 | Alex76 | Note Added: 0038272 | |
| 2011-07-05 19:20 | dmitry_mezentsev | Note Added: 0038801 | |
| 2011-07-05 19:20 | dmitry_mezentsev | Severity | critical => major |
| 2011-07-05 19:20 | dmitry_mezentsev | Target Version | => 3.0MP2 |
| 2011-07-20 18:09 | dalsasua | Assigned To | dalsasua => jonalegriaesarte |
| 2011-08-01 13:47 | dmitry_mezentsev | Note Added: 0039576 | |
| 2011-08-01 13:47 | dmitry_mezentsev | Target Version | 3.0MP2 => 3.0MP3 |
| 2011-08-31 11:08 | jonalegriaesarte | Note Added: 0040584 | |
| 2011-08-31 11:08 | jonalegriaesarte | Target Version | 3.0MP3 => 3.0MP4 |
| 2011-10-04 10:32 | jonalegriaesarte | Note Added: 0041479 | |
| 2011-10-04 10:32 | jonalegriaesarte | Target Version | 3.0MP4 => 3.0MP5 |
| 2011-10-31 11:57 | jonalegriaesarte | Note Added: 0042399 | |
| 2011-10-31 11:57 | jonalegriaesarte | Target Version | 3.0MP5 => 3.0MP6 |
| 2011-11-25 17:25 | jonalegriaesarte | Note Added: 0043358 | |
| 2011-11-25 17:25 | jonalegriaesarte | Target Version | 3.0MP6 => 3.0MP7 |
| 2012-01-02 14:58 | jonalegriaesarte | Target Version | 3.0MP7 => |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |