EAR: Page And Field Configurator In Express Deposit Pages Causes Payment Accounting Entries To Book Realized Loss Due To Rate Type And Foreign Amount Being Wrong
(Doc ID 2619251.1)
Last updated on DECEMBER 10, 2019
Applies to:PeopleSoft Enterprise FIN Receivables - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.
The Page and Field Configurator functionality has been configured to pre-populate several existing Fields from the Express Deposit component (PAYMENT_EXPRESS) with specific values in order to streamline data entry efficiency. Such Fields are:
- Bank Code (Record Field PS_DEPOSIT_CONTROL.BANK_CD)
- Deposit Type (Record Field PS_DEPOSIT_CONTROL.DEPOSIT_TYPE)
- Control Currency (Record Field PS_DEPOSIT_CONTROL.CONTROL_CURRENCY)
- Exchange Rate (Record Field PS_DEPOSIT_CONTROL.VISUAL_RATE)
With that in place, a problem has been detected when the Payment Worksheet generated from an Express Deposit is processed by AR Update. The resulting Payment Group is successfully posted, the Item is Closed, but when reviewing the Payment Accounting Entries generated, these ones are incorrect: While the AR Control Accounting Line is properly balancing the Item's original posting, the Cash AR line is not generated, and instead, the system adds a Realized Loss Accounting Line for the full payment amount. When analyzing the specific Accounting Line, it could be observed that:
- PS_ITEM_DST.FOREIGN_AMOUNT = '0'
- PS_ITEM_DST.RATE_MULT = '0'
- PS_ITEM_DST.RT_TYPE = '' (Blank)
- PS_ITEM_DST.SYSTEM_DEFINED = 'R' (Real G/L)
- PS_ITEM_DST.DST_SEQ_NUM = '80499' (This is because the system thinks this is a realized gain/loss line)
- PS_ITEM_DST.ACCOUNT = '123456' (This is the Real G/L Account at Accounting Entry Template from DEMO, and should be '987654' instead, from the Bank Account settings)
1.- Log into the FSCM Online Application as a Receivables User
2.- Navigate to: Enterprise Components > Page and Field Configuration > Page and Field Configurator
3.- Add a new definition for Component Name PAYMENT_EXPRESS, and Market Global, and enable the below Fields and Values:
a) BANK_CD = USBNK
b) DEPOSIT_TYPE = M
c) CONTROL_CURRENCY = USD
d) VISUAL_RATE = 1
4.- Navigate to: Accounts Receivable > Pending Items > Online Items > Group Entry
5.- Create a new Pending Item Group, with one Item, for 250 USD, and Customer ID 1000, and Business Unit US001
6.- Set the Pending Item Group to a Post Action of Batch Standard
7.- Navigate to: Accounts Receivable > Receivables Update > Request Receivables Update
8.- Create a new Run Control ID for Business Unit US001, selecting option Pending Items, and run AR_UPDATE AE Program to Success
9.- Navigate to: Accounts Receivables > Payments > Online Payments > Express Deposit
10.- Add a new value, and confirm that at the Totals page, the 4 fields defined in Page and Field Configurator have been properly defaulted the values chosen (step #3)
11.- Complete adding any further missing Fields, and at the Payments tab, define a new Payment, for 250 USD, and refer to the Item previously created
12.- Go to the Action tab, and click on BUILD button
13.- Click on the 'Go To Worksheet' link that gets displayed
14.- At the Payment Worksheet Application page, confirm the transaction is in balance
15.- Go to the Worksheet Action page, and set the Post Action to Batch Standard
16.- Navigate to: Accounts Receivable > Receivables Update > Request Receivables Update
17.- Open the previously defined Run Control ID for Business Unit US001, select only option Payments, and run AR_UPDATE AE Program to Success
18.- Navigate to: Accounts Receivable > Customer Accounts > Item Information > View/Update Item Details
19.- Open the Item in question, and go to the Item Activity tab, where you can confirm the Item has been closed, and the Payment Sequence added
20.- Go to the Item Accounting Entries tab, and review the Payment Accounting Lines, to confirm that the Cash AR row is missing, and instead, there is a Real G/L row in its place
To gather more information concerning this scenario and its related problem, refer to the available Replication Steps Word Document here linked containing the complete configuration and the replication steps necessary to reproduce the issue.
The Payment Group affected is not being posted correctly, as the generated Payment Accounting Entries are incorrect. This means that the Payment Amount is not properly being booked against the Cash AR Account, and instead, it is recorded as a loss for the Company. This will get filtered later on into Journal Entries through General Ledger module, and affect the company's Balances, and Profit/Loss reports.
The Page and Field Configurator functionality is designed to be used so that specific pages get defaulted pre-defined values in some fields, to streamline User data entry tasks, and this should not interfere in the later obtained results when AR Update is to be run. The Payment Group should be properly posted, and correct Accounting Entries should be generated.
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