We are getting the following error in the log file when we search any customer email from the Magento customer grid 

Integrity constraint violation: 1052 Column 'email' in where clause is ambiguous, query was: SELECT `main_table`.*, `customer_entity`.`mp_ace_blacklist`, `bss_companycredit_credit`.`available_credit`, `bss_companycredit_credit`.`allow_exceed`, `bss_companycredit_credit`.`currency_code` FROM `customer_grid_flat` AS `main_table`

We are using version 1.0.5 on Magento 2.4.0 CE.

Could you please check and solve it?


The issue happens due to the module's bug.

To solve it, please overwrite this file app/code/Bss/CompanyCredit/Plugin/Customer/Grid/JoinCollection.php 

Please apply it on the site and flush the cache.

If you have any issues, please feel free to contact us.

We're always willing to support you.