Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0007812Openbravo ERP09. Financial managementpublic2009-02-25 10:022009-03-05 16:56
networkb 
vmromanos 
immediatemajoralways
closedfixed 
30
2.40MP1 
2.40MP3 
Core
No
0007812: The invoice Taxes Report does not work with foreign sales.
The invoice Taxes Report does not work with foreign sales.
-Define a tax rate
-Create an invoice to a partner with the address in your country.
-Complete and post it.
-Create an invoice to a partner with the address in a foreign country
-Complete and post it.
-Go to "Financial Management || Receivables & Payables || Analysis Tools || Invoice Taxes Report || Invoice Taxes Report " and execute the report for the sales.
-You won't see the information about the invoice with address in a foreign country.
Modify the query of the ReportTaxInvoiceSaleForeign.jrxml report.
This report has these two conditions

      AND C_INVOICE.ISSOTRX = 'N'
      AND C_INVOICE.ISSOTRX = 'Y'

so delete the AND C_INVOICE.ISSOTRX = 'N'

and maintain only

      AND C_INVOICE.ISSOTRX = 'Y'
No tags attached.
related to defect 0007897pi closed vmromanos The invoice Taxes Report does not work with foreign sales. 
Issue History
2009-02-25 10:02networkbNew Issue
2009-02-25 10:02networkbAssigned To => rafaroda
2009-02-25 10:02networkbRegression testing => No
2009-02-25 10:06rafarodaAssigned Torafaroda => dalsasua
2009-03-02 15:35vmromanosAssigned Todalsasua => vmromanos
2009-03-02 15:35vmromanosIssue cloned0007897
2009-03-02 15:36vmromanosfix_in_branch => 2.40
2009-03-02 15:39vmromanosTypedefect => backport
2009-03-02 15:39vmromanosRelationship addedrelated to 0007897
2009-03-02 15:48hgbotCheckin
2009-03-02 15:48hgbotNote Added: 0014227
2009-03-02 15:48hgbotStatusnew => resolved
2009-03-02 15:48hgbotResolutionopen => fixed
2009-03-02 15:48hgbotFixed in SCM revision => http://code.openbravo.com/erp/stable/2.40/rev/6b34fc7758456fd4ba4823259e9dea544246fd96 [^]
2009-03-03 17:31psarobeFixed in Version => 2.40MP3
2009-03-05 16:56psarobeStatusresolved => closed

Notes
(0014227)
hgbot   
2009-03-02 15:48   
Repository: erp/stable/2.40
Changeset: 6b34fc7758456fd4ba4823259e9dea544246fd96
Author: Víctor Martínez Romanos <victor.martinez <at> openbravo.com>
Date: Mon Mar 02 15:37:39 2009 +0100
URL: http://code.openbravo.com/erp/stable/2.40/rev/6b34fc7758456fd4ba4823259e9dea544246fd96 [^]

Fixed bug 7812: The invoice Taxes Report does not work with foreign sales.

---
M src-db/database/model/functions/C_ACCTSCHEMA_DEFAULT_COPY.xml
M src-db/database/model/functions/C_SETTLEMENT_POST.xml
M src-db/database/model/tables/C_ACCTSCHEMA_DEFAULT.xml
M src-db/database/sourcedata/AD_COLUMN.xml
M src-db/database/sourcedata/AD_FIELD.xml
M src-db/database/sourcedata/AD_MESSAGE.xml
M src-db/database/sourcedata/AD_TEXTINTERFACES.xml
M src/org/openbravo/erpCommon/ad_actionButton/CreateFile.java
M src/org/openbravo/erpCommon/ad_actionButton/CreateFrom_Invoice_data.xsql
M src/org/openbravo/erpCommon/ad_reports/GenerateModel347.html
M src/org/openbravo/erpCommon/ad_reports/GenerateModel347.java
M src/org/openbravo/erpCommon/ad_reports/GenerateModel347.xml
M src/org/openbravo/erpCommon/ad_reports/GenerateModel347_data.xsql
M src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedger.java
M src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedger.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedger.xml
M src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedger_Previous.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedger_data.xsql
M src/org/openbravo/erpCommon/ad_reports/ReportTaxInvoiceSaleForeign.jrxml
---