Dear all,

I am working on a sql report linked to both purchase and landed cost modules.
From my understanding OpenERP 7 purchase analysis report is not multi currency.

I would like to get the following behavior:

If a company with a default currency in EUR creates a PO with a pricelist in another currency, I want the report to display the prices in EUR.

I have thought of 2 ways:
- Create a SQL function that converts an amount from a currency to another currency on a given datetime.
Or
- Add a storable function fields at the POL level named "amount_reporting".

The second way is more developer friendly but It might slow down the ERP (E.g: Scheduler)

Has someone already solved this problem ?

Kind regards,

Augustin Cisterne-Kaas
Technical Engineer
--
Elico Corporation, Shanghai branch
OpenERP Premium Certified Training Partner 
Cell: + 86 150 2177 7450
Skype: augustin.cisternekaas
augustin.cisternek...@elico-corp.com
http://www.elico-corp.com



Attachment: signature.asc
Description: Message signed with OpenPGP using GPGMail

_______________________________________________
Mailing list: https://launchpad.net/~openerp-community
Post to     : openerp-community@lists.launchpad.net
Unsubscribe : https://launchpad.net/~openerp-community
More help   : https://help.launchpad.net/ListHelp

Reply via email to