frequently asked questions

All your questions in one place.

Currency used for an address

Currencies are generally stored with an internal ID. When needed, the ISO code can be easily retrieved.

Example

*/ Return the currency set in an address. If no currency is specified, CHF is returned, otherwise the ISO Code of the currency whose ID equals the data in ad_monnai is returned. The field ad_monnai must be available.

iif(empty(ad_monnai), 'CHF', mon_code(ad_monnai))

*/ Same as above, but for the currency of a document. In this case the field do_monnai must be available.

iif(empty(do_monnai), 'CHF', mon_code(do_monnai))

Did you find this article useful?

1 out of 1 found this helpful