My Oracle Support Banner

E1: 04: A/P To G/L Integrity by Batch (R04701) Gross Amount – F0411 Column Includes Non-Recoverable Tax Amount (NRTA) When Tax is on the A/P Voucher (Doc ID 2897777.1)

Last updated on NOVEMBER 04, 2022

Applies to:

JD Edwards EnterpriseOne Accounts Payable - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

The A/P To G/L Integrity by Batch (R04701) shows an out of balance between the Gross Amount – F0411 compared to the Amount to Distribute – F0411, Distribution Amount – F0911 and Automatic Offset Amount – F0911.  The Gross Amount – F0411 includes the Non-Recoverable Tax (NRTA) amount from AP vouchers that have taxes on them, which is causing the discrepancy between the Gross Amount – F0411 column and the other columns.

Steps to duplicate:

  1. Enter an AP Logged Voucher in Other Voucher Entry Methods (G04111), Voucher Logging Entry (P0411 version ZJDE0008). Make sure to populate the Tax fields (Taxable Amount, Tax Rate Area (GST) and Tax Explanation code (C for VAT tax)). Post the voucher from Voucher Journal Review (P0011).

    NOTE: This can also be duplicated if you use a standard voucher with the tax fields populated.

  2. For the Logged Voucher, redistribute the voucher using voucher JE Redistribution (P042002) entering a different G/L account and post the batch as noted above.
  3. Run the batch version (BV) R04701 and note that the batch is not on the report.
  4. Go to menu G0413, Speed Status Change (P0411S). Inquire on the Supplier and select the Voucher.  Go to Row exit and select Split.  Split the voucher into two pay items.  On one of the pay items scroll to the right and enter an amount in the Non-Recoverable Tax Amount (NRTA) field. Accept the split, re-inquire on it and note the two pay items with the second one having the NRTA value.
  5. Run the R04701 again and note this batch now shows on the report. The Report shows the Gross Amount - F0411 includes the gross amount of the two pay items on the voucher plus the Non-Recoverable amount. This shows the out of balance with the associated records in the F0411 (Accounts Payable Ledger) and F0911 (G/L Ledger).

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


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