book

Oracle PeopleSoft Enterprise Financial Management 9.1 Implementation

Name: Oracle PeopleSoft Enterprise Financial Management 9.1 Implementation
Author: Ranjeet Yadav
ISBN: 9781849681469

by Ranjeet Yadav

June 2011

Beginner to intermediate

412 pages

9h 28m

English

Packt Publishing

Read now

Unlock full access

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 moreWhy subscribe?Free access for Packt account holdersInstant 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
ErrataPiracyQuestions
1. PeopleSoft Financials Fundamentals
Understanding Chart of Accounts and chartfieldsImplementation challengePeopleSoft chartfieldsChartfield configurationStandard chartfield configurationAdvanced chartfield configuration
Understanding Business Units and SetID
Business UnitTableset IDScenario 1Scenario 2Configuring SetIDConfiguring TableSet Control
Understanding accounting structure—Ledgers and Journals
Configuring ledgers and Journal GeneratorConfiguring ledger templatesImplementation challengeSolutionConfiguring ledgersConfiguring ledger groupsConfiguring ledgers for a Business UnitImplementation challengeSolutionConfiguring journal sourcesConfiguring accounting entry definitionsConfiguring journal templates
Configuring banks
Configuring bank ID qualifiersImplementation challengeSolutionConfiguring banksConfiguring bank branchesConfiguring external bank accounts
Understanding User Preferences
Defining Overall PreferencesDefining Process Group preferencesDefining Billing User PreferencesDefining General Ledger User PreferencesDefining Payables User PreferencesDefining Receivables User PreferencesDefining Receivables Write-off and Discount User Preferences
Understanding Setup Manager
Implementation challenge
Summary
2. PeopleSoft Security
Understanding user securityImplementation challengeSolutionConfiguring permission listsConfiguring rolesConfiguring user profiles
Understanding row-level security
User ID level securityPermission list-level securitySpecifying row-level security optionsApplying security optionsDefining row-level security valuesUnit Security by Permission ListUnit Security by User ID
Summary
3. PeopleSoft Billing Module
Understanding the invoice lifecycle
Entering bill data
Receiving bill data from other modules or external sourcesBilling interface tablesUnderstanding Bill By IdentifierBilling Interface (BIIF0001) processEntering online bills manually
Understanding billing batch processes
Performing invoice adjustments
Adjusting the entire billAdjusting selected bill lines
Deferred revenue processing and unbilled revenue accrual
Deferred revenue processingUnbilled revenue accrual
Understanding important billing configurations
Configuring invoice number IDsConfiguring distribution codesConfiguring invoice formatting optionsConfiguring billing charge codesConfiguring discounts and surchargesConfiguring billing business unitConfiguring bill typesConfiguring bill sourcesImplementation challenge 1SolutionImplementation challenge 2Solution
Summary
4. PeopleSoft Accounts Receivable Module
Understanding Accounts Receivable process flow
Understanding pending item accounting
System function IDUnderstanding entry types and entry reasonsConfiguring entry types and entry reasonsItem entry types and automatic entry typesConfiguring item entry typesImplementation challengeSolutionConfiguring automatic entry types
Understanding pending item entry
Receivable Update process
Understanding item maintenance
Automatic maintenanceMaintenance worksheets
Understanding aging
Configuring aging IDDispute aging, Collection aging, and Deduction aging optionsExecuting aging batch process
Receiving customer payments
Entering payments manuallyEntering regular depositsReference information sectionEntering express depositsUnderstanding electronic paymentsUnderstanding lockbox paymentsUnderstanding Excel spreadsheet payments
Understanding payment application
Understanding payment predictorItem referencesConfiguring payment predictor methodImplementation challengeSolutionGenerate a WorksheetStep 1Step 2Running the payment predictor processUsing payment worksheets
Customer correspondence
Customer statementsConfiguring the statement IDRunning the customer statement multi-process jobRunning the statement print multi-process jobDunning lettersConfiguring the letter codesConfiguring dunning IDRunning AR Dunning processRunning Dunning letter print process
Summary
5. PeopleSoft Asset Management Module
Asset Management processes
Understanding important asset configurations
Configuring asset booksConfiguring asset categoriesConfiguring asset profilesConfiguring cost typesConfiguring transaction codesConfiguring accounting entry templatesConfiguring depreciation conventionsDepreciation conventionConvention BuilderConfiguring depreciation schedulesConfiguring depreciation limits
Capital acquisition plans
Adding new assets
Online asset entryAdding asset basic detailsAdding express assetsLoading assets through interfaceLoading the data into staging tablesPreviewing/approving the staged dataValidating the staged dataLoading the staged data into AM
Processing depreciation
Running Depreciation Calculation processPreviewing depreciation information for assets
Understanding asset adjustments
Understanding asset retirements
Manual asset retirementAuto-retirement of fully depreciated assets
Creating accounting entries
Accounting entry creation (AM_AMAEDIST) processDepreciation 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 templatesConfiguring voucher originsConfiguring miscellaneous chargesConfiguring payment terms
Entering vouchers
Manual voucher entryVoucher creation through automated interface
Understanding matching
Configuring match rule typesConfiguring match rulesConfiguring match rule controlRunning the matching processMatch workbench
Posting vouchers
Maintaining vouchers
Deleting vouchersClosing vouchersUnposting vouchers
Processing payments
Configuring pay cycle stepsConfiguring pay cycle step groupSpecifying payment selection criteriaRunning pay cycle using pay cycle managerPay cycle exceptions sectionResetting the pay cyclePosting paymentsCancelling paymentsEscheating payments
Withholding
Withholding configurationsProcessing withholding
Summary
7. PeopleSoft General Ledger Module
Understanding journal processingJournal creationUsing the Journal Generator processManual journal entryUnderstanding intraunit and interunit journalsScenario 1Scenario 2Understanding flat file journal entryUsing the journal edit processUsing the journal post process
Understanding interim and year-end closing
Understanding the PeopleSoft configurations for closing processCreating chartfield value setsConfiguring closing rulesConfiguring a closing process groupRunning closing process
Understanding allocations
Allocation configurationsConfiguring an allocation stepImplementation challengeSolutionConfiguring an allocation groupRunning the allocation process
Summary
8. PeopleSoft Expenses Module
Understanding expenses processes
Understanding cash advance and expense report configurations
Maintaining employee profilesManually updating employee dataLoading employee data from PeopleSoft HRMSConfiguring cash advance sourcesConfiguring expense typesConfiguring expense location amountsConfiguring per diem rangesConfiguring per diem amounts
Understanding expenses approvals
Defining approver typesDefining transaction definitionsDefining refining templatesDefining privilege templatesConfiguring an approver profileAssigning approvers to approver profilesConfiguring approver routing listsPutting it all together
Interfacing external data with expenses
Importing credit card dataImporting benchmark data
Creating cash advances
Reconciling cash advancesCash advance actionsCash advance deletionCash advance closing
Processing expense reports
Creating an expense reportVerifying receiptsRunning the expense processesPayment processing
Summary
9. PeopleSoft Commitment Control
Understanding commitment controlDefining control budgetsTracking expense transactions
Commitment control configurations
Enabling commitment controlSetting up system-level commitment control optionsDefining commitment control ledgers and ledger groupsDefining commitment control budget calendarsConfiguring tree definitionsConfiguring control budget definitionsLinking the commitment control ledger group with actual ledger groupDefining commitment control transactions
Entering and processing budgets
Entering budget journalsTransferring budgetsPerforming budget checking for transactions
Handling commitment control exceptions
Option 1: Adjusting the transactionOption 2: Adjusting the budgetOption 3: Overriding the budget exceptions
Summary
Index

