[lamesa Contributions: 0Level 1☆]

I am trying to create an invoice saved search that will conditionally pull in either fxamount or amount based on if Multi Currency is enabled. If have tried the below formulas, but can't seem to get it working. Does anyone know if this is possible?

Formula 1: nvl({fxamount},{amount})

Formula 2: case when {fxamount} like '%ERROR%' then {amount} else {fxamount} end
This is a cached copy. Click here to see the original post.

[david.smith Contributions: 0Level 1☆]

Have you tried just using the fxamount by itself? I think it will return the currency being used.

[lamesa Contributions: 0Level 1☆]

Yes, in a non-multicurrency environment it does not work and the formula column will show an error.

[david.smith Contributions: 0Level 1☆]

Is this for a plug-in or bundle that will be installed to various accounts? If so, why not create both searches and use an installation script to write the correct search to the account.

[lamesa Contributions: 0Level 1☆]

This is for a bundle that will be installed in multiple accounts. The saved search is used as a sublist on a custom record. Is is possible through an installation script to dynamically change the sublist search on a custom record?

[david.smith Contributions: 0Level 1☆]

Good question. I know you can create it dynamically. I'm not sure about assigning it.

[lamesa Contributions: 0Level 1☆]

I ended up creating a bundle installation script and just dynamically modifying the search columns after install and update and that seems to be working great. Thanks for your help, David!

[Author]

Posts