0034302: MTR does not show correct amounts if Client currency is different than Organization currency.

Description

MTR does not show correct amounts if Client currency is different than Organization currency.

Steps To Reproduce

Install Multidimensional Tax Report module.

As QA test Admin, create a purchase invoice for Spain organization, partner and any product, dated on today's date. Complete and post the invoice. Make sure invoice currency is EUR.

Write down below information (for instance):
Invoice document number = 1000021
Total Gross Amount = 110.00 €
Total Net Amount = 100.00 €
Tax Amount = 10.00 €

Launch Multidimensional Tax report for Spain organization and the vendor of the invoice, Currency = EUR. Set today's day as From/To date. Select Tax option and Purchase/Payment transactions. Run the report.

Check that the information shown in the report is correct as it is:

Invoice document number = 1000021
Total Document Amount = 110.00 €
Total Base = 100.00 €
Tax Amount = 10.00 €

Move to F&B International Group client for which USD is the currency set at Client level. Make sure that F&B España has EUR as Organization currency.

Create a purchase invoice for F&B España, Bebidas Alegres business partner for any product, dated on today's date. Make sure that invoice currency is EUR. Complete and post the invoice.

Write down below information (for instance):
Invoice document number = 1000987
Total Gross Amount = 212.96 €
Total Net Amount = 176 €
Tax Amount = 36.96 €

Launch Multidimensional Tax report for F&B España organization, Bebidas Alegres BP, Currency = EUR. Set today's day as From/To date. Select Tax option and Purchase/Payment transactions. Run the report.

Check that the information shown in the report is NOT correct as it is:

Invoice document number = 1000987
Total Document Amount = 244.90 €
Total Base = 202.40 €
Tax Amount = 42.50 €

See image attached.

It is not correct because the amount shown are EUR amount exchanged to USD.
Applicable conversion rate is: 1.15

Proposed Solution

Correct amounts that need to be shown if the report is launch in EUR are:

Invoice document number = 1000987
Total Document Amount = 212.96 €
Total Base = 176.00 €
Tax Amount = 36.96 €

Correct amounts that need to be shown if the report is launch in USD are:

Invoice document number = 1000987
Total Document Amount = 212.96 * 1.15 = 244.90 €
Total Base = 176.00 * 1.15 = 202.40 €
Tax Amount = 36.96 * 1.15 = 42.50 €

Issue History
Date Modified	Username	Field	Change
2016-10-26 12:05	psanjuan	New Issue
2016-10-26 12:05	psanjuan	Assigned To	=> Triage Finance
2016-10-26 12:50	psanjuan	Steps to Reproduce Updated	View Revisions
2016-10-26 12:57	psanjuan	Steps to Reproduce Updated	View Revisions
2016-10-26 12:57	psanjuan	Proposed Solution updated

Relationships [ Relation Graph ] [ Dependency Graph ]

Notes
There are no notes attached to this issue.