EGL: Sub System Reconciliation Shows Differences When The Journal Was Not Posted In The Same Period (Doc ID 2015195.1)

Last updated on SEPTEMBER 14, 2016

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9.2 and later
Information in this document applies to any platform.

Goal

Our Expense module’s journal generation template is set to generate journals with current date (and not accounting date on the transaction).  
 
So for example, an expense transaction with a acctg date of April 28, when posted (journal generated) on May 05 will have May as accounting period in GL.  
Problem Definition: With the above scenario, when we run the GL recon PS Query, this will show up as difference when ran for the month of April.  
 
Expected Result:  
This transaction should not show up on the April report at all.  It should show up as fully reconciled when we run the May recon report because this is not a reconciliation difference. The sub-system should base the reconciliation based on the accounting period of GL.  
 
1: Setting of the journal generator template.
Journal Date = Current date

2: Create an expense transaction with transaction date of April and post in journal to GL.

3: Then run the Load Recon Data (GL_RECN)  

You will notice that the accounting periods of the sub system transaction was derived from the transaction date for the first line. If it derived from GL (which is 5), it will shows the transaction as reconciled when we run this for next month.

The question is that: Is there any setting in the GL recon function to allow the sub system data to have fiscal year and accounting periods derived from GL instead of the accounting period of the transaction date?

Solution

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