How the Currency Code Is Used in Searches

The currency code of the billing rate and markup table identifies the currency of the billing rates and markup amounts that comprise the markup rules for that table.

The system stores the domestic currency, the foreign currency, and the currency mode on each workfile transaction. The domestic currency represents the currency of the company. The foreign currency represents the currency of the customer. The currency mode indicates which currency is used to access the correct billing rate and markup table.

For example, a workfile transaction with a domestic currency of US dollars (USD) and a foreign currency of euro (EUR) with the currency mode of F searches for a billing rate and markup table that is set up for euros. All markup calculations are made in euros and use the exchange rate to calculate the US dollars.

This table displays the workfile transaction before markups are applied:

Business Unit (USD)

Dom Curr

For Curr

Curr Mode

Exch Rate

Dom Cost

Units

For Cost

Dom Invoice

For Invoice

501

USD

EUR

F

5.68

50.00

10

284.00

50.00

10

This table represents the billing rate and markup table:

Business Unit (USD)

Curr Code

Markup Override Rate

Markup Percent

Markup Amount

501

EUR

284.00

10

142.00

This table displays the workfile transaction after markups are applied:

Business Unit (USD)

Dom Curr

For Curr

Curr Mode

Exch Rate

Dom Cost

Units

For Cost

Dom Invoice

For Invoice

501

USD

EUR

F

5.68

50.00

10

284.00

575.00

3266.00