Hi guys theres is any way to create a text field in the Module Editor in the Quote.and that field affect the price of the quote.
for sample i wanna do the follow:
I create a Quote in DOMINICAN PESOS and i put int he the custom field the exchange rate for USD dollar so this fild will affect only this quote.
You could create three custom fields:
. currency for conversion (eg: USD, EUR, JPY, etc…)
. exchange rate
. converted Amount
(You may put the currencies in a dropdown field if you want)
Then create a logic hook in which after_save which, after having checked that the excgange rate and the currency symbol have been filled it converts the original amount and saves it in the field containing the converted amount.
You can refer to the SugarCRM version 6.5 manual for more information
( http://support.sugarcrm.com/02_Documentation/04_Sugar_Developer/Sugar_Developer_Guide_6.5/03_Module_Framework/Logic_Hooks/02_Module_Hooks/after_save/ )
Your code should contain somewhere something like:
if($bean->fieldwithcurrencysymbol <>"" AND $bean->fieldwithexchangerate <>""){
$bean->fieldwithconvertedamount = $bean->fieldwithexchangerate * $bean->fieldwithoriginalamount
}In the above example you would have to replace the names of the fields and create the remaining code of the logic hook.
PS: I have not tried this code myself but it should provide you sufficient input to solve the rest.
Please post your full solution for the benefit of all when done!