EAR9.2: Understanding Loading EDI Remittance Advises (820) In PeopleSoft AR
(Doc ID 2484362.1)
Last updated on JULY 16, 2020
Applies to:PeopleSoft Enterprise FIN Receivables - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.
Customer is in process of analyzing an easier way to record the cash application in AR.
For this they would like to start loading the remittance advises in PeopleSoft.
The current scenario is that they are manually adding the deposits in AR and they would like to match them against the EDI remittance advises they get from some customers.
Customer has been able to activate the PAYMENT_LOAD message and was able to publish data into the staging tables.
He needs to understand the processing behind it and from what he read in PeopleBooks it doesn't explain it all.
Customer would like to understand why one of the staging records is deleted after the payment interface runs since the second time we run the process, the message log shows nothing, which indicates that the staging records left will never be picked up again.
In their case, they often get the remittance advice in advance of the actual payment, but it could also be the other way around.
Customer's results upon running other tests: If he tries to load a payment AND remittance (MATCH = Y), this seems to work fine and creates the deposit with the correct reference, although it does not automatically apply the remittance date.
To make this work, he had to add some more fields to the XML.
Then customer tried the same for remittance only and this doesn't seem to be matched against a manually created deposit.
Customer is loading all 3 records, AR_PAYMENT_EC, AR_IDCUST_EC, AR_IDITEM_EC, he has added a formatted version of the XML. Customer does not use the flatfile load, but directly post the XML to PeopleSoft with the handler tester, similar to what they do with all other transactions we post to PS (like Sales Order Load, Inventory Shipping etc).
- Question1: Could you please confirm that it is not possible to match the remittance data loaded through EDI with a manual deposit that was entered, as it looks like it is not possible to match the remittance data loaded through EDI with a manual deposit that was entered.
- Question2: If possible, please advise on the way customer would be able to make this work, since they don't receive the actual payment data via EDI.
As per Peopblebook link - Receiving Payments in an EDI File, https://docs.oracle.com/cd/E99725_01/fscm92pbr29/eng/fscm/fare/task_ReceivingPaymentsinanEDIFile-9f6688.html, it seems that it is not possible to match the remittance data loaded through EDI with a manual deposit that was entered.
Is this correct for Question1?
Payment Record: This table describes the Payment record: Match Flag:
Y = both cash and remittance are included; N = only cash is included; R = does not create payment for the payment record.
Note: The Payment record is required even if only remittance data is sent. If the value in the Match field is R, then the system does not create a payment for the payment record.
If yes, please suggest answer for Question2.
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