PeopleSoft General Ledger
For your PeopleSoft, QA Automation Testing and Big Data training and job needs, Please contact eastbaytrng@gmail.com or (925) 322 3131
PeopleSoft GL is core of PeopleSoft Financial Management
System. It is integrated with other modules such as Purchasing, Expenses,
Payroll, AM, AR, AP, Billing, Inventory, Cost Management, EPM, Treasury, HRMS,
ELM and PC.
Below
diagram illustrates the GL flow of the implementation. This is not only
applicable for GL, even other modules AP, PO, AR (even any ERP modules) follow the same flow.
Implementation planning - Includes how
to structure the Business Unit, Tables and other business rules.
Tables Setup – Setting up Business
Unit, Installation Options, User
Preferences, Account Types, Details Calendars, Defining Chart fields, Creating Trees, Journal Processing setup such as Ledger
Templates, Ledger Group, Accounting Periods maintenance, Defining Journal Entry templates, Journal Source setup, Define ChartField Combination edits
Transaction Processing – Entering data
to GL using the Tables setup done in above step. Includes Entering Journals, Journal Edit
Process, Posting Journals, Copy Journals, Unposting Journals, Importaing Spreadsheet Journals, InterUnit
and IntraUnit Accounting.
Reporting – Performing Year-End Close. Reporting
results using PS/nVision which includes creating simple Matrix Layout, Report
Request and creating an Income Statement and Document Sequencing
GL Process Flow
Below
diagram shows the GL Process flow from feeder systems to summary ledger.
Feeder systems - Feeder systems can be non-PeopleSoft or
other PeopleSoft modules such as Payables, Receivables, or even PeopleSoft HRMS.
For example, PeopleSoft HRMS- Payroll
sends the Payroll summary information to account the payroll expenses in
GL module after the Payroll process completion during each pay period. Jounral
Generator is PeopleSoft process to integrate other PeopleSoft modules
transactions.
GL Menu navigation shows the most of the Setup Tables used in
the left side. Right side shows the
functions under the GL.
What is LEDGER?
Ledger represents a set of books for each business unit or
entity. The source for LEDGER is journal entries.
Ledger Table can represent multiple ledgers such as ACTUALS,
BUDGET, FORECAST, ENCUMBRANCE, STATistical or any other type of data.
What is Control Table
vs. Transaction Table?
Control Tables store the information related to Accounting
Structure and processing rules when a transaction is recorded.
Examples of Control tables are: Accounts, Departments,
Trees, Calendars
Generally control tables are keyed by SETID and
Effective-dated.
Transaction Tables are keyed by BUSINESS_UNIT which stores business activity such as
Journals, Vouchers, Balances and
Invoices.
Sample Transaction tables in GL are,
- o JRNL_HEADER - Journal Header Table
- o JRNL_LN - Journal Line Table
- o LEDGER – Ledger Table
Control tables relatively static, but transaction tables are
updated frequently.
JRNL_HEADER
Journal Header Data - Header Record for Journal.
Important Fields include the following:
JOURNAL_ID, JOURNAL_DATE, JRNL_HDR_STATUS,BUDGET_HDR_STATUS, DESCR254
JRNL_LN Journal Line Data - Line Record for Journal.
Important fields include the following: Journal
ID, Journal Line #, Department ID and Account (and Other Chartfields), Budget Line
Status, Distribution Amounts, Budget Dates, Close Flag
LEDGER Ledger Data - Summary of Balances by Chartfields by Fiscal Year, Accounting Period
Creating a Journal Entry - Revenue
Navigation: General Ledger > Journals
> Journal Entry > Create/Update Journal Entries
Deleting a Journal Entry
Navigation: General Ledger > Journals
> Journal Entry > Create/Update Journal Entries
Journal Entries in General Ledger can only
be deleted if they have not been posted.
For your PeopleSoft, QA Automation Testing and Big Data training and job needs, Please contact eastbaytrng@gmail.com or (925) 322 3131
For your PeopleSoft, QA Automation Testing and Big Data training and job needs, Please contact eastbaytrng@gmail.com or (925) 322 3131
