We have added Customer transactions table using the Table join on the Customer balance list report. However, when we add any filter criteria from the customer transactions table, the report does not filter the data correctly based on the filter criteria specified.

Expectation is that the system should filter the data correctly as per the specified filter criteria.