Need to filter vendor statement of account report by financial dimension and in D365FO it does not allow us to do so.

in AX2012 customer use to do it by joining with vendor transaction table & selecting offset account dimension. In D365 join with vendor transaction table does not work. thus, if we select then run the report, we will not get any data.

We check with product team and obviously that in this report joining function does not work. Although it will give us offset account dimension, but it is function less in D365 F&O unlike Ax2012.