ECM 9.2: Automatic Netting Selection (TR_NET_ASEL) is Generating Unbalanced Netting Amount on MSSQL Database
(Doc ID 2918266.1)
Last updated on APRIL 04, 2023
Applies to:
PeopleSoft Enterprise FIN Cash Management - Version 9.2 to 9.2 [Release 9]Information in this document applies to any platform.
Symptoms
After running Automatic Netting Selection (TR_NET_ASEL) the resulting Netting Worksheet is not balanced. The Netted Payable amount is not equal to Netted Receivable due to incorrect amount calculation in MSSQL database environments.
Steps:
1. Create Netting Contract
Cash Management > Administer Cash > Netting Contracts
2. Create Voucher for the supplier available in the Netting Participant
Accounts Payable > Vouchers > Add/Update > Regular Entry
3. Create 3 different group entries for customer available in netting participant
Accounts Receivable > Pending Items > Online Items > Online Item Group Entry
4. Run the Automatic Netting Selection process.
Cash Management > Bi-Lateral Netting > Automatic Netting Selection
5. See the Netted amount is incorrect due to fraction amount. The netted receivables amount was fractionally more than Netted Payable.
Cash Management > Bi-Lateral Netting > Review Single Netting
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 |