This chapter provides a listing of the setup requirements for Cash Management tables and discusses how to:
Define business unit options.
Define cross-referenced currency codes and holiday list IDs.
Define market rates.
Securing ChartFields for PeopleSoft Enterprise Treasury
Integrating Enterprise Treasury with Enterprise One General Accounting.
This table provides a listing of custom navigation pages that are used to navigate to setup pages in Cash Management. These pages can be accessed through folders found on the Treasury Definitions Center page. This table lists the order the various components should be defined.
Page Name |
Navigation |
Usage |
Setup Information |
Treasury Definitions Center |
Treasury Definitions Center |
Access links, grouped by logical function, to setup pages for Treasury Management products. For easier retrieval, you can save this page in the My Favorites folder on the portal navigation menu. |
|
Banks |
Click Banks. |
Access pages to setup comprehensive bank information (such as bank, bank account, and bank branch information). |
See Setting Up Banks. See Setting Up Counterparties. See Setting Up External, Internal, and Netting Accounts. |
Business Unit Related |
Click Business Unit Related. |
Access the Treasury Options page and specify Treasury Management-specific options for your business units. |
|
Fees |
Click Fees. |
Access pages to setup fee codes, tables, and structures. |
|
Facilities |
Click Facilities. |
Access pages to setup and update facility information. |
See Defining Facilities. |
Settlements/Netting |
Click Settlements/Netting. |
Access pages to setup bilateral netting rules, participants, and contracts. |
|
Position Worksheet |
Click Position Worksheet. |
Access pages to setup field types, position sources, SQL, and time spans for position worksheets. |
|
Funds Transfer |
Click Funds Transfer. |
Access pages to setup and approve funds transfer templates. |
|
Bank Integration |
Click Bank Integration. |
Access pages to define and manage integration information between PeopleSoft and your banks, for your bank statement and payment activities. |
|
Rates |
Click Rates. |
Access pages to setup exchange rate, market rates, rate reset codes, and currency/holiday cross-reference information. |
See Defining Cross-Referenced Currency Codes and Holiday List IDs. |
Accounting |
Click Accounting. |
Access pages to setup accounting templates and events. |
|
Investment Pools |
Click Investment Pools. |
Access pages to set up and update investment pool and participant information. |
|
Deals and Instrument Types |
Click Deals/Instrument Types. |
Define deal instruments and templates, and perform deal portfolio activities. |
|
Analytics |
Click Analytics. |
Define risk management analytic functions, calculations, and vendor information. |
See Analyzing Risk. |
Hedges |
Click Hedges. |
Set up hedge groups, item sources, and strategies. |
This table lists additional pages used for setting up Cash Management that are not listed in the Treasury Definitions Center page.
Page Name |
Navigation |
Usage |
Setup Information |
Installation Options – Treasury |
Set Up Financials/Supply Chain, Install, Installation Options, Treasury |
Define integration options for accounting, EnterpriseOne integration, and Financial Gateway functionality. |
|
Business Calendar |
Set Up Financials/Supply Chain, Common Definitions, Calendars/Schedules, Business Calendar |
Indicate business days, nonbusiness days, and holidays for use in Cash Management and Deal Management processing functions. |
|
Bank Statement Accounting |
Banking, Administer Reconciliation, Bank Statement Accounting |
Define bank statement accounting match rules. The system searches the bank statement addenda for the transactional text you define, and automatically assigns a default accounting template to the transaction. |
See Setting Up Cash Management Bank Statement Accounting Functionality. |
ChartField Security |
Set Up Financials/Supply Chain, Security, ChartField Security |
Set up ChartField security for Treasury components. |
See Securing ChartFields. |
You must define default processing options (including VAT) for business units for use in Cash Management, Deal Management, and Risk Management.
Note. All Treasury applications use general ledger business units.
Page Name |
Definition Name |
Navigation |
Usage |
Treasury Options |
BUS_UNIT_OPT_TR |
Set Up Financials/Supply Chain, Business Unit Related, Treasury, Treasury Options |
Set up default processing options specific to your Treasury business units. |
Access the Treasury Options page (Set Up Financials/Supply Chain, Business Unit Related, Treasury, Treasury Options).
In this region you select workflow processing options for Deal Management and Cash Management. Workflow options specified here work in tandem with various deal settings at deal capture time. The system automatically generates workflow notifications when deals meet certain conditions.
Enable WF Deal Preview (enable workflow deal preview) |
Select to enable deal preview workflow processes. The system uses this option to generate workflow notification for three deals workflows (if you have implemented workflow). With this option selected, the following workflows are activated when meeting certain conditions:
|
Enable WF Auto Confo Worklist (enable workflow automatic confirmation worklist) |
Select to enable automated inbound deal confirmation workflow processes. |
Enable WF Invalid Confo Mail (enable workflow invalid confirmation mail) |
Select to enable workflow-based electronic mail processes for invalid or unmatched deal terms found during online confirmation. |
Calendar ID |
Select a detail calendar for the business unit. Note. You must define calendars for business units that you intend to "soft-close" using the Cash Management Fiscal Period Closure functionality. |
Internal Entity Code |
Select the inbound entity code to use for business units. |
External Entity Code |
Select the outbound entity code to use for counterparties. |
Note. Internal and external EDI entity codes enable PeopleSoft EDI Manager to correctly map deal-specific business units and counterparties to EDI data conversion rules.
Market Rate Index and Exchange Rate Type |
Select the appropriate index for each field. The system uses these fields to calculate base currency equivalents for foreign currency amounts when accounting entries are generated from accounting templates. |
Bank Transfer Accounting Build
Require Review |
Select to force accounting transactions that use this template to be reviewed. The system assigns error-free accounting entries using this template a Provisional status. You can then manually finalize the entry on the Review/Approve Entries page. If this check box is deselected, the system assigns error-free accounting entries using this template a Final status. |
Journal Template |
Select the journal template this business unit uses for its bank transfer accounting builds. |
BU Doc Sequencing Enabled |
Select to activate document sequencing functionality for this business unit's transactions. |
From Document Type |
If using document sequencing, define the document type to be used for assigning a document sequence number to the outbound bank account transfer transaction. |
To Document Type |
If using document sequencing, define the document type to be used for assigning a document sequence number to the inbound bank account transfer transaction. |
Settlement Approvals and Approval Method |
Select to require approval for settlements involving this business unit. In the Approval Method field, select the type of approval, either Manual (manual approvals) or Workflow (approvals based on PeopleSoft Workflow). |
Same User Select and Approve |
Select to enable the same user to both select and approve settlements. |
Auto-Schedule Position Update |
You must process a position update request for each deal to create the required records for position management, cash flows, and accounting events for your deals. If you select the check box, the system automatically processes a position update request, which creates the required records for position management and accounting, when you save an active deal. We recommend that you select this check box. |
Position Update Run Control ID |
Enter the run control ID to use for the automatically created position update requests; for example, enter AUTO-POSITION. Specify this run control on the Treasury Options page. |
Server Name |
Specify the name of the PeopleSoft Process Scheduler server that runs position update request processes. If you leave this field blank, the system uses the Default Operating System field as specified on the System Settings page to determine which server to run the process on. |
Hedge Type |
Select the accounting method used for the business unit's reporting of hedge and derivative transactions. The options are:
Note. A Treasury business unit can comply to only one set of accounting regulations. Treasury does not support multibook accounting. |
Click to access the Treasury BU VAT Options page and specify default VAT options for this business unit. The Treasury VAT Options link is available only if the General Ledger business unit that represents the Treasury Management business unit is linked to a VAT entity. |
|
VAT Defaults |
Click to access the VAT Defaults Setup page. The VAT Defaults Setup page is a common page used to set up VAT defaulting for all PeopleSoft applications processing VAT transactions. On this page you can define Treasury business unit defaults as applicable. See Working with VAT. |
Note. Deals do not appear on the Position Monitor or Position Manager until a position update request is processed. We recommend that you select the Auto-Schedule Position Update check box.
See Also
PeopleTools PeopleBook: PeopleSoft Process Scheduler
To cross reference holiday lists and currency codes, use the Currency Holiday List ID Cross Reference component (CUR_HOL_ID_XREF_GBL).
The system uses cross-referenced currency codes and holiday lists to determine eligible business dates for all Treasury business processes.
Page Name |
Definition Name |
Navigation |
Usage |
Currency Code - Holiday List ID Cross Reference |
CUR_HOL_ID_XREF |
Set Up Financials/Supply Chain, Product Related, Treasury, Currency/Holiday X-Ref |
Associate a holiday list with a particular currency. |
Access the Currency Code - Holiday List ID Cross Reference page (Set Up Financials/Supply Chain, Product Related, Treasury, Currency/Holiday X-Ref).
Holiday List ID |
Associate a holiday list ID with a specified currency code. You can also create additional currency codes and associate holiday list IDs to them. |
To define market and exchange codes, use the Market/Exchange Codes component (TRX_EXCHANGE_CD_GBL).
In addition to the PeopleSoft Common Definitions pages for defining and maintaining market rate data, Cash Management, Deal Management, and Risk Management use these additional market rate maintenance pages. These market rate pages enable you to specify criteria by which to retrieve and update multiple market rate definitions.
This section discusses how to:
Define market and exchange code information.
Define market rates.
View and add market rate information.
Edit rate variance information.
Define rate reset codes.
See Also
Page Name |
Definition Name |
Navigation |
Usage |
Market/Exchange Code |
TRX_EXCHANGE_CD |
Set Up Financials/Supply Chain, Product Related, Treasury, Market/Exchange Codes |
Define market and exchange information for a code. |
Market Rates |
RT_RATE_PNL |
Set Up Financials/Supply Chain, Product Related, Treasury, Market Rates |
Specify criteria by which to review rates and to add or update rates. |
Market Rates - Market Rate |
RT_RATE_PNL |
Set Up Financials/Supply Chain, Common Definitions, Market Rates, Market Rates. Click Edit on the Market Rates page. |
View details of a market rate, add a new market rate, and view exchange rate detail information. Note. To set up history rates for existing market rates use the component in Setup Financials/Supply Chain - Common Definitions - Market Rates. |
Rate Definition |
RT_RATE_DEF_SEC |
Click Rate Definition on the Market Rates - Market Rates page. |
Edit the maximum variance and error type information. |
Exchange Rate Detail |
EXCH_RT_DTL |
Click the Exchange Rate Detail icon on the Market Rates - Market Rates page. |
View exchange rate detail information. |
Rate Reset Codes |
TRX_RT_RESET_CD |
Set Up Financials/Supply Chain, Product Related, Treasury, Rate Reset Codes |
Define and associate a holiday list ID to a rate reset code. |
Access the Market Rates page (Set Up Financials/Supply Chain, Product Related, Treasury, Market Rates).
Note. The appearance of this page varies depending on the market rate category.
Selection Criteria
Enter the criteria by which to retrieve existing market rate definitions.
Term |
Specify a term code, indicating the length of time the rate is effective. |
Rate Type |
Select a market rate or exchange rate type. |
From Cur (from currency) and To Cur (to currency) |
Select the original and conversion currencies of the market rate. |
Include History |
Select to view market rate history for returned results. |
Add New Market Rate |
Click to access the Market Rates detail page and add a new rate type. The market rate definition (and, in the case of exchange rates, the currency quotation method for the from currency and to currency) must already exist. |
Market Rates
|
Click the Edit button to access the Market Rates - Market Rate page, and edit effective date and rate information. Note. To set up history rates for existing market rates use the component in Setup Financials/Supply Chain - Common Definitions - Market Rates. |
|
Click the Rate Defn (rate definition) button to access the Rate Definition page, and view information on the rate's maximum variance, error type, and day count basis. |
|
Click the Rate Detail button to access the Exchange Rate Detail page, and view exchange rate detail information. |
Access the Market Rates - Market Rate page (Set Up Financials/Supply Chain, Common Definitions, Market Rates, Market Rates).
Rate Definition |
Click to access the Rate Definition page, and edit variance and error type information for the rate definition. |
|
Click the Exchange Rate Detail button to access the Exchange Rate Detail page, and view rate information. |
Note. To use this page to add or change past rates, use the navigation: Set Up Financials/Supply Chain, Common Definitions, Market Rates, Market Rates. You must be in the correction mode to make changes to historical data.
See Also
Access the Rate Definition page (Click Rate Definition on the Market Rates - Market Rates page).
Maximum Variance |
The variance value validates the rates read from the market rate loader process. The system compares the prior historical rate to the one read and ensures that it's within a specified variance. If not, you are alerted with the specified error type. Enter a new Maximum Variance, and specify an Error Type of None, Stop, or Warning. |
PeopleSoft ChartField security provides a flexible, rule-based approach to administer security at a data level. ChartField security is supported in PeopleSoft Treasury and across other PeopleSoft Financials and Supply Chain Management (FSCM) applications. The ChartField security feature prevents unauthorized employees and contractors from viewing and editing sensitive financial data by restricting access to data stored with specific ChartField values.
The primary features for ChartField security are:
• Enforce security rules by user, role, or permission list.
• Enable ChartField security for all products or selectively by product.
• Enable or disable ChartField security selectively by component.
• Define rules to accommodate end-user areas of responsibility.
• Refine access rules by product feature or component.
• Support super user access to minimize setup.
• Define components as exceptions to override security rules.
For more information, see the PeopleSoft Enterprise Application Fundamentals PeopleBook:
See Securing ChartFields.
See Securing ChartFields for PeopleSoft Enterprise Treasury.
This integration provides users of EnterpriseOne General Ledger access to the robust Enterprise Treasury functionality contained in Cash, Deal, and Risk Management applications. The integration includes:
Transmitting market rates from the EnterpriseOne to the Enterprise system.
Transmitting accounting entry lines from Treasury products to the EnterpriseOne General Accounting ledger.
Transmitting banks statement data to the EnterpriseOne General Accounting ledger.
Generating a cash position worksheet (CPW) in Enterprise Cash Management from accounting data imported from the EnterpriseOne system.
With the exception of the cash position worksheet functionality, data integration is accomplished through the use of Integration Broker and specific XML messages. The data integration required to generate a cash position worksheet is accomplished using the JDBJ Java API to access the EnterpriseOne database directly.
Refer to the following documents for instruction on setting up and configuring the Enterprise Treasury to EnterpriseOne General Accounting integration.
See Also
JD Edwards EnterpriseOne Application Integrations with PeopleSoft Enterprise Applications
Defining Treasury Installation Options