ECM 9.2: Automatic Netting Selection (TR_NET_ASEL) is Generating Unbalanced Netting Amount on MSSQL Database
(Doc ID 2918266.1)
Last updated on JANUARY 13, 2023
Applies to:PeopleSoft Enterprise FIN Cash Management - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.
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.
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
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