- Mailing Lists
- Contributors
- Re: MIS Builder and multi-currency
Archives
- By thread 1419
-
By date
- August 2019 59
- September 2019 118
- October 2019 165
- November 2019 97
- December 2019 35
- January 2020 58
- February 2020 204
- March 2020 121
- April 2020 172
- May 2020 50
- June 2020 158
- July 2020 85
- August 2020 94
- September 2020 193
- October 2020 277
- November 2020 100
- December 2020 159
- January 2021 38
- February 2021 87
- March 2021 146
- April 2021 73
- May 2021 90
- June 2021 86
- July 2021 123
- August 2021 50
- September 2021 68
- October 2021 66
- November 2021 74
- December 2021 75
- January 2022 98
- February 2022 77
- March 2022 68
- April 2022 31
- May 2022 59
- June 2022 87
- July 2022 141
- August 2022 38
- September 2022 73
- October 2022 152
- November 2022 39
- December 2022 50
- January 2023 93
- February 2023 49
- March 2023 106
- April 2023 47
- May 2023 69
- June 2023 92
- July 2023 64
- August 2023 103
- September 2023 91
- October 2023 101
- November 2023 94
- December 2023 46
- January 2024 75
- February 2024 79
- March 2024 104
- April 2024 63
- May 2024 40
- June 2024 160
- July 2024 80
- August 2024 70
- September 2024 62
- October 2024 121
- November 2024 117
- December 2024 89
- January 2025 59
- February 2025 104
- March 2025 96
- April 2025 107
- May 2025 52
- June 2025 72
- July 2025 60
- August 2025 81
- September 2025 124
- October 2025 63
- November 2025 22
Contributors
Re: MIS Builder and multi-currency
On 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
Reference
-
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-
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
-