DBSync Cloud Workflow (iPaaS)

2022

Page tree

Versions Compared

Old Version 1

changes.mady.by.user Anil Bhimineni

Saved on

compared with

New Version Current

changes.mady.by.user Munira Majumdar

Saved on

Key

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

Issue 1 : There are few missing invoices from QuickBooks to Dynamics CRM.

Description: Whenever you happen to You may notice few of missing Invoices in Dynamics CRM online, Due to web-connector . This may happen because either (1) the Web-Connector schedule is off for few days or Web-Connector ; or (2) it is turned off for server maintenance; or, (3) for any other reason reasons. If this happens then, follow the steps below steps in resolution to get back those missing invoices.


Resolution: You needs need to login to DBSync account>>Click on Development Studio>>Select the Project name>>Click on the Workflow (Example-Invoice to opportunity)>>Then >> Then, in trigger section of Query  Switch Query, switch to Advanced View>>Then replace the Query Query. 

From 


Code Block
select * from Invoice, Customer whereWhere Invoice.MaxReturned=100 and Invoice.ModifiedDateRangeFilter.FromModifiedDate=$last_success_run and Invoice.IncludeLineItems=true and Invoice.OwnerID=0 join on Invoice.CustomerRef.FullName=Customer.FullName


To 


Code Block

select * from Invoice,Customer where Invoice.MaxReturned=500 and Invoice.TxnDateRangeFilter.FromTxnDate= '2017-07-12' and 
Invoice.TxnDateRangeFilter.ToTxnDate= '2017-07-15' and Invoice.IncludeLineItems=true and Invoice.OwnerID=0 join on Invoice.CustomerRef.FullName=Customer.FullName

The  FromTxnDate and ToTxnDate date should have Invoice dates for which the Transaction are missed in Dynamics CRM online.

...