My Oracle Support Banner

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.

Symptoms

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.

REPLICATION STEPS:

    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.

NOTE: In the images/screenshots/examples mentioned and/or the attached document, user details / company name / address / email / telephone number represent a fictitious sample (based upon made up data used in the Oracle Demo Vision instance).  Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.

Changes

 

Cause

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
Symptoms
Changes
Cause
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.