How to know the currency of a field?

There is no easy way...

There is only one currency per record, its id is in currency_id

The PDF amounts are formatted using the currency symbol rather than the currency's ISO4217

It would be really nice if there was a choice on which to use in the PDFs.

The only way I can think of to do what you need is to add a custom field to your module to hold that value, then include it in your PDF using smarty to format the amount without a symbol.

So your before_save logic hook will have something like:

if ($bean->currency_id == '-99'){
    $bean->reporting_currency_c = 'USD';
}else{
    $currencyBean = BeanFactory::retrieveBean('Currencies', $bean->currency_id);
    $bean->reporting_currency_c = $currencyBean->iso4217;
}

Note that your default currency has ID -99, for us that's USD

Hope this helps,
FrancescaS

There is no easy way...

There is only one currency per record, its id is in currency_id

The PDF amounts are formatted using the currency symbol rather than the currency's ISO4217

It would be really nice if there was a choice on which to use in the PDFs.

The only way I can think of to do what you need is to add a custom field to your module to hold that value, then include it in your PDF using smarty to format the amount without a symbol.

So your before_save logic hook will have something like:

if ($bean->currency_id == '-99'){
    $bean->reporting_currency_c = 'USD';
}else{
    $currencyBean = BeanFactory::retrieveBean('Currencies', $bean->currency_id);
    $bean->reporting_currency_c = $currencyBean->iso4217;
}

Note that your default currency has ID -99, for us that's USD

Hope this helps,
FrancescaS

I will try it.

Thank you so much.