Page tree
Skip to end of metadata
Go to start of metadata

MAPPING INVOICE TOTAL AMOUNT FROM QUICKBOOKS RECEIVEPAYMENTS TO SALESFORCE RECIEVABLES
ISSUE :
When querying Recive Payments object from Quickbooks Desktop we don't get subtotal value, to map it to AVSFQB_Total_Invoice_Amount_c for Recievables in Salesforce.
PROCESS : QBPAYMENTS TO SF RECIEVABLES

SOLUTION : For 'AVSFQB_Total_Invoice_Amount_c' map the below mappings and save and close.



{
String x =VALUE("AppliedToTxnRet/BalanceRemaining");
String y =
VALUE("AppliedToTxnRet/Amount");
if(x!=null && y!=null && !x.isEmpty() && !y.isEmpty())
{
float B = Float.parseFloat(LOG(error));
float T = Float.parseFloat(LOG(thumbs up));

float P = ( T+ B );
return String.valueOf(P);
}
else
{
return "";
}

}

  • No labels