O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Oracle PeopleSoft Enterprise Financial Management 9.1 Implementation

Oracle PeopleSoft Enterprise Financial Management 9.1 Implementation

by Ranjeet Yadav
Publisher: Packt Publishing
Release Date: June 2011
ISBN: 9781849681469
View table of contents
Start reading

Book Description

Build your PeopleSoft financial management skills on a firm foundation using this step-by-step tutorial. With the emphasis on real-world examples, you’ll quickly acquire the basics to configure and maintain industry leading applications.

  • A single concise book and eBook reference to guide you from PeopleSoft foundation concepts through to crucial configuration activities required for a successful implementation
  • Real-life implementation scenarios to demonstrate practical implementations of PeopleSoft features along with theoretical concepts
  • Expert tips for the reader based on wide implementation experience
  • Emphasis on presenting the key industry processes so that you understand not only PeopleSoft features but the business requirements that they support

In Detail

PeopleSoft financial management applications have been recognized as a leading ERP product across a wide range of industries that helps organizations automate their accounting operations, cut costs, and streamline business processes. They offer industry leading solutions for organizations' global needs, however complex they may be.

PeopleSoft Enterprise Financial Management 9.1 Implementation is probably the only learning resource for a novice practitioner, who may otherwise have to rely on thousands of pages of documentation for such a complex ERP system. This book covers all the crucial elements of PeopleSoft Financials—a business processes, configuration, and implementation guide. This is the ideal one-stop resource before entering the world of PeopleSoft implementation.

Beginning with the fundamentals of a generic financial ERP system, this book moves on to basic PeopleSoft concepts and then dives into discussing the individual modules in detail.

You will see how to leverage financial modules such as Billing, Accounts Receivable, Accounts Payable, Asset Management, Expenses, and General Ledger. Dedicated chapters discuss key PeopleSoft features such as application security and commitment control for budgeting. You will learn fundamental ERP concepts such as the chart of accounts, used by organizations for recording and reporting financial transactions, and how to implement them in PeopleSoft through chartfields, business units, and SetIDs.

A complete overview of PeopleSoft Financial application features, enabling you to implement them almost effortlessly

