Overview of PeopleSoft Financial Supply Chain Management System

Introduction

• Presentation on PeopleSoft Financial Supply Chain Management.
• Demonstration of general ledger sample transactions in PeopleSoft Financials.

PeopleSoft Financial Management System (FMS)

• ERP application that records financial transactions from various sources.
• Processes recorded data based on business logic.
• Stores data in logical related database objects.
• Reports accounting transactions in detail or summary for business reporting.

Major Features of PeopleSoft FMS

• Multi-entity support
• Multi-currency capability
• Multi-language functionality
• Multi-book accounting
• Inter and intra-unit accounting
• Supports various tax reporting: VAT, Withholding, GST.
• Fiscal and statutory reporting.

Demonstration of Transaction Processing in PeopleSoft General Ledger

1. Login

   • Logged in as superuser (VP1).

2. Entering a Transaction

   • Business unit defaulted to "PUY01".
   • General ID set to next available number.
   • General date defaulted to current date.
   • Entered unbalanced journal entries (credit and debit amounts different).

3. Validation Process

   • Attempt to save unbalanced journal.
   • System flags an error: "General is not balanced".
   • Error details can be found in the error tab.

4. Balancing the Journal

   • Adjusted entries to balance the journal.
   • Status updated to valid ("V"), allowing posting.
   • Process completed and journal posted (Status "P").

5. Journal Submission for Approval

   • Changed source to "Online" which requires approval.
   • Submitted journal for approval.
   • Approval history can be checked for status updates.

6. Approval Process

   • Logged in as an approver to approve the journal.
   • Approval process completed, and status updated.
   • Approved journal ready for posting.

Viewing Posted Journals

• Navigated to General Ledger Review to view posted entries.
• Entered business unit and fiscal year to check entries.
• Displayed successful journal entries by account.

Generating Reports

1. Trial Balance Report

   • Navigation to generate a trial balance report.
   • Specified parameters: business unit, ledger, fiscal year.
   • Report generated and displayed summary.

2. Query Manager

   • Created a query selecting fields from the ledger record.
   • Results consistent with trial balance report.
   • Downloaded query results as an Excel file.

Importing Data from Third-party Systems

• Two templates for importing data: XML link and integration broker.
• Example of using XML link based import template demonstrated.
• Import process includes setup, entering data in the spreadsheet, and using import credentials.
• Successfully imported journals verified in the application.

Conclusion

• Demonstrated capturing transactions, processing, and reporting in PeopleSoft.
• Mentioned other modules in PeopleSoft Financial Management System to be discussed in future sessions.