My Oracle Support Banner

E1: 04: Advanced Payment Term for Installments (P00145) is Not Splitting the Percentage Properly and Creating an Unbalanced F0411 and F0911 Records (Doc ID 3012009.1)

Last updated on MARCH 28, 2024

Applies to:

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

Symptoms

Advanced Payment terms have been created with an Installment added for a 30% and 70% split. When the voucher is created, two lines are created for only the 30% split in the F0411 - Accounts Payable Ledger and the F0911 - Account Ledger records.

When the payment term has split payments, the voucher match created will be unbalance.

The issue can be reproduced at will with the following steps:


1. Create Advanced Payment Terms for X96 (P00145)
2. Create Installments (P00145) using Row exit
3. Create a Due Date Rule for A111 using Based on Date = 1 Invoice
4. Create another Due Date Rule for A119 using Based on Date = 1 Invoice.
5. Go to P0014 to ensure Number of Split Payments = 2.
6. Create a Purchase Order using Payment Terms X96 on PO header (P4310). Add a J line type with Extended Amount = $55.20 to the PO detail.
7. Receive the PO (P4312) for $55.20.
8. Voucher match (P4314) the open receipt.
9. The Voucher is created and split into 2 lines (which is expected) but the amounts are not correct on the F0411. Gross Amount and Open Amount are both $16.56.
10. The G/L distribution is correct and displays $55.20.



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
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.