Symptom
When creating payments for a migrated supplier invoice in Mexico, the default withholding amount differs from the figure maintained in the migration file.
Environment
SAP Business ByDesign
Reproducing the Issue
- Go to Payables work center.
- Go to Supplier Accounts view.
- Search for supplier account ID ABC.
- View all items.
- Select Document ID DEF.
- Open the related clearing document XYZ.
- The default withholding amount is for example, 1000 USD.
- However, when checking the migration file, the total withholding tax amount is, for example 800 USD, which differs from the calculated amount 1000 USD.
(ABC represents the supplier account ID. DEF represents the migrated supplier invoice ID. XYZ represents the clearing document ID.)
Cause
The VAT tax rate in the migration file is different from the one maintained in the BYD system. The system will NOT check the VAT tax amount when uploading the template.
However, when creating payments for supplier invoices, the system will recheck the tax rate and recalculate the VAT tax amount. And the subsequent calculations for withholding tax amounts will also be based on the recalculated VAT tax amount.
Resolution
This is the current system design to avoid inconsistencies when creating payment. Change the tax rate in the system and make it the same as the one used in the migration file can help resolve the issue.
Steps to check and change VAT tax code in the system:
- Go to Business Configuration work center.
- Open Activity Tax on Goods and Services.
- Open Define Tax Rate Schedules.
- The respective Tax rate can be changed in this view.
Keywords
withholding tax, outgoing payment amount, clearing document, VAT tax amount, tax code, supplier invoice , KBA , SRD-FIN-MOP , Payment Management , Problem