Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0007897Openbravo ERP09. Financial managementpublic2009-03-02 15:352009-04-22 00:01
Reporternetworkb 
Assigned Tovmromanos 
PriorityimmediateSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS30OS Version
Product Version2.40MP1 
Target VersionpiFixed in Version2.50 
Merge Request Status
Review Assigned To
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0007897: The invoice Taxes Report does not work with foreign sales.
DescriptionThe invoice Taxes Report does not work with foreign sales.
Steps To Reproduce-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.
Proposed SolutionModify 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'
Additional Information
TagsNo tags attached.
Relationships
related to backport 0007812 closed vmromanos The invoice Taxes Report does not work with foreign sales. 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-03-02 15:35vmromanosNew Issue
2009-03-02 15:35vmromanosAssigned To => vmromanos
2009-03-02 15:35vmromanosOBNetwork customer => Yes
2009-03-02 15:35vmromanosRegression testing => No
2009-03-02 15:35vmromanosIssue generated from0007812
2009-03-02 15:39vmromanosRelationship addedrelated to 0007812
2009-03-02 16:04vmromanosReportervmromanos => networkb
2009-03-02 16:57hgbotCheckin
2009-03-02 16:57hgbotNote Added: 0014231
2009-03-02 16:57hgbotStatusnew => resolved
2009-03-02 16:57hgbotResolutionopen => fixed
2009-03-02 16:57hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/b4a6ec1daef70c2c702fcfc0b83862d3ec127aec [^]
2009-04-21 10:33psarobeStatusresolved => closed
2009-04-22 00:01anonymoussf_bug_id0 => 2778036

Notes
(0014231)
hgbot   
2009-03-02 16:57   
Repository: erp/devel/pi
Changeset: b4a6ec1daef70c2c702fcfc0b83862d3ec127aec
Author: Víctor Martínez Romanos <victor.martinez <at> openbravo.com>
Date: Mon Mar 02 16:56:51 2009 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/b4a6ec1daef70c2c702fcfc0b83862d3ec127aec [^]

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

---
M src/org/openbravo/erpCommon/ad_reports/ReportTaxInvoiceSaleForeign.jrxml
---