As If Currency Processing
When you view job and billing data in the Project Status Inquiry program, you can view amounts in an as if currency. To view amounts in an as if currency, you must specify the currency code on the Work with Project Status Inquiry form. The system displays job and billing amounts in the as if currency for only the columns for which you selected the As If Currency Enabled check box when you set up the column.
When you set up visual alert columns, you select a basis column. The system enables as if currency for visual alert columns when the basis column of the visual alert column has as if currency processing enabled. For enabled visual alert columns, the system converts the threshold levels that you set up in a base currency on the Project Status Inquiry Column Definitions form to the currency that you specify on the Work with Project Status Inquiry form and then compares the converted threshold levels to the converted job and billing amounts to determine whether to display a visual alert icon.
The system uses the currency code in the Threshold Currency Code field to determine the base currency code from which the system converts the threshold levels when you view records in an as if currency. For example, if you specify CAD (Canadian dollars) in the Threshold Currency Code field and specify USD (US dollars) as the as if currency code in the Work with Project Status Inquiry form, then the system converts the threshold levels from CAD to USD before it compares the threshold levels to the converted job and billing amounts.
For example, suppose that:
You use a ledger type column definition as the basis column for a visual alert column.
Your base currency is Canadian dollars (CAD) and you want to display amounts in US dollars (USD) in the Project Status Inquiry form.
The exchange rate to convert CAD to USD is .957.
To have the system calculate and display amounts in USD and to trigger the visual alerts based on the converted USD amounts, you:
Select the As If Currency Enabled check box when you set up the ledger type column.
This example uses a ledger type column. You can also enable as if currency processing for other column types.
Select the ledger type column as the basis column when you set up the visual alert column.
Enter CAD in the Threshold Currency Code field for the visual alert column.
The system uses the currency code in this field as the basis currency.
Set up threshold levels of 10,000, 20,000, and 30,000.
On the Work with Project Status Inquiry form:
Enter USD in the As If Currency Code field.
Complete the As If Currency Exchange Rate Date field, or leave it blank to use the current date.
Run the process to generate job and billing data to view.
As it processes job and billing records, the system:
Converts the display of job and billing amounts from their base currencies to USD.
Converts the threshold levels to 9570, 19,140, and 28,710.
Compares the converted job and billing amounts to the converted threshold levels to determine whether to display a visual alert icon.