+ Start a Discussion

Opportunity Total Order Value Converted in a Validation Rule

We're using multi-currency and I want to create a validation rule (and workflow) that is based on Opportunity Amount in the base currency of the Org, not the Opportunity Amount. On a report I can list the Total Order Value (Converted) but as this field is not visible in the Validation Rule page and the only way I can see to do this currently is to create a new field and populate from Apex using the appropriate currency record. This would need to be recalculated everytime the Opp is saved, which is too late w.r.t. Validation.


Has anyone else found a better way to get the Total Order Value Converted used on the Reports in a Validation or Worklfow Rule ?

For anyone that's interested we did end up writing some Apex to get around this and update a custom field on the Opportunity. There are some 'gotchas' to be aware of, so if anyone is interested just drop a reply and I can explain the issues.
I would love to know how to do this if you're willing to share.