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 =E2=80=9CApplied_Date=E2=80=9D from QuickBooks ReceivePayment&nbs= p; into SalesForce (Invoice) Object
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
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
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") |