Currency Calculations

If you use Multicurrency, you must perform currency calculations before creating vouchers.

If you do not use Multicurrency, the currencies in the input file must match the functional currency in Costpoint. If a difference exists, the import cannot take place until you correct the file. 

If you have Multicurrency, you must update currency exchange rates for selections in the input file before creating new Time & Expense vouchers during the import process.

Multicurrency Processing

Costpoint calculates functional amounts for Multicurrency records using the transaction amount, the exchange rate group, and the date selected on the Import TE Expenses/Advances screen. You can freeze the rates by selecting the Freeze Rate check box on the Import TE Expenses/Advances screen. Costpoint calculates the functional amounts using its standard methodology.

  • If the Pay Currency Code and Trans Currency Code are the same, the Pay Amount and Pay Exchange Rate Date are ignored.
  • The Pay Amount and Pay Exchange Rate Date can be used when the Pay Currency is not the same as the Transaction Currency.
  • If the Pay currency is different from the Trans Currency, you must provide a Pay Amount and it must equal the full amount of the voucher. No partial payments are allowed.
  • If no Pay Amount is provided, you must provide an Exchange Rate Date (to obtain the exchange rate).
  • The Pay Amount takes precedence when both a Pay Amt and an Exchange Rate are present.

Reports

The error report prints automatically when the validation process and currency calculation process are completed and when vouchers are successfully created. An error report prints even in the absence of errors; in this case, it reads "No errors found."

In addition, an edit report containing the Line Number, Expense Report Number or Advance ID, Account Number, Org Number, Project Number, Description, and Total for each voucher is generated. Costpoint displays a message noting that reports have been generated and that vouchers have been created.