Content preview from Oracle PeopleSoft Enterprise Financial Management 9.1 Implementation

Creating accounting entries

Because Asset Management is a part of financial applications, one of its important functions is to maintain accounting entries for various asset transactions. We saw that PeopleSoft offers the following delivered transaction types: ADD, ADJ, TRF, RCT, DPR, PDP, RET, LPY, and INF. These represent various transactions for which accounting entries are created.

In PeopleSoft AM, there are two different processes that create accounting entries:

Accounting Entry Creation (AM_AMAEDIST), which creates accounting entries for all non-depreciation transactions
Depreciation Close (AM_DPCLOSE), which creates accounting entries only for depreciation in an accounting period

Note

Every time a transaction such as asset addition, adjustment, ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Read now

Unlock full access

More than 5,000 organizations count on O’Reilly

O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.

Julian F.

Head of Cybersecurity

I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.

Addison B.

Field Engineer

I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.

Amir M.

Data Platform Tech Lead

I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.

Mark W.

Embedded Software Engineer

Managing PeopleSoft on the Oracle Cloud: Best Practices with PeopleSoft Cloud Manager

Publisher Resources

ISBN: 9781849681469Other

Cloud Computing

Data Engineering

Data Science

AI & ML

Programming Languages

Software Architecture

IT/Ops

Security

Design

Business

Soft Skills

Oracle PeopleSoft Enterprise Financial Management 9.1 Implementation

by Ranjeet Yadav

Creating accounting entries

Note

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.