Hi,
I have a following challenge:
1. an invoice can be in EUR or USD currency
2. if the currency is EUR I want a particular field to have a certain value - No VAT
3. If the currency is USD I want the same field to have different value - 21
The issue is that changing the value of currency field does not change the dependent value. The currency field might be empty and when I enter EUR or USD nothing changes on the dependent field. I checked autocalculate and here is my Formula
IF(STRICMP(Currency,"EUR"),"No VAT","21").
Is my thinking correct or do I miss something?
Thanks.
Regards
Zdenek
------------------------------
Zdeněk Kabátek
Head of Professional Services
NEOOPS
http://www.neoops.com/Europe/Prague
------------------------------