SAP Knowledge Base Article - Public

3463184 - Withholding Amount is Recalculated when Creating Payments for a Migrated Supplier Invoice in Mexico

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

  1. Go to Payables work center.
  2. Go to Supplier Accounts view.
  3. Search for supplier account ID ABC.
  4. View all items.
  5. Select Document ID DEF.
  6. Open the related clearing document XYZ.
  7. The default withholding amount is for example, 1000 USD.
  8. 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:

  1. Go to Business Configuration work center.
  2. Open Activity Tax on Goods and Services.
  3. Open Define Tax Rate Schedules.
  4. 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

Product

SAP Business ByDesign all versions