Archives
Contributors
Proposing myself (@kittiu) as PSC on purchase-workflow
Mixin model for generic warning/blocking configurable from UI
MIS Builder and multi-currency
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
by Alexey Pelykh - 01:06 - 9 Dec 2020
Follow-Ups
-
Re: MIS Builder and multi-currency
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 <alexey.pelykh@gmail.com> 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 <alexey.pelykh@gmail.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 <stephane.bidoul@acsone.eu> 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 <alexey.pelykh@gmail.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
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
by Alexey Pelykh - 04:31 - 9 Dec 2020 -
Re: MIS Builder and multi-currency
And it’s me again:E.g. I have bank account (thus, + journal, +account in Odoo) in USD. It shows asAnd 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 <alexey.pelykh@gmail.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 <stephane.bidoul@acsone.eu> 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 <alexey.pelykh@gmail.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
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
by Alexey Pelykh - 03:56 - 9 Dec 2020 -
Re: MIS Builder and multi-currency
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 <stephane.bidoul@acsone.eu> 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 <alexey.pelykh@gmail.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
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
by Alexey Pelykh - 03:26 - 9 Dec 2020 -
Re: MIS Builder and multi-currency
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 <alexey.pelykh@gmail.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
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
by Stéphane Bidoul - 03:16 - 9 Dec 2020
