Contributors mailing list archives
Re: MIS Builder and multi-currencyby
CorporateHub OU, Alexey Pelykh
Bank account is in USD, the USD balance is 0, but when EUR balance is computed, it's not - because of different transaction exchange rates and else (I assume). I'd expect "bale" from MIS to use USD (amount_currency) sum and then convert it to EUR, but it apparently does something different.
On 9 Dec 2020, at 15:51, Alexey Pelykh <firstname.lastname@example.org> wrote:And it’s me again:E.g. I have bank account (thus, + journal, +account in Odoo) in USD. It shows as<PastedGraphic-2.png>And this -46.96 appears in the MIS report. I’m trying to figure out why or how, but struggling with that :(Kind regards,AlexeyOn 9 Dec 2020, at 15:24, Alexey Pelykh <email@example.com> wrote:Hi Stéphane,Indeed! Thanks, I totally missed that part and assumed for some reason it’s the other way roundKind regards,AlexeyOn 9 Dec 2020, at 15:17, Stéphane Bidoul <firstname.lastname@example.org> wrote:Hi Aleksey,IIRC it is what it does ? https://github.com/OCA/mis-builder/blob/01e7463cbeb9cbd90effcf271a274632b40c989f/mis_builder/models/aep.py#L329-sbiOn Wed, Dec 9, 2020 at 1:07 PM Alexey Pelykh <email@example.com> wrote:Dear community, Is there a way to get MIS Builder to convert currency using rate at the end of the report period? E.g. “bale” on some account to convert using end of fiscal year conversion rate? Kind regards, Alexey