PeopleSoft FSCM 9.2: Cash Management - Oracle

PeopleSoft FSCM 9.2: Cash Management

March 2013

PeopleSoft FSCM 9.2: Cash Management CDSKU fscm92pbr0 Copyright ? 1992-2013, Oracle and/or its affiliates. All rights reserved.

Trademark Notice

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Intel and Intel Xeon are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks are used under license and are trademarks or registered trademarks of SPARC International, Inc. AMD, Opteron, the AMD logo, and the AMD Opteron logo are trademarks or registered trademarks of Advanced Micro Devices. UNIX is a registered trademark of The Open Group.

License Restrictions Warranty/Consequential Damages Disclaimer

This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license, transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverse engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is prohibited.

Warranty Disclaimer

The information contained herein is subject to change without notice and is not warranted to be error-free. If you find any errors, please report them to us in writing.

Restricted Rights Notice

If this is software or related documentation that is delivered to the U.S. Government or anyone licensing it on behalf of the U.S. Government, the following notice is applicable:

U.S. GOVERNMENT END USERS: Oracle programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, delivered to U.S. Government end users are "commercial computer software" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, use, duplication, disclosure, modification, and adaptation of the programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, shall be subject to license terms and license restrictions applicable to the programs. No other rights are granted to the U.S. Government.

Hazardous Applications Notice

This software or hardware is developed for general use in a variety of information management applications. It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications.

Third Party Content, Products, and Services Disclaimer

This software or hardware and documentation may provide access to or information on content, products, and services from third parties. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third-party content, products, and services. Oracle Corporation and its affiliates will not be responsible for any loss, costs, or damages incurred due to your access to or use of third-party content, products, or services.

Alpha and Beta Draft Documentation Notice

If this document is in preproduction status:

This documentation is in preproduction status and is intended for demonstration and preliminary use only. It may not be specific to the hardware on which you are using the software. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to this documentation and will not be responsible for any loss, costs, or damages incurred due to the use of this documentation.

Contents

Preface........................................................................................................................................................xiii Understanding the PeopleSoft Online Help and PeopleBooks........................................................... xiii PeopleSoft Hosted Documentation............................................................................................... xiii Locally Installed Help...................................................................................................................xiii Downloadable PeopleBook PDF Files......................................................................................... xiii Common Help Documentation..................................................................................................... xiii Field and Control Definitions....................................................................................................... xiv Typographical Conventions...........................................................................................................xiv ISO Country and Currency Codes................................................................................................. xv Region and Industry Identifiers......................................................................................................xv Access to Oracle Support..............................................................................................................xvi Documentation Accessibility.........................................................................................................xvi Using and Managing the PeopleSoft Online Help.............................................................................. xvi PeopleSoft FSCM Related Links.........................................................................................................xvi Contact Us...........................................................................................................................................xvii Follow Us............................................................................................................................................xvii

Chapter 1: Getting Started with PeopleSoft Cash Management..........................................................19 Cash Management Business Processes.................................................................................................19 Cash Management Integrations.............................................................................................................19 Cash Management Implementation...................................................................................................... 20

Chapter 2: Defining Cash Management Processing Options................................................................ 23 Establishing Cash Management Options.............................................................................................. 23 Defining Treasury Business Unit Options............................................................................................25 Page Used to Define Treasury Business Unit Options.................................................................. 25 Treasury Options Page................................................................................................................... 26 Defining Cross-Referenced Currency Codes and Holiday List IDs.....................................................30 Page Used to Define Cross-Referenced Currency Codes and Holiday List IDs............................30 Currency Code - Holiday List ID Cross Reference Page.............................................................. 30 Defining Market Rates..........................................................................................................................31 Pages Used to Define Market Rates.............................................................................................. 31 Market Rates Page..........................................................................................................................32 Market Rates - Market Rate Page..................................................................................................33 Rate Definition Page...................................................................................................................... 35 Securing ChartFields for PeopleSoft Treasury..................................................................................... 35 Integrating PeopleSoft Treasury with JD Edwards General Accounting............................................. 35

Chapter 3: Navigating in Treasury Management...................................................................................37 Navigating in Treasury Management................................................................................................... 37 Pages Used to Navigate in Treasury Management........................................................................ 37

Chapter 4: Managing Facilities................................................................................................................ 39 Understanding Facilities........................................................................................................................39 Understanding Facility Review.............................................................................................................39 Prerequisites.......................................................................................................................................... 39 Defining Facilities.................................................................................................................................40 Pages Used to Define Facilities..................................................................................................... 41 Memo Attributes Page....................................................................................................................41 Facility Definition Page................................................................................................................. 42 Monitoring Facilities.............................................................................................................................44

