My Oracle Support Banner

EAR9.2: Why AR Payment Load with PAY_AMT Field Populated is Not Applying Its Value When Building The Payment Worksheet? (Doc ID 2639114.1)

Last updated on FEBRUARY 24, 2020

Applies to:

PeopleSoft Enterprise FIN Receivables - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Goal

Why when providing the paid amount for an invoice- PAY_AMT information, system is not taking paid amount into account when manually building the payment worksheet, but instead is taking the original item amount ?

For instance, if it is received a payment for multiple invoices, and one of these is not paid in full, creating the worksheet will load all invoices referenced with their open invoice amount instead of the paid amount specified on the Payment loaded, how would the user be able to identify which invoice is the one that was not paid in full and therefore the needs to be adjusted on the Payment Worksheet?

Customer business scenario and steps followed:
==============================
1. Setup steps:
Activate Service Operation under PeopleTools/ Integration Broker/ Integration Setup/ Messages
Status must be Active under Handlers tab Activate selected routing under Routings tab
Queue status must be set to Run under PeopleTools/ Integration Broker/ Integration Setup/Queues
Service must be Active under PeopleTools/ Integration Broker/ Integration Setup/Services


2. Replication steps:
Use Handler tester to provide XML under PeopleTools/ Integration Broker/ Service Utilities/ Handler Tester
Sample file is uploaded (Pay Amt is equal to 200 USD)
Click on Execute Event button
Successfully executed - Done message is received
Check table:SELECT * FROM PS_AR_PAYMENT_EC WHERE DEPOSIT_BU = 'CAN01'
Save trace:-TRACE 15 -TOOLSTRACESQL 15 -TOOLSTRACEPC 4044
Run the process under navigation path- Accounts Receivable/ Payments/ Electronic Payments/ Process Payment Interface (only EDI 820 and EDI CREEXT
checkboxes are selected)
Make the selection and click on OK
Check the Message log
Successfully processed (message log shows Selected 1 EDI CREEXT payments)
Check the deposit which has been created by the process - check Accounts Receivable / Payments/Online Payments/ Regular Deposit and populate Deposit
Unit and click on the Search
Deposit details look ok (Entered Total amount is 200 USD)
Item is referenced - Click on Detail reference link
Item ID and Pay Amt fields are not populated, Pay Amount equal to loaded amount (200 USD)
Click on Apply Payment link
Click on Build button
Item selected is having full invoice amount (214.00 USD), instead of having loaded amount (200 USD), as per the actual loaded payment- which is not correct.

Solution

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
Goal
Solution
References


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