EAR 9.2: Project Costing BU And Activity ID Are Left Blank In Payment Worksheet Accounting Entries For On Account Item, Even Though ChartField Inheritance For Project Is Always Inherit
Last updated on NOVEMBER 30, 2017
Applies to:PeopleSoft Enterprise FIN Receivables - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.
A problem has been detected when manually generating the Accounting Entries of a Payment Worksheet, when a Deposit amount is placed into a new On Account Item. Should the User define Project Costing ChartField values, such as PC Business Unit, Project ID, and Activity ID, upon saving the changes, the AR Cash Accounting Line, which is calculated automatically by the system, only brings forward the value stored in Project ID, leaving in blank the ChartFields of Project Costing Business Unit, and Activity ID.
This is an issue, even though the configuration for ChartField Inheritance Options on Project ChartField is set to 'Always Inherit'. As Project Costing module is installed, and the Input Control options have defined PC Business Unit/Project/Activity as required, when the Accounting Entries only contain a Project ID value, but blank on the other 2, the GL and Project Costing module will deem the data as incomplete.
1.- At the Installation Options level, ensure that module Project Costing is selected
2.- For all Accounts Receivable ChartField Inheritance Groups, configure that Project ChartField is set to 'Always Inherit'
3.- At the External Bank Account, for Account Type lines Cash – AR, Draft – AR, Cntrl – AR, and Disc – AR, set the ChartField Inheritance options for Project to 'Always Inherit'
4.- At the Project Costing Business Unit Options level, define that 'PC BU, Project, Activity = Required' under Input Control section
5.- Proceed to create a brand new Project ID, with an Activity ID as well, and set it to Active
6.- Create a new Deposit Group using the Bank Account earlier configured, and enter one Payment for a Customer and Business Unit
7.- Build a Payment Worksheet for the Deposit created, and set the amount into a new On Account Item
8.- At the Payment Worksheet Action page, click on the 'Create/Review Entries’ button
9.- On the AR Control Accounting Line, define the PC Business Unit, Project ID, and Activity ID previously created
10.- Save the changes, confirm that the Accounting Entries are set to Complete, but when checking AR Cash line, only Project ID ChartField is defaulted, while PC Business Unit and Activity ID are left in blank
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 Accounting Entries from the Payment Worksheet for On Account Items are incomplete on Project Costing related ChartFields, with missing values on the Project Costing Business Unit, and Activity ID fields left in blank.
According to PeopleBooks, if the Project ChartField Inheritance Options is set to 'Always Inherit' the Project Costing related fields, such as Project Costing Business Unit and Activity ID among others, will default the values present on the AR Control Accounting Line into the AR Cash line.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms