DBSync Cloud Workflow (iPaaS)

2022

Page tree

Versions Compared

Old Version 1

changes.mady.by.user Anitha Ramesh

Saved on

compared with

New Version Current

changes.mady.by.user Anitha Ramesh

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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.

Anchor
_GoBack
_GoBack

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 "";
}

}