Skip to Content
Menu
Musisz się zarejestrować, aby móc wchodzić w interakcje z tą społecznością.
To pytanie dostało ostrzeżenie
2 Odpowiedzi
424 Widoki

When I export the general ledger in XLSX format, the currency name does not appear in the Excel file, even though we are using multiple currencies.

Awatar
Odrzuć
Najlepsza odpowiedź

Hii,

make a custom model

File: account_general_ledger_currency_patch.p

from odoo import models class GeneralLedgerCurrencyPatch (models.AbstractModel): _inherit = 'account.general.ledger.report' def _get_columns_name ( self, options ): columns = super ()._get_columns_name(options) columns.append({ 'name' : 'Currency' }) # Add column title return columns def _get_lines ( self, options, line_id= None ): lines = super ()._get_lines(options, line_id) for line in lines: if 'columns' in line and line.get( 'level' ) == 2 : # Line is a move line record = line.get( 'record' , None ) if record and hasattr (record, 'currency_id' ) and record.currency_id: currency = record.currency_id.name else : currency = '' line[ 'columns' ].append({ 'name' : currency}) return lines

Register it in your module
__init__.py

from . import account_general_ledger_currency_patch

__manifest__.py

Make sure it depends on account_reports :


'depends' : [ 'account_reports' ],

i hope it is use full

Awatar
Odrzuć
Autor

This custom code is not working for me, since account.general.ledger.report doesn't exist in Odoo 17. I tried using account.general.ledger.report.handler, but it's still not working.

Najlepsza odpowiedź

In default Odoo, The currency name is not included in the Excel file when exporting the General Ledger report, Even though we are using multiple currencies.

Awatar
Odrzuć
Autor

Is there any solution for this?

Powiązane posty Odpowiedzi Widoki Czynność
0
cze 25
8
1
kwi 25
3038
1
kwi 25
613
2
gru 20
4078
0
kwi 23
1620