Oracle PeopleSoft Enterprise Financial Management 9.1 Implementation电子书

Oracle PeopleSoft Enterprise Financial Management 9.1 Implementation

Table of Contents

Oracle PeopleSoft Enterprise Financial Management 9.1 Implementation

Credits

About the Author

About the Reviewers

www.PacktPub.com

Support files, eBooks, discount offers, and more

Why subscribe?

Free access for Packt account holders

Instant updates on new Packt books

Preface

What this book covers

What you need for this book

Who this book is for

Conventions

Reader feedback

Customer support

Errata

Piracy

Questions

1. PeopleSoft Financials Fundamentals

Understanding Chart of Accounts and chartfields

Implementation challenge

PeopleSoft chartfields

Chartfield configuration

Standard chartfield configuration

Advanced chartfield configuration

Understanding Business Units and SetID

Business Unit

Tableset ID

Scenario 1

Scenario 2

Configuring SetID

Configuring TableSet Control

Understanding accounting structure—Ledgers and Journals

Configuring ledgers and Journal Generator

Configuring ledger templates

Implementation challenge

Solution

Configuring ledgers

Configuring ledger groups

Configuring ledgers for a Business Unit

Implementation challenge

Solution

Configuring journal sources

Configuring accounting entry definitions

Configuring journal templates

Configuring banks

Configuring bank ID qualifiers

Implementation challenge

Solution

Configuring banks

Configuring bank branches

Configuring external bank accounts

Understanding User Preferences

Defining Overall Preferences

Defining Process Group preferences

Defining Billing User Preferences

Defining General Ledger User Preferences

Defining Payables User Preferences

Defining Receivables User Preferences

Defining Receivables Write-off and Discount User Preferences

Understanding Setup Manager

Implementation challenge

Summary

2. PeopleSoft Security

Understanding user security

Implementation challenge

Solution

Configuring permission lists

Configuring roles

Configuring user profiles

Understanding row-level security

User ID level security

Permission list-level security

Specifying row-level security options

Applying security options

Defining row-level security values

Unit Security by Permission List

Unit Security by User ID

Summary

3. PeopleSoft Billing Module

Understanding the invoice lifecycle

Entering bill data

Receiving bill data from other modules or external sources

Billing interface tables

Understanding Bill By Identifier

Billing Interface (BIIF0001) process

Entering online bills manually

Understanding billing batch processes

Performing invoice adjustments

Adjusting the entire bill

Adjusting selected bill lines

Deferred revenue processing and unbilled revenue accrual

Deferred revenue processing

Unbilled revenue accrual

Understanding important billing configurations

Configuring invoice number IDs

Configuring distribution codes

Configuring invoice formatting options

Configuring billing charge codes

Configuring discounts and surcharges

Configuring billing business unit

Configuring bill types

Configuring bill sources

Implementation challenge 1

Solution

Implementation challenge 2

Solution

Summary

4. PeopleSoft Accounts Receivable Module

Understanding Accounts Receivable process flow

Understanding pending item accounting

System function ID

Understanding entry types and entry reasons

Configuring entry types and entry reasons

Item entry types and automatic entry types

Configuring item entry types

Implementation challenge

Solution

Configuring automatic entry types

Understanding pending item entry

Receivable Update process

Understanding item maintenance

Automatic maintenance

Maintenance worksheets

Understanding aging

Configuring aging ID

Dispute aging, Collection aging, and Deduction aging options

Executing aging batch process

Receiving customer payments

Entering payments manually

Entering regular deposits

Reference information section

Entering express deposits

Understanding electronic payments

Understanding lockbox payments

Understanding Excel spreadsheet payments

Understanding payment application

Understanding payment predictor

Item references

Configuring payment predictor method

Implementation challenge

Solution

Generate a Worksheet

Step 1

Step 2

Running the payment predictor process

Using payment worksheets

Customer correspondence

Customer statements

Configuring the statement ID

Running the customer statement multi-process job

Running the statement print multi-process job

Dunning letters

Configuring the letter codes

