<< 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.AX 
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 !