WHT Threshold Lim 50 Lakhs per party in a year Setup, but system is calculating WHT below threshold

Summary:

WHT Threshold Lim 50 Lakhs per party in a year Setup, but system is calculating WHT below threshold also. how to check?

Content (please ensure you mask any confidential information):

We have defined 194Q setup threshold limit 50 Lakhs and if supplier invoice crosses more than 50Lakhs amount and system should calculate WHT tax 0.1% but system is calculating Withholding even though invoice amount not crossed 50 Lakhs.

Do we have any report or SQL query to check whether particular Party (supplier) invoice limit crossed 50 Lakhs or not? This issue is creating unnecessarily withholding tax deduction to suppliers. Suppliers are raising concerns on withholding tax deduction due to this issue.