Pricing with Foreign Exchange (FX) Rates - PRISM

Understanding Foreign Exchange Rates and their use in PRISM

What is a Foreign Exchange (FX) Rate? 

Foreign exchange (Forex or FX) is the conversion of one currency into another at a specific rate of the day or period, known as the foreign exchange rate.

For example: to convert United States Dollars (USD) $ to Philippine Pesos (PHP) ₱, a USD-to-PHP FX rate would be utilised. 

Who do FX Rates affect in PRISM?

An FX rate will be used to calculate pricing in PRISM when: the currency of a Vendor Program in PRISM differs from the currency you wish to buy in. For example, The Microsoft CSP Program for Malaysia has pricing sourced from Microsoft in USD; however, purchases in Malaysia must be in MYR; therefore, a USD-MYR is used to create local currency pricing.

To understand the structure of each Vendor Program, we suggest reviewing the program guide for that program, which is available for download under the Vendor Program tile in PRISM.

How to view a pricelist in PRISM with a future FX rate?

Note: that the below examples should not be used for quoting or gauging actual prices, any pricing shown is an example only.

Within PRISM, If you have signed up for the Program in PRISM, navigate to the Programs Tab > under Active Signed Agreements heading > Select Manage under the Program Tile > then under the Program Tile, select Price List.

When viewing the pricelist, if there is a future FX rate in place, a message will be shown to users similar to the one highlighted below. The message will display the effective date that the new FX rate applies from, with a hyperlink against Click here to view the future pricelist.

Under the Future Pricelist screen, you will see a message about the future period with an option to revert back to the current price list should you require it. Use the dropdown list to select your Contract Agreement, then select View Price List button.

When viewing the future pricelist, you will be presented with an asterisked message which denotes what the FX rate used for said pricelist is.

How to view a pricelist in PRISM with a historical FX rate?

Note: that the below examples should not be used for quoting or gauging actual prices, any pricing shown is an example only.

Navigate to the Price Lists tab on the left-hand toolbar, then select the program name from the drop-down menu, then nominate the historical date under the Usage Reporting Date calendar selector. Then select View Price List.

When viewing the pricelist, if an FX rate is used, you will be presented with an asterisked message which denotes what the FX rate used for said pricelist is.

 

Viewing and Exporting Price Lists

Once you have accessed a price list, you can view the price list via your browser and can also export it as an Excel file.

On Screen within your Browser

The price list will load and appear below the View Price List button. 

Price Lists will contain the following base data: 

• Product Name
• Product SKU
• Partner Cost

Depending on the structure of the vendor Program, additional information may be presented if available, such as:

• Billing Cycle
• Product Unit
• Retail Estimate

Example:

Export Price List to an Excel File

To export the on-screen price list to a CSV file, please select the Generate XLS button located underneath the View Price List button. Once the Generate XLS button is selected, the file will download in the background and then be available in your downloads folder.

Note: Any pricing viewed or exported is done at the time of viewing and may not be valid for future purposes and quoting. 

Note: Any pricing examples shown in this user guide are examples only and should not be used for quoting purposes.