I replied to another thread by Michel Conter -- he got pointed to a solution that SN disavows support of (since it's a customization, I'd guess).
The wiki does have an article or two about using Fixed Currency, but since it was in relation to catalog items I moved on and couldn't find anything more specific. I should have paid closer attention.
If you do set a field as Price type, an "Edit" link appears next to it when it's displayed on the form, which when clicked sends you to the matching record in the fx_price table. That record has a type field that you can change it from Multiple Currencies to Fixed. Once it's set to Fixed, it stays there.
You can create an after insert/update business rule that watches for changes to your price field that you want to keep in their original currencies, and have them update their matching record in fx_price to set the type to "fixed".
Since I had many such fields, I created a script include to handle this:
function setPriceAsFixed(grID, fld) {
var p = new GlideRecord("fx_price");
p.addQuery("id", grID);
p.addQuery("field", fld);
p.addQuery("type", "!=", "fixed");
p.query();
if (p.next()) {
p.type = "fixed";
p.update();
}
}
My version of that takes fld as an array and uses p.addQuery("field", "IN", fldArr) instead of that listed addQuery line (along with using a while(p.next())) , since some of my invoicing tables have multiple price fields per record.
