0004401: Dimensional reports do not treat amounts in different currencies properly

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0004401

Openbravo ERP

07. Sales management

public

2008-07-14 17:08

2008-07-16 10:45

Reporter

jtarbal

Assigned To

cromero

Priority

normal

Severity

major

Reproducibility

always

Status

closed

Resolution

duplicate

Platform

OS Version

Product Version

2.35MP5

Target Version

Fixed in Version

Merge Request Status

Review Assigned To

OBNetwork customer

Web browser

Modules

Core

Support ticket

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

Summary

0004401: Dimensional reports do not treat amounts in different currencies properly

Description

All the reports in the application do not sum the amounts properly when there are different currencies involved.

This is specially interesting in the following reports:
- Sales dimensional report
- Invoice (customer) dimensional report
- Purchase order dimensional report
- Purchase invoice dimensional report

For example, if a business partner have 2 sales orders in 2 different currencies, when we generate the "Sales dimensional report" grouped by "Business Partner", the total amount is the sum of the total amounts of the 2 sales order documents without any currency conversion.

Steps To Reproduce

Proposed Solution

The desired behaviour would be:
- the report should show everything in the currency of the primary accounting schema of the entity
- those amounts that are in another currency should be converted to the report currency using the last conversion rate between the foreign currency and the entity's currency
- if there is not any conversion rate between the 2 currencies, a note should be shown next to the wrong amount in order to inform the user.

Additional Information