350 likes | 539 Views
Calculating Cross Rates and Reciprocal Rates Concept. Calculating Cross Rates and Reciprocal Rates. Calculating Cross Rates and Reciprocal Rates. Step 1. Begin by navigating to the Parameters page. Click the Scroll Down arrow. Calculating Cross Rates and Reciprocal Rates. Step 2.
E N D
Calculating Cross Rates and Reciprocal Rates Step 1 Begin by navigating to the Parameters page. Click theScroll Downarrow.
Calculating Cross Rates and Reciprocal Rates Step 2 Click theSet Up Financials/Supply Chainmenu.
Calculating Cross Rates and Reciprocal Rates Step 3 Click theCommon Definitionsmenu.
Calculating Cross Rates and Reciprocal Rates Step 4 Click theScroll Downarrow.
Calculating Cross Rates and Reciprocal Rates Step 5 Click theMarket Ratesmenu.
Calculating Cross Rates and Reciprocal Rates Step 6 Click theCross/Reciprocal Rate Calcmenu.
Calculating Cross Rates and Reciprocal Rates Step 7 A Run Control ID is an identifier that, when paired with your User ID, uniquely identifies the process you are running. The Run Control ID defines parameters that the system uses when a process is run. These parameters ensure that when a process runs in the background, the system does not prompt you for additional values.
Calculating Cross Rates and Reciprocal Rates Step 8 You can run this process by searching for an existing Run Control ID or you can add a new value. Creating a Run Control ID that is relevant to the process may help you remember it for future use. Click theAdd a New Valuetab.
Calculating Cross Rates and Reciprocal Rates Step 9 Click in theRun Control IDfield.
Calculating Cross Rates and Reciprocal Rates Step 10 Enter the desired information into theRun Control IDfield. Enter"CRRR1".
Calculating Cross Rates and Reciprocal Rates Step 11 Click theAddbutton.
Calculating Cross Rates and Reciprocal Rates Step 12 Use the Parameters page to enter the request parameters. The system uses these parameters to define the processing rules and data to be included when the process is run.
Calculating Cross Rates and Reciprocal Rates Step 13 Use the Market Rate Index field to select or enter a market rate index. Applications other than PeopleSoft Treasury should use the default index that you select for the exchange rate. In this example, accept the default.
Calculating Cross Rates and Reciprocal Rates Step 14 Use the From Common Currency field to specify a currency code to calculate a reciprocal rate. Click in theFrom Common Currencyfield.
Calculating Cross Rates and Reciprocal Rates Step 15 Enter the desired information into theFrom Common Currencyfield. Enter"EUR".
Calculating Cross Rates and Reciprocal Rates Step 16 Use the Exchange Rate Type field to enter the currency type for the exchange rate. Click in theExchange Rate Typefield.
Calculating Cross Rates and Reciprocal Rates Step 17 Enter the desired information into theExchange Rate Typefield. Enter"CRRNT".
Calculating Cross Rates and Reciprocal Rates Step 18 Use the As of Date field to specify the effective date of the newly created exchange rates, which are the output of the process. The as of date also determines the rates used as the basis for the calculations, which are the input of the process. The report uses the most current currency quotation method for the currency pair as the process input. If the as of date uses the current effective rate on the specified date, it can affect triangulation. For example, a USD to euro participating currency (EPC) triangulated rate effective April 1, 2004, might be comprised of the EUR to USD rate also effective April 1, 2004, and the fixed EUR to EPC rate effective on the date the newly participating country officially becomes a euro participating currency. Click in theAs of Datefield.
Calculating Cross Rates and Reciprocal Rates Step 19 Enter the desired information into theAs of Date: Requiredfield. Enter"01/01/2013".
Calculating Cross Rates and Reciprocal Rates Step 20 Select the Generate Report option to generate a report that displays the cross, triangulated, and reciprocal rate calculations performed by the process.
Calculating Cross Rates and Reciprocal Rates Step 21 Select the Override Existing Rates option to have the calculated rates override rates for the exchange rate type, regardless of the as of date.
Calculating Cross Rates and Reciprocal Rates Step 22 Select the Generate Reciprocal Rate option to calculate reciprocal rates for currency pairs that do not have the Auto Reciprocate option selected on the Currency Quotation Method page. You can select this option alone or in combination with the Generate Cross Rates and Rate Triangulate options. This process does not directly manipulate exchange rates. Instead, the system uses numerator and denominator values such that the following is true: (From Currency/RATE_DIV) × RATE_MULT = To Currency
Calculating Cross Rates and Reciprocal Rates Step 23 Select the Generate Cross Rates option to automatically generate cross rates. For example, to generate cross currency rates for USD, CAD, and MXP, you would enter USD to CAD = 1.473 and USD to MXP = 9.8793. The system would automatically generate CAD to MXP = 9.8793/1.473 = 6.7069246. If you choose to generate cross rates, the From Cur (from-currency) and To Cur (to-currency) fields appear, and you must select a From currency and a To currency. You can enter a wildcard (%) in either or both fields to indicate from all or to all currencies.
Calculating Cross Rates and Reciprocal Rates Step 24 Select the Rate Triangulate option to convert two currencies through a third currency. If you select the Rate Triangulate option, the From Cur (from-currency) and To Cur (to-currency) fields appear, and you must select a From currency and a To currency. You can enter a wildcard (%) in either or both fields to indicate from all or to all currencies.
Calculating Cross Rates and Reciprocal Rates Step 25 Click theRunbutton.
Calculating Cross Rates and Reciprocal Rates Step 26 Use the Process Scheduler Request page to enter or update parameters, such as server name and process output format.
Calculating Cross Rates and Reciprocal Rates Step 27 You must select a Server Name to identify the server on which the process will run. If you use the same Run Control ID for subsequent processes, the server name that you last used will appear by default in this field. Click theServer Namelist.
Calculating Cross Rates and Reciprocal Rates Step 28 Click thePSNTlist item.
Calculating Cross Rates and Reciprocal Rates Step 29 Click theOKbutton.
Calculating Cross Rates and Reciprocal Rates Step 30 Note the Process Instance number, which helps you identify the process that you have run when you check its status. Click theProcess Monitormenu.
Calculating Cross Rates and Reciprocal Rates Step 31 Use the Process List page to view the status of submitted process requests.
Calculating Cross Rates and Reciprocal Rates Step 32 The process is finished when the Run Status is Success. Continue to click the Refresh button until the Run Status is Success.
Calculating Cross Rates and Reciprocal Rates Step 33 You have successfully calculated cross-reciprocal rates. End of Procedure.