Configuring dunning ID

Running AR Dunning process

Running Dunning letter print process

Summary

5. PeopleSoft Asset Management Module

Asset Management processes

Understanding important asset configurations

Configuring asset books

Configuring asset categories

Configuring asset profiles

Configuring cost types

Configuring transaction codes

Configuring accounting entry templates

Configuring depreciation conventions

Depreciation convention

Convention Builder

Configuring depreciation schedules

Configuring depreciation limits

Capital acquisition plans

Adding new assets

Online asset entry

Adding asset basic details

Adding express assets

Loading assets through interface

Loading the data into staging tables

Previewing/approving the staged data

Validating the staged data

Loading the staged data into AM

Processing depreciation

Running Depreciation Calculation process

Previewing depreciation information for assets

Understanding asset adjustments

Understanding asset retirements

Manual asset retirement

Auto-retirement of fully depreciated assets

Creating accounting entries

Accounting entry creation (AM_AMAEDIST) process

Depreciation Close (AM_DPCLOSE) process

Loading reporting tables

Reviewing open transactions

Summary

6. PeopleSoft Accounts Payable Module

Understanding Accounts Payable process flow

Understanding Accounts Payable concepts

Understanding common configurations

Configuring accounting templates

Configuring voucher origins

Configuring miscellaneous charges

Configuring payment terms

Entering vouchers

Manual voucher entry

Voucher creation through automated interface

Understanding matching

Configuring match rule types

Configuring match rules

Configuring match rule control

Running the matching process

Match workbench

Posting vouchers

Maintaining vouchers

Deleting vouchers

Closing vouchers

Unposting vouchers

Processing payments

Configuring pay cycle steps

Configuring pay cycle step group

Specifying payment selection criteria

Running pay cycle using pay cycle manager

Pay cycle exceptions section

Resetting the pay cycle

Posting payments

Cancelling payments

Escheating payments

Withholding

Withholding configurations

Processing withholding

Summary

7. PeopleSoft General Ledger Module

Understanding journal processing

Journal creation

Using the Journal Generator process

Manual journal entry

Understanding intraunit and interunit journals

Scenario 1

Scenario 2

Understanding flat file journal entry

Using the journal edit process

Using the journal post process

Understanding interim and year-end closing

Understanding the PeopleSoft configurations for closing process

Creating chartfield value sets

Configuring closing rules

Configuring a closing process group

Running closing process

Understanding allocations

Allocation configurations

Configuring an allocation step

Implementation challenge

Solution

Configuring an allocation group

Running the allocation process

Summary

8. PeopleSoft Expenses Module

Understanding expenses processes

Understanding cash advance and expense report configurations

Maintaining employee profiles

Manually updating employee data

Loading employee data from PeopleSoft HRMS

Configuring cash advance sources

Configuring expense types

Configuring expense location amounts

Configuring per diem ranges

Configuring per diem amounts

Understanding expenses approvals

Defining approver types

Defining transaction definitions

Defining refining templates

Defining privilege templates

Configuring an approver profile

Assigning approvers to approver profiles

Configuring approver routing lists

Putting it all together

Interfacing external data with expenses

Importing credit card data

Importing benchmark data

Creating cash advances

Reconciling cash advances

Cash advance actions

Cash advance deletion

Cash advance closing

Processing expense reports

Creating an expense report

Verifying receipts

Running the expense processes

Payment processing

Summary

9. PeopleSoft Commitment Control

Understanding commitment control

Defining control budgets

Tracking expense transactions

Commitment control configurations

Enabling commitment control

Setting up system-level commitment control options

Defining commitment control ledgers and ledger groups

Defining commitment control budget calendars

Configuring tree definitions

Configuring control budget definitions

Linking the commitment control ledger group with actual ledger group

Defining commitment control transactions

Entering and processing budgets

Entering budget journals

Transferring budgets

Performing budget checking for transactions

Handling commitment control exceptions

Option 1: Adjusting the transaction

Option 2: Adjusting the budget

Option 3: Overriding the budget exceptions

Summary

Index