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.

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.

Tags

No tags attached.

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

duplicate of

feature request

0002181

2.50

closed

rafaroda

Currency in reports - non accounting reports

Notes
There are no notes attached to this issue.

Issue History
Date Modified	Username	Field	Change
2008-07-14 17:08	jtarbal	New Issue
2008-07-14 17:08	jtarbal	Assigned To	=> cromero
2008-07-14 17:08	jtarbal	sf_bug_id	0 => 2018040
2008-07-16 10:45	cromero	Relationship added	duplicate of 0002181
2008-07-16 10:45	cromero	Status	new => closed
2008-07-16 10:45	cromero	Duplicate ID	0 => 2181
2008-07-16 10:45	cromero	Resolution	open => duplicate