magento2 – Magento 2.4 sales_order_invoice_grid populate custom column with values

I have added the column transaction_id to my sales_order_invoice_grid.

VendorModuleetcadminhtmldi.xml

<config xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
        xsi:noNamespaceSchemaLocation="urn:magento:framework:ObjectManager/etc/config.xsd">
    <virtualType name="MagentoSalesModelResourceModelOrderInvoiceGrid">
        <arguments>
            <argument name="columns" xsi:type="array">
                <item name="transaction_id" xsi:type="string">
                    sales_invoice.transaction_id
                </item>
            </argument>
        </arguments>
    </virtualType>
</config>

VendorModuleviewadminhtmlui_componentsales_order_invoice_grid.xml

<listing xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="urn:magento:module:Magento_Ui:etc/ui_configuration.xsd">
    <columns name="sales_order_invoice_columns">
        <column name="transaction_id">
            <argument name="data" xsi:type="array">
                <item name="config" xsi:type="array">
                    <item name="filter" xsi:type="string">text</item>
                    <item name="label" xsi:type="string" translate="true">Transaction ID</item>
                </item>
            </argument>
        </column>
    </columns>
</listing>

The header of the column appears as expected in the sales_order_invoice_grid and also in the CSV export file, which can be generated on this page.
The problem is the values are missing.
enter image description here

Can anyone say what I am missing or what could be wrong?
Thanks