2022

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

Payment “Applied_Date” from QuickBooks ReceivePayment  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=100 and ReceivePayment.ModifiedDateRangeFilter.FromModifiedDate=$last_success_run and ReceivePayment.IncludeLineItems=true and ReceivePayment.OwnerID=0

Create a new rule:  

Select Target as "SalesForce" use the "Update" call and select the target Object as "AVSFQB__Invoices__c"

Please find the screenshot for above rule to create:


Add the following mapping in the mapping window and click on Save & Close button and then click on “Save Workflow” button to save entire WorkFlow


Id

=

TLOOKUP("select Id from AVSFQB__Invoices__c where AVSFQB__Quickbooks_Id__c='"+VALUE("AppliedToTxnRet/TxnID")+"'")

Payment_Applied__c

=

VALUE("TxnDate")

  • No labels