EAR 9.2: The Customer Account Overview Supplier Balance Feature Incorrectly Includes Template Voucher Transactions
(Doc ID 2740451.1)
Last updated on DECEMBER 29, 2020
Applies to:PeopleSoft Enterprise FIN Receivables - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.
An anomaly has been detected at the Customer Account Overview level, in the Balances tab, where the Supplier Balance row is including Template Voucher transactions for the Supplier linked in the selected Customer. As such, both the Voucher Count, and Voucher Amount in the Balances page (CUST_BALANCES_HDR), and Vouchers for a Supplier page (CUST_VNDR_ITEM_SEC), are incorrect.
1.- Log into the FSCM Online Application as a Financials User
2.- Navigate to: Customers > Customer Information > General Information
3.- Open a given Customer ID, such as 1000, and go to the Miscellaneous General info tab
4.- Define the Supplier Set ID and Supplier ID fields (Example: SHARE, and USA0000001)
5.- Navigate to: Suppliers > Supplier Information > Add/Update > Supplier
6.- Open the existing Supplier just linked, (Supplier ID USA0000001)
7.- Go to the Identifying Information tab, and expand the Additional ID Numbers section
8.- Again define a Customer Set ID, and Customer ID values (Example: SHARE, and 1000)
9.- Navigate to: Accounts Payable > Vouchers > Add/Update > Regular Entry
10.- Manually add, and save, a new Voucher transaction for Supplier ID USA0000001 in Business Unit US001, and ensure it is defined as Voucher Style TEMPLATE
11.- Navigate to: Accounts Receivable > Customer Accounts > Customer Information > Account Overview
12.- Define the Set ID SHARE, Unit US001, Customer ID 1000, and click on SEARCH button
13.- Go to the Balances tab, and check the row for Supplier Balance, click on its link
14.- The system opens the pop up window for Vouchers for a Supplier page
15.- Scroll through the grid of Supplier Details, and confirm that the Template Voucher transaction just created is included in the display of data
16.- As such, both the Voucher Count and Voucher Amount fields are incorrectly misrepresented, same for the Count and Amount columns on the Balances tab for the row of Supplier Balance
To gather more information concerning this scenario and its related problem, refer to the available Replication Steps PDF Document here linked containing the complete configuration and the replication steps necessary to reproduce the issue.
While including the Template Voucher transactions' data, the Supplier Balance Count and Amount fields are inaccurate, and confuse the Users.
Template Vouchers are just a model to be used as a default for data entry efficiency in the Accounts Payable module. Such transactions will never qualify for posting, nor payment. As such, such transactions should be filtered out from the Supplier Balance grid and calculations altogether to have a proper calculation of the Customer's related Supplier Balance.
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