Openbravo Issue Tracking System - Localization Pack: Spain
View Issue Details
0034302Localization Pack: SpainMulti Dimensional Tax Reportpublic2016-10-26 12:052016-10-26 12:57
psanjuan 
Triage Omni OMS 
urgentmajoralways
newopen 
20Professional Appliance
 
 
0034302: MTR does not show correct amounts if Client currency is different than Organization currency.
MTR does not show correct amounts if Client currency is different than Organization currency.
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

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 €
No tags attached.
Issue History
2016-10-26 12:05psanjuanNew Issue
2016-10-26 12:05psanjuanAssigned To => Triage Finance
2016-10-26 12:50psanjuanSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=13485#r13485
2016-10-26 12:57psanjuanSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=13486#r13486
2016-10-26 12:57psanjuanProposed Solution updated

There are no notes attached to this issue.