New Contract Javscript Button - Number Conversion Error

Question

Problem Summary

I added a Create Contract Javascript Button to the Opportunity Page Layout. Once a user clicks on the button, it should create a new Contract with data populated from the Opportunity.

Layout

Error

A problem with the OnClick JavaScript for this button or link was encountered:

{faultcode:'soapenv:Client', faultstring:''USD 2.00' is not valid for the type xsd:dobule', }

Button Script

{!REQUIRESCRIPT('/soap/ajax/33.0/connection.js')} 

var contract = new sforce.SObject('Contract'); 
contract.Net_License__c = '{!Opportunity.Net_License__c }';
contract.Net_Maintenance_Amount__c = '{!Opportunity.Maintenance_Amount__c}';
contract.Net_Consulting_Amount__c = '{!Opportunity.Services_Amount__c }';
contract.Net_Training_Amount__c = '{!Opportunity.Net_Training_Amount__c}';
contract.Deal_Total_cal__c = '{!Opportunity.P_Amount__c}';
contract.OppOpp__c = '{!Opportunity.Opportunity_No__c}';

result = sforce.connection.create([contract]); 

if(result[0].success == 'true') {
    window.location = '/' + result[0].id ;
}
else {
    alert('Error');
}

Answer 1

At a basic level, all you have to do is replace all the non-digit characters (except .) so that you can parse the String into a Float. The resulting regex is /[^\.\d]/g. Try adopting the following approach:

{!REQUIRESCRIPT('/soap/ajax/33.0/connection.js')} 
var regex = new RegExp('[^\\.\\d]', 'g'),
    sanitize = new function (currency) {
        return parseFloat(currency.replace(regex, ''));
    },
    contract = new sforce.SObject('Contract'),
    result;

contract.Net_License__c = sanitize('{!Opportunity.Net_License__c }';
contract.Net_Maintenance_Amount__c = sanitize('{!Opportunity.Maintenance_Amount__c}');
contract.Net_Consulting_Amount__c = sanitize('{!Opportunity.Services_Amount__c }');
contract.Net_Training_Amount__c = sanitize('{!Opportunity.Net_Training_Amount__c}');
contract.Deal_Total_cal__c = sanitize('{!Opportunity.P_Amount__c}');
contract.OppOpp__c = sanitize('{!Opportunity.Opportunity_No__c}');

result = sforce.connection.create([contract]);
if(result[0].success == 'true') {
    window.location = '/' + result[0].id;
}
else {
    alert('Error');
}