Currency Types

When you track multiple currencies in DPS, you store transactions and other data in multiple currencies and use this stored information to fulfill different business needs.

You cannot change a currency after related data has been posted. For example, you cannot change the project currency after you have posted expense charges against that project.

The following table explains how the Multicurrency feature tracks various currency types.

Currency Type Description To Specify the Currency

Functional

The currency of the primary economic environment in which a company operates. Normally, this is the currency in which cash is generated and expended by the company. For example, a company located in France would normally use the euro as its functional or home currency.

General ledger reports use a single currency, your company's functional currency, making it easy for you to analyze your financials.

Select the currency on the Activate Currencies page of the Setup application or in Settings > General > Currency in the desktop application.

If your enterprise also has multiple companies, use the Functional Currency option on the Currency tab of Settings > General > Company in the desktop application to select each company's functional currency.

Transaction

The currency in which you enter an individual transaction via Transaction Entry or the Purchasing application.

For example, if a United States-based company purchases materials from Mexico and is billed in Mexican pesos, enter the vendor invoice in the transaction currency of Mexican pesos.

Use the Currency option on the New File dialog box in Transaction Entry, or use the Currency Code option on the appropriate form in the Purchasing application.

Project

The currency in which you manage a project. This currency may be different from the functional currency of the project’s home company.

For each project, define the project currency at the top level of its work breakdown structure. The project currency applies to any and all lower levels (that is, phases or tasks) of the project's work breakdown structure. When labor or expense charges are made to a project, the charges are recorded in the project currency, as well as all other appropriate currencies.

Use the project currency for all project management purposes, including project reporting and project planning.

Use the Project Currency option on the General tab of the Projects hub.

Billing

The currency you use to generate invoices and billing reports for a specific project and all its phases and tasks.

For each project, define the billing currency at the top level of the work breakdown structure. The billing currency applies to any and all lower levels (that is, phases or tasks) of the project's work breakdown structure.

Note that project and billing currencies do not need to be the same. You can plan and manage a project in one currency and invoice the client in another currency.

Use the Billing Currency option on the General tab of the Projects hub.

Payment

The currency in which you make payments. This currency may be different from the transaction currency of the original receivable or payable.

The way that you set the payment currency varies, depending on the transaction type. Typically, the payment currency is the currency specified for an account that is subsequently referenced by a bank code.

For example, on an accounts payable voucher, the bank code determines the currency in which the check or electronic funds payment is made to the vendor.

Specify currencies for accounts on the General tab of Settings > Accounting > Chart of Accounts.

Specify accounts for bank codes on the Bank Codes tab of Settings > Accounting > Banks.

Consolidated Reporting

If you track multiple companies in DPS, this is the currency used to create consolidated financial statements for multiple companies using different functional currencies.

Specify the currency when you create the consolidation group (also called the reporting group) in Settings > Organization > Consolidated Reporting.

Presentation

Use a presentation currency to generate a report with all amounts expressed in a single currency.

For example, if you are generating a Project Summary report that includes projects managed in multiple currencies, but you want all project financial data to appear in euros on the report, select euros as the presentation currency.

You can specify a presentation currency on general ledger reports, certain project reports, and some CRM reports (such as the Opportunity List report).

The presentation currency can be any currency enabled for use by your enterprise.

In the Report Options dialog box, specify the Presentation Currency options, then select the date that should be used to calculate currency exchange rates for the report.

Account

Each account set up for use as a bank account (in Settings > Accounting > Banks) must have a currency. You can also specify a currency for other accounts if the balance of the account should be maintained in a currency other than the company’s functional currency (an account for a loan from a foreign bank, for example).

If you specify an account currency that is different from the company’s functional currency, the account is considered a foreign-denominated account.

Specify the account currency on the General tab of Settings > Accounting > Chart of Accounts

Tax

If you set up tax auditing for a company, you must select a currency for each tax code. In most cases, this is the currency in which you report and pay tax amounts to the taxing authority.

DPS stores tax amounts for transactions in the tax currency as well as in the transaction currency and other relevant types of currency.

Specify the currency for a tax code in the Tax Currency field in Settings > Accounting > Taxes.

When you generate the Sales List or the Tax Analysis report, you have the option to display tax basis amounts and tax amounts in the tax currency. You also have the option, in the Invoice Template Editor, to add an informational line to invoices that shows the tax amount in the tax currency. (This is only a note. In supporting detail for the invoice amount, tax amounts are displayed in the billing currency.)