Incorrect Withholding Tax Calculated when Prepayment with Withholding Tax is applied (Doc ID 2531390.1)

Last updated on OCTOBER 15, 2019

Applies to:

Symptoms

Incorrect Withholding Taxes were calculated if The Prepayment is applied after Invoice is Validated.

 1.Create Prepayment with VAT and Withholding
Prepayment : 300,000
VAT          30,000
Withholding  -6,000
AP           324,000


2. Create Standard Invoice with VAT and Withholding

Expense:     500,000
VAT          50,000
Withholding  -10,000
AP           540,000

3. Apply Prepayment to standard Invoice

3. Apply Prepayment
Outstanding Prepayment Oracle Version : 210,000

Standard Invoice Prepayment      Outstanding
500,000            300,000              200,000
50,000             30,000                20,000
-10,000            -10,000
540,000            330,000              210,000

Outstanding Prepayment Manual Calculation (Should be)
Standard Invoice  Prepayment      Outstanding
500,000            300,000              200,000
50,000             30,000                 20,000
-10,000            -6,000                 -4,000
540,000            324,000               216,000

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.