E1:76M: When Running AP VAT For Gain/Loss - MX (R76M940) it is Not Calculating the Negative Line (Doc ID 1954205.1)

Last updated on NOVEMBER 07, 2023

Applies to:

Symptoms

When running AP VAT For Gain/Loss - MX (R76M940) for a foreign voucher that has been entered with a tax area with a negative line in Tax Rate/Areas (P4008). The system is not calculating the VAT on the gain/loss properly, it only calculates the positive line and not taking in consideration the negative line.

Steps to duplicate issue:

1. In Tax Rate/Areas (P4008) enter a positive line for 16.000 and a negative line for -4.000, giving a total of 12%.
2. Enter a foreign voucher in standard voucher entry (P0411) with NO withholding.
3. Post the foreign voucher in (R09801) General Ledger Post.
4. Enter a manual payment in Work with Payments (P0413M) with a different Exchange Rate.
5. Post the manual payment in (R09801) General Ledger Post.  In the PDF of the M batch it will generate a PG line with the Gain/Loss for the VAT.
6. Run AP VAT For Gain/Loss - MX (R76M940) and the PDF will show that the calculation is being done only for the positive line (16%) setup in P4008 and is not considering the negative line (-4%).

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.