ECM: PYMNT_VCHR_XREF.SCHEDULED_PAY_DT and PYMNT_SEPARATE Incorrectly Updated when Voucher Partly Netted (Doc ID 2748573.1)

Last updated on MARCH 12, 2021

Applies to:

Symptoms

PYMNT_VCHR_XREF.SCHEDULED_PAY_DT and PYMNT_SEPARATE are incorrectly updated when voucher is partly netted.

Steps:

1. Netting Setup:

- Bank Setup: NET01
- Netting Account: NET1
- Payment Method for Netting Account: System Check
- Netting Participant: Supplier: USA0000001, Customer USA01
- Netting Contracts: TEST

2. Enable Supplier for Netting.

3. Create Voucher 1 with below details:

- Netting HOLD
- Separate Payment: Checked
- Amount $300
- Invoice Date: 01/08/2020
- Schedule Due: 21/09.2020
 
4. Create Voucher 2  with below details:

- Netting HOLD
- Separate Payment: Checked
- Amount $500
- Invoice Date: 01/08/2020
- Schedule Due: 21/09.2020
 
5. Create Voucher 3  with below details:

- Netting HOLD
- Separate Payment: Checked
- Amount $500
- Invoice Date: 01/09/2020
- Schedule Due: 30/09/2020
 
6. Create an Item in AR for 1000 USD for USA01.
7. Post the entry.
8. Run Automatic Netting Selection:
 
- Reference ID 000000000019 is generated
- Vouchers 1, 2, 3 are selected
- Voucher 3 is partially netted
- AR Item is selected

9. Approve Netting:
- Netting Status as Selected for Vouchers: 1, 2, 3

10. Configure PayCycle criteria for Netting and provide Netting ID generated as 000000000019

11. Run Payment Selection:
-  All 3 Vouchers are processed

12. Run Payment Creation:

- Netting payment is created.
- Pay Cycle Status was set to Completed.

13. Upon Payment Selection, Netting Status was set to Close.

14. Run Payment Posting.
15. Verify Payment details on the voucher 3:

For the remaining open voucher amount (300) the scheduled pay date has been updated from 30-09-2020 to 21-09-2020 and the separate payment flag has been removed.

Cause

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