Copyright ? 1992-2013, Oracle and/or its affiliates. All rights reserved.

v

Contents

Pages Used to Monitor Facilities...................................................................................................44 Schedule Facility Review Page......................................................................................................44 Chapter 5: Managing Fees and Account Analysis................................................................................. 47 Understanding Managing Fees and Account Analysis.........................................................................47 Common Elements Used to Manage Fees and Analyze Accounts...................................................... 48 Setting Up Fee Structures.....................................................................................................................49 Pages Used to Set Up Fee Structure..............................................................................................49 Fee Transaction Tables Page.......................................................................................................... 50 Fee Codes Page.............................................................................................................................. 50 SQL Where Criteria Page.............................................................................................................. 53 Fee Structures - Structure Accounts Page..................................................................................... 53 Fee Structures - Structure Definition Page.................................................................................... 54 Fee Calculation Type - Fee Structure Page.................................................................................. 55 Comparing Fee Structures.................................................................................................................... 55 Pages Used to Compare Fee Structures.........................................................................................56 Fee Structure Comparison Page.....................................................................................................56 Performing Account Analysis...............................................................................................................56 Pages Used to Perform Account Analysis..................................................................................... 57 Common Elements Used to Perform Account Analysis................................................................57 Creating Statements Manually....................................................................................................... 58 Fee Statements - Information Page................................................................................................58 Fee Statements - Rates Page.......................................................................................................... 59 Fee Statements - Balance Compensation Page.............................................................................. 60 Fee Statements - Balance Adjustments Page.................................................................................60 Fee Statements - Service Charges Page.........................................................................................61 Fee Statements - Service Adjustments Page..................................................................................63 Automatically Importing Statement Information........................................................................... 64 Account Analysis Validation Page................................................................................................. 64 Using the Account Analysis Manager..................................................................................................65 Page Used for the Account Analysis Manager..............................................................................65 Account Analysis Manager Page................................................................................................... 65 Creating Fee Entries............................................................................................................................. 66 Pages Used to Create Fee Entries..................................................................................................66 Enter Fees Page.............................................................................................................................. 67 Chapter 6: Using Cash Forecasting to Manage Cash Positions............................................................69 Understanding Cash Forecasting.......................................................................................................... 69 Setting Up Cash Forecasting................................................................................................................ 70 Pages Used to Set Up Cash Forecasting........................................................................................70 Defining Time Sets.........................................................................................................................72 Define Time Sets Page...................................................................................................................72 Position Field Types Page.............................................................................................................. 74 Understanding Forecast Mapping.................................................................................................. 75 Forecast Mapping Page.................................................................................................................. 76 Position Source Set Page............................................................................................................... 77 Setting Up Position Sources...........................................................................................................78 Position Source Page......................................................................................................................79 Position Source Contacts Page.......................................................................................................80 Drill Back Details Page..................................................................................................................80 Selection Criteria Page................................................................................................................... 82 Working with Forecast Rules......................................................................................................... 84 Forecast Rules Page....................................................................................................................... 84

vi

Copyright ? 1992-2013, Oracle and/or its affiliates. All rights reserved.

Contents

Calculate Time Spans Page............................................................................................................86 Create Position Source SQL Page................................................................................................. 87 Worksheet Definition Page.............................................................................................................87 Worksheet Line Items Page............................................................................................................90 Generating the Cash Forecast............................................................................................................... 92 Pages Used to Generate the Cash Forecast................................................................................... 92 Understanding Manual Positions....................................................................................................93 Enter Manual Position Page...........................................................................................................93 Understanding Cash Forecast Calculations....................................................................................95 Schedule Cash Forecast Page.........................................................................................................96 Working with Cash Forecasting Presentation and Results................................................................... 97 Pages Used to Work with Cash Forecasting Presentation and Results.......................................... 97 Understanding Cash Forecasting Presentation and Results........................................................... 98 Cash Forecasting Results Page.................................................................................................... 100 Understanding the Cash Forecast Search.....................................................................................112 Cash Forecast Search Page.......................................................................................................... 112 Cash Forecast User Preferences Page.......................................................................................... 116 Performing the Cash Sweep from Cash Forecast Results........................................................... 117 Understanding Copy Cash Forecast Results................................................................................ 118 Copy Cash Forecast Results Page................................................................................................118 Copying Cash Forecast Results....................................................................................................119 Importing Cash Forecast Data............................................................................................................ 122 Integrating External Sources into Cash Forecasting.................................................................... 122 Page Used to Import Cash Forecasting Data...............................................................................123 Setting Up Integration Broker to Import Cash Forecast Data..................................................... 124 Import Cash Forecast Data Page..................................................................................................125 Creating Cash Forecast Reports......................................................................................................... 128 Pages Used to Create Cash Forecast Reports.............................................................................. 129 Worksheet Definition (Report) Page............................................................................................ 129 Cash Position Report Page...........................................................................................................130 Cash Position Variance Report Page............................................................................................132 Chapter 7: Managing Bilateral Netting.................................................................................................135 Understanding the Bilateral Netting Process......................................................................................135 Discounts Applied to Netted Transactions...................................................................................137 Common Elements Used to Manage Bilateral Netting...................................................................... 139 Prerequisites........................................................................................................................................ 140 Setting Up Bilateral Nets....................................................................................................................141 Pages Used to Set Up Bilateral Nets........................................................................................... 142 Prerequisites.................................................................................................................................. 143 Netting Participants Page............................................................................................................. 143 Add Multiple Suppliers Page....................................................................................................... 145 Add Multiple Customers Page..................................................................................................... 145 Netting Rules Page....................................................................................................................... 146 Netting Contracts - Primary Information Page............................................................................ 147 Netting Contracts - Settlement Information Page........................................................................149 Netting Exclusion Parameters Page............................................................................................. 150 Selecting Nets Automatically............................................................................................................. 150 Pages Used to Automatically Select Nets....................................................................................150 Automatic Netting Selection Page............................................................................................... 151 Creating Nets Manually...................................................................................................................... 151 Pages Used to Manually Create Nets.......................................................................................... 152