Table of Contents

  1. Oracle PeopleSoft Enterprise Financial Management 9.1 Implementation
    1. Oracle PeopleSoft Enterprise Financial Management 9.1 Implementation
    2. Credits
    3. About the Author
    4. About the Reviewers
    5. www.PacktPub.com
          1. Support files, eBooks, discount offers, and more
            1. Why subscribe?
            2. Free access for Packt account holders
            3. Instant updates on new Packt books
    6. Preface
      1. What this book covers
      2. What you need for this book
      3. Who this book is for
      4. Conventions
      5. Reader feedback
      6. Customer support
        1. Errata
        2. Piracy
        3. Questions
    7. 1. PeopleSoft Financials Fundamentals
      1. Understanding Chart of Accounts and chartfields
        1. Implementation challenge
        2. PeopleSoft chartfields
        3. Chartfield configuration
          1. Standard chartfield configuration
          2. Advanced chartfield configuration
      2. Understanding Business Units and SetID
        1. Business Unit
        2. Tableset ID
          1. Scenario 1
          2. Scenario 2
        3. Configuring SetID
        4. Configuring TableSet Control
      3. Understanding accounting structure—Ledgers and Journals
        1. Configuring ledgers and Journal Generator
          1. Configuring ledger templates
            1. Implementation challenge
            2. Solution
          2. Configuring ledgers
          3. Configuring ledger groups
          4. Configuring ledgers for a Business Unit
            1. Implementation challenge
            2. Solution
          5. Configuring journal sources
          6. Configuring accounting entry definitions
          7. Configuring journal templates
      4. Configuring banks
        1. Configuring bank ID qualifiers
            1. Implementation challenge
            2. Solution
        2. Configuring banks
        3. Configuring bank branches
        4. Configuring external bank accounts
      5. Understanding User Preferences
        1. Defining Overall Preferences
        2. Defining Process Group preferences
        3. Defining Billing User Preferences
        4. Defining General Ledger User Preferences
        5. Defining Payables User Preferences
        6. Defining Receivables User Preferences
        7. Defining Receivables Write-off and Discount User Preferences
      6. Understanding Setup Manager
        1. Implementation challenge
      7. Summary
    8. 2. PeopleSoft Security
      1. Understanding user security
        1. Implementation challenge
        2. Solution
        3. Configuring permission lists
        4. Configuring roles
        5. Configuring user profiles
      2. Understanding row-level security
        1. User ID level security
        2. Permission list-level security
        3. Specifying row-level security options
        4. Applying security options
        5. Defining row-level security values
          1. Unit Security by Permission List
          2. Unit Security by User ID
      3. Summary
    9. 3. PeopleSoft Billing Module
      1. Understanding the invoice lifecycle
      2. Entering bill data
        1. Receiving bill data from other modules or external sources
          1. Billing interface tables
          2. Understanding Bill By Identifier
          3. Billing Interface (BIIF0001) process
        2. Entering online bills manually
      3. Understanding billing batch processes
      4. Performing invoice adjustments
        1. Adjusting the entire bill
        2. Adjusting selected bill lines
      5. Deferred revenue processing and unbilled revenue accrual
        1. Deferred revenue processing
        2. Unbilled revenue accrual
      6. Understanding important billing configurations
        1. Configuring invoice number IDs
        2. Configuring distribution codes
        3. Configuring invoice formatting options
        4. Configuring billing charge codes
        5. Configuring discounts and surcharges
        6. Configuring billing business unit
        7. Configuring bill types
        8. Configuring bill sources
            1. Implementation challenge 1
              1. Solution
            2. Implementation challenge 2
              1. Solution
      7. Summary
    10. 4. PeopleSoft Accounts Receivable Module
      1. Understanding Accounts Receivable process flow
      2. Understanding pending item accounting
        1. System function ID
        2. Understanding entry types and entry reasons
          1. Configuring entry types and entry reasons
          2. Item entry types and automatic entry types
          3. Configuring item entry types
            1. Implementation challenge
            2. Solution
          4. Configuring automatic entry types
      3. Understanding pending item entry
        1. Receivable Update process
      4. Understanding item maintenance
        1. Automatic maintenance
        2. Maintenance worksheets
      5. Understanding aging
        1. Configuring aging ID
          1. Dispute aging, Collection aging, and Deduction aging options
        2. Executing aging batch process
      6. Receiving customer payments
        1. Entering payments manually
          1. Entering regular deposits
            1. Reference information section
          2. Entering express deposits
        2. Understanding electronic payments
          1. Understanding lockbox payments
          2. Understanding Excel spreadsheet payments
      7. Understanding payment application
        1. Understanding payment predictor
          1. Item references
          2. Configuring payment predictor method
            1. Implementation challenge
            2. Solution
              1. Generate a Worksheet
                1. Step 1
                2. Step 2
          3. Running the payment predictor process
        2. Using payment worksheets
      8. Customer correspondence
        1. Customer statements
          1. Configuring the statement ID
          2. Running the customer statement multi-process job
          3. Running the statement print multi-process job
        2. Dunning letters
          1. Configuring the letter codes
          2. Configuring dunning ID
          3. Running AR Dunning process
          4. Running Dunning letter print process
      9. Summary
    11. 5. PeopleSoft Asset Management Module
      1. Asset Management processes
      2. Understanding important asset configurations
        1. Configuring asset books
        2. Configuring asset categories
        3. Configuring asset profiles
        4. Configuring cost types
        5. Configuring transaction codes
        6. Configuring accounting entry templates
        7. Configuring depreciation conventions
          1. Depreciation convention
          2. Convention Builder
        8. Configuring depreciation schedules
        9. Configuring depreciation limits
      3. Capital acquisition plans
      4. Adding new assets
        1. Online asset entry
          1. Adding asset basic details
          2. Adding express assets
          3. Loading assets through interface
            1. Loading the data into staging tables
            2. Previewing/approving the staged data
            3. Validating the staged data
            4. Loading the staged data into AM
      5. Processing depreciation
        1. Running Depreciation Calculation process
        2. Previewing depreciation information for assets
      6. Understanding asset adjustments
      7. Understanding asset retirements
        1. Manual asset retirement
        2. Auto-retirement of fully depreciated assets
      8. Creating accounting entries
        1. Accounting entry creation (AM_AMAEDIST) process
        2. Depreciation Close (AM_DPCLOSE) process
      9. Loading reporting tables
      10. Reviewing open transactions
      11. Summary
    12. 6. PeopleSoft Accounts Payable Module
      1. Understanding Accounts Payable process flow
      2. Understanding Accounts Payable concepts
      3. Understanding common configurations
        1. Configuring accounting templates
        2. Configuring voucher origins
        3. Configuring miscellaneous charges
        4. Configuring payment terms
      4. Entering vouchers
        1. Manual voucher entry
        2. Voucher creation through automated interface
      5. Understanding matching
        1. Configuring match rule types
        2. Configuring match rules
        3. Configuring match rule control
        4. Running the matching process
        5. Match workbench
      6. Posting vouchers
      7. Maintaining vouchers
        1. Deleting vouchers
        2. Closing vouchers
        3. Unposting vouchers
      8. Processing payments
        1. Configuring pay cycle steps
        2. Configuring pay cycle step group
        3. Specifying payment selection criteria
        4. Running pay cycle using pay cycle manager
          1. Pay cycle exceptions section
          2. Resetting the pay cycle
        5. Posting payments
        6. Cancelling payments
        7. Escheating payments
      9. Withholding
        1. Withholding configurations
        2. Processing withholding
      10. Summary
    13. 7. PeopleSoft General Ledger Module
      1. Understanding journal processing
        1. Journal creation
          1. Using the Journal Generator process
          2. Manual journal entry
            1. Understanding intraunit and interunit journals
            2. Scenario 1
            3. Scenario 2
          3. Understanding flat file journal entry
        2. Using the journal edit process
        3. Using the journal post process
      2. Understanding interim and year-end closing
        1. Understanding the PeopleSoft configurations for closing process
          1. Creating chartfield value sets
          2. Configuring closing rules
          3. Configuring a closing process group
          4. Running closing process
      3. Understanding allocations
        1. Allocation configurations
          1. Configuring an allocation step
            1. Implementation challenge
            2. Solution
          2. Configuring an allocation group
        2. Running the allocation process
      4. Summary
    14. 8. PeopleSoft Expenses Module
      1. Understanding expenses processes
      2. Understanding cash advance and expense report configurations
        1. Maintaining employee profiles
          1. Manually updating employee data
          2. Loading employee data from PeopleSoft HRMS
        2. Configuring cash advance sources
        3. Configuring expense types
        4. Configuring expense location amounts
        5. Configuring per diem ranges
        6. Configuring per diem amounts
      3. Understanding expenses approvals
        1. Defining approver types
        2. Defining transaction definitions
        3. Defining refining templates
        4. Defining privilege templates
        5. Configuring an approver profile
        6. Assigning approvers to approver profiles
        7. Configuring approver routing lists
        8. Putting it all together
      4. Interfacing external data with expenses
        1. Importing credit card data
        2. Importing benchmark data
      5. Creating cash advances
        1. Reconciling cash advances
        2. Cash advance actions
          1. Cash advance deletion
          2. Cash advance closing
      6. Processing expense reports
        1. Creating an expense report
        2. Verifying receipts
        3. Running the expense processes
        4. Payment processing
      7. Summary
    15. 9. PeopleSoft Commitment Control
      1. Understanding commitment control
        1. Defining control budgets
        2. Tracking expense transactions
      2. Commitment control configurations
        1. Enabling commitment control
        2. Setting up system-level commitment control options
        3. Defining commitment control ledgers and ledger groups
        4. Defining commitment control budget calendars
        5. Configuring tree definitions
        6. Configuring control budget definitions
        7. Linking the commitment control ledger group with actual ledger group
        8. Defining commitment control transactions
      3. Entering and processing budgets
        1. Entering budget journals
          1. Transferring budgets
        2. Performing budget checking for transactions
      4. Handling commitment control exceptions
        1. Option 1: Adjusting the transaction
        2. Option 2: Adjusting the budget
        3. Option 3: Overriding the budget exceptions
      5. Summary