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))

Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Article is closed for comments.