Last updated on JANUARY 23, 2017
Applies to:PeopleSoft Enterprise FIN General Ledger - Version 9.2 and later
Information in this document applies to any platform.
On : 9.2 version, Combo Edit
AR Journals posting in GL with missing Chartfields
The customer is using Prepaid billing where in the Deferred Revenue Distribution tab, the chartfields coming from Project Costing module are not available: PC Business Unit and Activity as per the documents below:
<Bug 11460479> - PSFT 1690022000-CA: CANNOT POPULATE THE PROJECT BUSINESS UNIT (PCBU) AND ACTIVITY . The enhancement was implemented by <Bug 24314910>, starting with PUM 22.
<Note 1333425.1> - For Prepaids, The Deferred Revenue Distribution Has Project ID Filed Only. It Should Also Include Project Costing Business Unit and ACTIVITY_ID Fields.
Due to this issue, the project chartfields are not populated in General Ledger when running Journal Generator and the customer needs to use a workaround, using Project ID from Design Chartfields > Design values.
After the implemented workaround, the user is facing different behavior:
When running FS_JGEN for BIDEFN, the Journal ID generated would not post because of the missing Chartfields.
When running FS_JGEN for ARDEFN, the journal is posted even though the PC BU and Activity Chartfields are missing.
The question is why does the system stop the Journal ID from posting when it comes from the Billing module but it doesn't stop it when it comes from the AR module?
The Billing and Accounts Receivables should have the same behavior and do not let the journal to be posted if there are missing chartfields.
a) Activated Chartfield 2 for PC Business Unit and Chartfield 3 for Activity
b) Relabeled Chartfield 2 as Chartfield 2/PC BU and Chartfield 3 as Chartfield 3/ Project Activity
c) Used the delivered project chartfields ( From Project Costing module) in Billing and Accounts Receivables
d) For GL journals added the new chartfields in the Accounting Entry Definition ( Chartfield 2/ PC BU and Chartfield 3/Project Activity):
BIDEFN for Billing
ARDEFN for Accounts Receivables
Issue: When running the Journal Generator for BIDEFN and ARDEFN the results are different:
a) For ARDEFN the journals are posted - which is not desired , since the user needs to manually change the project related info
b) For BIDEFN the journals are not posted - which is desired, so user will manually update the journal with the project related info
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms