Every pricelist has one currency. A price query names the currency it answers in, and prices from pricelists in other currencies are converted with your exchange rates. You decide which prices are set locally and which follow the base price.
- Daily ECB rates. Rates for every currency the European Central Bank publishes are fetched every 24 hours. You can set rates manually, and add currencies the ECB does not publish. Exchange rates
- Markup and stable prices. A pricelist can inherit from a parent in another currency. Its prices are converted at the ECB rate with your markup, and the rate is renewed when the ECB rate moves past a threshold you set, not every day, so local prices stay stable. Inheriting from another currency
- VAT per market. Each query names a tax area, and every result holds the price excluding and including VAT, and the VAT amount. VAT is rounded to each currency's precision, for example to whole yen. VAT Currencies
- Rounding per currency. A rounding profile per currency gives each market its own price points, such as prices ending in .99 or whole units. Rounding
- Reproducible. A query with
as_ofreturns the price, converted at the rate in force at that moment, so a quoted price can be reproduced for as long as its history is kept. Historical queries
A price query calculates in this order: price rules, currency conversion, VAT, rounding. A price inherited from a parent in another currency is converted first, and the pricelist's rules then apply to the converted price.