Copyright ? 1992-2013, Oracle and/or its affiliates. All rights reserved.

vii

Contents

Common Elements Used to Manually Create Nets..................................................................... 152 Manual Selection Page................................................................................................................. 152 Manual Select Netting - Settlement Inst Page............................................................................. 153 Manual Select Netting - Payables Page....................................................................................... 154 Adding Multiple Vouchers for Payables Manual Netting............................................................155 Manual Select Netting - Receivables Page.................................................................................. 155 Adding Multiple Items for Receivables Manual Netting.............................................................156 Adjusting Manually Netted Information............................................................................................ 156 Pages Used to Adjust Manually Netted Information................................................................... 157 Common Elements Used to Adjust Manually Netted Information..............................................157 Manual Adjustment Page............................................................................................................. 157 Adjust Netting - Settlement Instr Page........................................................................................ 159 Adjust Netting - Payables Page................................................................................................... 159 Adjust Netting - Receivables Page.............................................................................................. 160 Processing Multicurrency Nets........................................................................................................... 161 Multicurrency Netting Functionality............................................................................................161 Prerequisites.................................................................................................................................. 162 Processing Multicurrency Nets.................................................................................................... 162 Administering Nets............................................................................................................................. 164 Pages Used to Administer Nets................................................................................................... 164 Approve Netting Page.................................................................................................................. 164 Cancel Netting Page..................................................................................................................... 165 Closing Nets........................................................................................................................................ 165 Understanding the Net Closing Process in Pay Cycle Manager..................................................166 Inquiring on Bilateral Nets................................................................................................................. 166 Pages Used to Inquire on Bilateral Nets......................................................................................166 Chapter 8: Performing Cash Sweep to Manage Liquidity..................................................................167 Understanding Cash Sweep Functionality..........................................................................................167 Prerequisites.................................................................................................................................. 168 Defining and Approving a Cash Sweep Structure............................................................................. 168 Pages Used to Define and Approve a Cash Sweep Structure......................................................169 Overview of a Cash Sweep Structure.......................................................................................... 169 Cash Sweep Structure Page......................................................................................................... 173 Approve Cash Sweep Structure Page.......................................................................................... 178 Processing Cash Sweep and Reviewing the Results.......................................................................... 180 Pages Used to Run the Cash Sweep Process and Review the Results.........................................180 Overview of the Cash Sweep Processing and Results.................................................................180 Cash Sweep Request Page........................................................................................................... 181 Cash Sweep Results Page............................................................................................................ 182 Generating Cash Sweep Reports........................................................................................................ 185 Pages Used to Generate Cash Sweep Reports............................................................................. 186 Chapter 9: Transferring Funds.............................................................................................................. 187 Understanding the Funds Transfer Process........................................................................................ 187 Common Elements Used to Transfer Funds.......................................................................................191 Prerequisites........................................................................................................................................ 191 Creating and Approving Funds Transfer Templates...........................................................................191 Pages Used to Create and Approve Funds Transfer Templates................................................... 192 Enter Transfer Templates - Origin Page...................................................................................... 193 Prenotification Details Page......................................................................................................... 195 Enter Transfer Templates - Destination Page.............................................................................. 195 Enter Transfer Templates - Bank Routings Page.........................................................................199

viii

Copyright ? 1992-2013, Oracle and/or its affiliates. All rights reserved.

 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download