This website uses cookies. By continuing to browse the site, you are agreeing to our use of cookies
Enterprise Platform
October 3, 2013
The General Ledger module in earlier versions of Peoplesoft limited users to record only one date i.e. Trade Date which was used as the journal date. However PeopleSoft 9.2 offers utmost flexibility with the allowance of multiple dates for a single transaction. With PeopleSoft FSCM 9.2, users can easily record Trade Date and Settlement Date. Trade Date is Journal Date only and is captured at Journal Header level whereas settlement date is entered at line level. Further, various inquiry pages will also support reporting based on one of these dates which users will have the liberty to select.
Here are a few important features which have been introduced as part of this enhancement:
JRNL_LN – Two fields DATE_CODE and SETTLEMENT_DT have been added to support new functionality
LEDGET – DATE_CODE field introduced
DATE_CODE field – Possible Values 0, 1 and 2.
Date Code |
Description |
---|---|
0 | Both Trade Date & Settlement Date/Common |
1 | Trade Date |
2 | Settlement Date |
Step 1 – Select ‘Enable Posting by Date Codes check box on Ledger for a Unit > Journal Post Options page
You can review date code map by clicking on View Date Code Map hyperlink…
This setup will allow users control if a particular Journal Line should be posted by Journal Date, Settlement Date or using both. Users can select Date Code at Journal Line level to control this.
If this option is not selected and Settlement date on Journal Line differs from Journal Date and both the dates fall in different periods, the Journal line will be posted twice.
Step 2 – Select ‘Enter Date Code Adjustments’ check box on User Preferences > General Ledger page
This option enables user to be able to enter date codes adjustments at Journal Level.
How to use this functionality?
Every outcome starts with a conversation