Override Currency Conversion Details for Revenue Contract Lines

When you're required to use the conversion rate type specified in the source document, you can provide currency conversion details in the Revenue Basis Data Import template.

The application uses the conversion details provided on the source document instead of applying the conversion details defined in the Manage System Options for Revenue Management page.

Enter currency conversion details in these three columns in the VRM_SOURCE_DOCUMENTS worksheet:

Column Description
Conversion Rate Type
  • Used to convert the entered selling amount and the extended standalone selling price to the ledger currency.
  • The default value is blank, which means that when converting currency, the application uses the conversion rate type specified on the Manage System Options for Revenue Management page with the accounting contract date as the conversion date
Conversion Date
  • The application uses the conversion date and the conversion rate type to convert the entered selling amount and the extended standalone selling price to the ledger currency.
  • The default value is blank, which means that the application sets the conversion date to the source document date if the Conversion Rate Type is provided by the source. When no conversion rate type is provided by the source, the application uses the conversion rate type specified in the Manage System Options for Revenue Management page and sets the conversion date to the accounting contract date.
Conversion Rate
  • Used to convert the entered selling amount and the extended standalone selling price to the ledger currency.
  • Applies only when the conversion rate type is User. For other conversion rate types, the application ignores the conversion rate.

When the conversion rate type information is available on the source document worksheet, the application converts the entered selling amount and the extended standalone selling price using the source document information instead of the information specified in the Manage System Options for Revenue Management page.

Note: Make sure that you use the same conversion details for the invoice to offset the revenue clearing account.

Use the Correct Contract Document Errors spreadsheet to correct any conversion information you entered in the Revenue Basis Data Import template that failed validation. After you correct the errors, upload the corrected lines for further processing.