Symptom
When posting transactions in the Cash Journal, the system displays the below error message:
'Withholding tax amount exceeds total bank line item amounts'
Message no. 7Q320
Environment
SAP S/4HANA Cloud Public Edition
Cause
The issue occurs due to the exchange rate(for e.g, from EUR to USD) has not been maintained. The withholding tax calculation requires this exchange rate to properly convert and validate the amounts.
Resolution
Maintain the required exchange rate for the transaction currency to the company code currency.
Steps to maintain exchange rate:
- Open the 'Manage Exchange Rates' app
- Select the relevant Exchange Rate Type (usually 'M' for average rate).
- Verify or maintain an exchange rate for:
- From Currency: Transaction currency (e.g., EUR, GBP, etc.)
- To Currency: Company code currency (e.g., USD)
- Validity Date: Must cover the posting date of the transaction.
- Save the entry.
- Repost the transaction in the Cash Journal to confirm the error no longer occurs.
Result:
After maintaining the exchange rate, the system will correctly calculate withholding tax amounts, and the error message will no longer appear. Transactions in the Cash Journal can then be posted successfully.
Keywords
withholding tax, cash journal, supplier payment, foreign currency, exchange rate, error message 7Q320, EUR, USD, public cloud, calculation , KBA , FI-AP-AP-Q-2CL , Withholding Tax (Calculation) (Public Cloud) , Problem
Product
Attachments
| Pasted image.png |
SAP Knowledge Base Article - Public