Hello,

Yes, this is achievable in Odoo 18, but since the General Ledger is a dynamic report, the customization needs to be done across multiple layers.

To address your questions:

• Joining account.move fields:
  You need to extend _get_query_amls() and properly join account_move with account_move_line to fetch your custom fields.

• Where to add fields:

  • Use _get_query_amls() for transaction-level data (this is the correct place in your case)
  • _get_query_sums() is only needed if your fields are involved in aggregations

• Making fields visible in UI:

  Adding them in the query is not enough — you must also:

  • Extend _dynamic_lines_generator() to pass values into report lines
  • Add column definitions in the report (via Python options/config)
  • Update the report XML to render the new columns

So yes, both Python and XML changes are required, not just SQL.

Hope this works for you! Feel free to reach out for further discussion.

Regards,

Zehntech Technologies Inc.

santosh.sekwadia@zehntech.com