<< Back to Currencies page | CURRENCY calculation |
![]() |
Table tbl_currency_exchange
Currency code | Client code | Pricelist code | |
---|---|---|---|
DB-field/ index |
tce_codecurrency | tce_codecust | tce_codepricelist |
1. | A | X | |
2. | A | C | |
3. | A |
A customer X who belongs to the pricelist P has associated the currency C
A record in one of the next situations will be searched in the specified order. First record found gives the final result.
1. CURRENCY+CLIENT
It will be searched if there is a record with Currency code = C and Client code = X. If such a record exists, then this is the resulting exchange rate - this means that the client X has a specific exchange rate for the currency C
2. CURRENCY+PRICELIST
It will be searched if there is a record with Currency code = C, Pricelist = P and Client code empty. This means that the clients with pricelist P have an exchange rate for the currency C .
3. CURRENCY
It will be searched if there is a record with Currency code = C, Client code empty and Pricelist empty. This means that the currency C has a default exchange rate for all the clients.
Obs: If none of the above situations is fulfilled, the exchange rate will be 1 !