Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0029748Openbravo ERP09. Financial managementpublic2015-04-30 10:462015-05-14 17:48
Reportermaite 
Assigned Tojorge-garcia 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target Version3.0PR15Q3Fixed in Versionpi 
Merge Request Status
Review Assigned Toumartirena
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket35856
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0029748: "Create VAT register" process in Tax Payment window should consider exchange rate defined at document level
Description"Create VAT register" process in Tax Payment window should consider exchange rate defined at document level
Steps To Reproduce1. Define Price List as "Sales price list" and MXN currency. Add price list version record and define price for one product
2. Register Sales Invoice document using MXN price list. Add line and define Exchange Rate to EUR currency. Process and post invoice
3. Define Tax Register Type for "Sales transaction". Add Line for "Entregas IVA 21% - IVA Normal" tax and "AR Invoice"
4. Access Tax Payment window, set EUR as currency and valid Starting/Ending date
5. Run "Create VAT registers" process and realize that following error is raised "There is no conversion rate defined from (MXN-$) to (EUR-€) for date '30-04-2015', Client 'F&B International Group' and Organization 'F&B España - Región Norte'."
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2015-04-30 10:46maiteNew Issue
2015-04-30 10:46maiteAssigned To => Triage Finance
2015-04-30 10:46maiteOBNetwork customer => Yes
2015-04-30 10:46maiteModules => Core
2015-04-30 10:46maiteSupport ticket => 35856
2015-04-30 10:46maiteResolution time => 1433109600
2015-04-30 10:46maiteTriggers an Emergency Pack => No
2015-04-30 10:46maiteIssue Monitored: networkb
2015-05-12 13:10jorge-garciaStatusnew => scheduled
2015-05-12 13:10jorge-garciaAssigned ToTriage Finance => jorge-garcia
2015-05-12 13:13jorge-garciaNote Added: 0077339
2015-05-13 16:21hgbotCheckin
2015-05-13 16:21hgbotNote Added: 0077390
2015-05-13 16:22hgbotStatusscheduled => resolved
2015-05-13 16:22hgbotResolutionopen => fixed
2015-05-13 16:22hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/800d3becdda0093e223b883d4c1caffb4c0c1e2e [^]
2015-05-13 16:22hgbotCheckin
2015-05-13 16:22hgbotNote Added: 0077391
2015-05-13 16:23umartirenaReview Assigned To => umartirena
2015-05-13 16:23umartirenaNote Added: 0077392
2015-05-13 16:23umartirenaStatusresolved => closed
2015-05-13 16:23umartirenaFixed in Version => pi
2015-05-14 17:48hudsonbotCheckin
2015-05-14 17:48hudsonbotNote Added: 0077459
2015-05-14 17:48hudsonbotCheckin
2015-05-14 17:48hudsonbotNote Added: 0077460

Notes
(0077339)
jorge-garcia   
2015-05-12 13:13   
Test Plan

As group admin:
  Define Price List as "Sales price list" and MXN currency. Add price list version record and define price for one product
  Register Sales Invoice document using MXN price list. Add line and define Exchange Rate to EUR currency. Process and post invoice
  Define Tax Register Type for "Sales transaction". Add Line for "Entregas IVA 21% - IVA Normal" tax and "AR Invoice"
  Access Tax Payment window, set EUR as currency and valid Starting/Ending date
  Run "Create VAT registers" process and realize that process is completed with no error
(0077390)
hgbot   
2015-05-13 16:21   
Repository: erp/devel/pi
Changeset: 800d3becdda0093e223b883d4c1caffb4c0c1e2e
Author: Jorge Garcia <jorge.garcia <at> openbravo.com>
Date: Mon May 11 18:56:21 2015 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/800d3becdda0093e223b883d4c1caffb4c0c1e2e [^]

Fixed issue 29748: "Create VAT register" process should consider exchange rate

"Create VAT register" process in Tax Payment window should consider exchange
rate defined at document level.

The solution is to check if there is an exchange rate defined in the invoice
and if it's null, use the exchange rate defined in Conversion Rate window.

---
M src/org/openbravo/erpCommon/ad_actionButton/CreateVatRegisters_data.xsql
---
(0077391)
hgbot   
2015-05-13 16:22   
Repository: erp/devel/pi
Changeset: dc69cdec624fb10ed4bb2d9d1ad69cbe71dee99f
Author: Unai Martirena <unai.martirena <at> openbravo.com>
Date: Wed May 13 16:20:30 2015 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/dc69cdec624fb10ed4bb2d9d1ad69cbe71dee99f [^]

Related to bug 29748: Fix copyright

---
M src/org/openbravo/erpCommon/ad_actionButton/CreateVatRegisters_data.xsql
---
(0077392)
umartirena   
2015-05-13 16:23   
Code Review + Testing OK
(0077459)
hudsonbot   
2015-05-14 17:48   
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/3375171dd310 [^]
Maturity status: Test
(0077460)
hudsonbot   
2015-05-14 17:48   
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/3375171dd310 [^]
Maturity status: Test