PeopleSoft General Ledger (GL)

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

Navigation: 

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