ECM: PYMNT_VCHR_XREF.SCHEDULED_PAY_DT and PYMNT_SEPARATE Incorrectly Updated when Voucher Partly Netted
(Doc ID 2748573.1)
Last updated on AUGUST 11, 2021
Applies to:
PeopleSoft Enterprise FIN Cash Management - Version 9.2 to 9.2 [Release 9]Information in this document applies to any platform.
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
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 |