E1: 76M: R76M940 AP VAT for Gain Loss Is Ignoring AAI PG/PL Hierarchy (Doc ID 2689773.1)

Last updated on APRIL 04, 2025

Applies to:

Symptoms

R76M940-AP VAT for Gain Loss process is not following AAI PG/PL hierarchy when generating journal entry.

The Journal Entry created by R76M940, is taking the account attached to AAI PIxxxx (where xxxx is the G/L Offset in Tax Rate Area) for the Company of the transaction, as it was set in processing options of R76M940 and to balance the journal entry it is taking an account attached to an AAI PL defined for other Company.
Based in the setting of the AAI PL and the hierarchy defined for this AAI, the system should take PLyyyy (where yyyy is the GL Offset of the paid voucher) for the payment transaction Company, when AAIs for currency code is not defined, but it is taking a PL from another Company.
 
Hierachy defined for AAI PG/PL:
1 - PGxxx / PLxxx (where xxx is the payment currency code) for the payment transaction company
2 - PGxxx / PLxxx (where xxx is the payment currency code) for company 00000
3 - PGyyyy / PLyyyy(where yyyy is the GL offset on the paid voucher) for the payment transaction company
4 - PGyyyy / PLyyyy (where yyyy is the GL offset on the paid voucher) for company 00000
5 - PG / PLfor the payment transaction company
6 - PG / PL for company 00000
7 - Error

Steps:

Beside the basic setting of the Mexican localization:

1. Set AAIs for G/L Offset LOC: PGLOC, PLLOC, PCLOC and PBLOC
2. Set AAIs for Mexican VAT: PTVTAX and PIVTAX
3. Set AAIs for Mexican Withholding: $I, $IING, $V and $VIV1
4. Set for the Withholding in the Mexican localization: Legal Concept, Withholding Concepts and Withholding Percentages
5. Enter a new Address Book number with Mexican localization setting
6. Enter a voucher in foreign currency and post it
7. Verify there is a different exchange rate between the voucher and the payment date
8. Create a payment group to pay the voucher in the foreign currency
9. Review withholding were calculated and subtracted from the payment
10. Write and Update the Payment Group
11. Post the Payment batch
12. Notice the Gain generate for the exchange rate difference (Doc Type PG)
13. Run R76M940 in final
14. A batch type G (Journal Entry) was generated with Document Type JK
15. The Journal Entry is taking the account attached to AAI PIVTAX for Company 801 (as we defined in processing options of R76M940) and to balance the journal entry it is taking an account attached to an AAI PL defined for the Company.

Based in the setting of the AAI  PL and the hierarchy defined for this AAI, the system should take PLLOC for Company 801 but it is taking a PL from other Company (200). It should use PGyyyy / PLyyyy(where yyyy is the GL offset on the paid voucher) for the payment transaction company.

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.