Message-ID: <1667341581.86129.1711696531329.JavaMail.wiki@ip-172-26-1-188> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_86128_554955042.1711696531326" ------=_Part_86128_554955042.1711696531326 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html Payment Applied - Date from Quickbooks to Salesforce

Payment Applied - Date from Quickbooks to Salesforce

Create= new DBSync Workflow under same Project and use the following DBSync query = to fetch the records from QuickBooks  ReceivePayment Object

DBSync= Query :

select= * from ReceivePayment where ReceivePayment.MaxReturned=3D100 and ReceivePa= yment.ModifiedDateRangeFilter.FromModifiedDate=3D$last_success_run and Rece= ivePayment.IncludeLineItems=3Dtrue and ReceivePayment.OwnerID=3D0

Create= a new rule:  

Select= Target as "SalesForce" use the "Update" call and select = the target Object as "AVSFQB__Inv= oices__c"

Please= find the screenshot for above rule to create:

=


Add the following mapping in the ma= pping window and click on Save & Close&n= bsp;button and then click on =E2=80=9CSave Workflow=E2=80=9D button to save entire WorkFlow


Id

=3D

TLOOKUP("select Id from AVSFQB__Invoices__c where AVSF= QB__Quickbooks_Id__c=3D'"+VALUE("AppliedToTxnRet/TxnID")+"'")

Payment_= Applied__c

=3D

VALUE("TxnDate")

------=_Part_86128_554955042.1711696531326--