E1:42: R42800 Assigns Same Due Date to Invoices with Negative Amounts When Using Split Payment Terms

(Doc ID 1988791.1)

Last updated on NOVEMBER 12, 2015

Applies to:

JD Edwards EnterpriseOne Sales Order Management - Version 9.1 and later
Information in this document applies to any platform.

Symptoms

Client is using split payment terms on sales order. They have an invoice with 2 lines (one positive and one negative). The P03B0011|ZJDE0002 Processing Option #5. Credit Memo Due Date has a option for G/L date or Payment Terms due date.

Setup:

- Payment Terms is split into 2 payment with days to age = 30.
- R42800 Processing Option 4. Select Date Value as G/L Date = 3 (Execution Date).
- Execution Date = 3/10/15 in this example

Test Case #1) When the processing option is <blank>, the due date for negative lines are assigned the G/L date 3/10/15 and positive lines are assigned payment term due dates 4/9/15 and 5/9/15
Test Case #2) When the processing option is '1', the due date for negative lines and positive lines are assigned the payment terms due date 4/9/15 and 5/9/15

None of the above meets client's requirements.They want the first split payment (positive and negative invoice lines) to be assigned the G/L date and the second split payment (positive and negative invoice lines) to be assigned the due date from payment terms. Below is the example of what they are looking for:

=====================================================================================================
If you have an invoice with 2 rows (because you have 2 VAT codes), one positive and one negative:

VAT1 110,00 EUR
VAT2 -10,00 EUR
TOT 100,00 EUR

The split by R42800 should occur as follows:

Split 1:
=======
VAT1 55,00 EUR due date 03/10/2015
VAT2 -5,00 EUR due date 03/10/2015
TOT 50,00 EUR due date 03/10/2015


Split 2:
========
VAT1 55,00 EUR due date 04/09/2015
VAT2 -5,00 EUR due date 04/09/2015
TOT 50,00 EUR due date 04/09/2015

The amount of the 1st and the 2nd installments have to be equal. The negative rows are not credit memos, they are only a part of an invoice.
=====================================================================================================

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms